Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
This can depend on both your flavor of SQL and your personal preference - I've seen a number of schemes in use. For MySQL, the most common scheme I've seen used (and the scheme that my editor uses ...
Answer
#1: Initial revision
by
ArtOfCode
·
2020-08-17T17:16:31Z (over 3 years ago)
This can depend on both your flavor of SQL and your personal preference - I've seen a number of schemes in use. For MySQL, the most common scheme I've seen used (and the scheme that my editor uses in autocomplete suggestions) is to abbreviate using the first letter of each word. In a table called `posts`, the alias is `p`; in a table called `post_history_tags`, the alias is `pht`. There's really no one universal convention: use whatever makes sense to you and the developers working on the same project.