Jump Start MySQL by Timothy Boronczyk

Author:Timothy Boronczyk
Language: eng
Format: mobi, epub, pdf
Publisher: SitePoint Pty. Ltd.
Published: 2015-08-16T04:00:00+00:00

Tip: Using the AS Keyword

The AS keyword is optional when you define a column or table alias. I typically don’t use AS to alias table names in my own day-to-day statements, but I’m using it here for clarity. Regardless, I always use AS with column names because it helps me make sure my column names are correctly separated by commas. Consider the following:

SELECT actor_id, first_name last_name FROM actor;

It’s not clear to someone else looking at the statement whether I’m missing a comma between first_name and last_name or foolishly aliasing first_name in my result set (MySQL will interpret it the second way). Following such conventions makes the intent clear, and thus we know the statement has an error.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.