MySQL Statements (Vocabulary List)


Esoteric Excel/VBA/Dashboard Training

* – in SQL language, a star refers to all fields in a table.

– in SQL language is programming script that is used to surround text values.

– in SQL language, the backslash before the apostrophe allows the apostrophe to be used in a text context, since a standalone apostrophe is part of the programming language.  An alternative is to use ” (two single quotes) to “escape” a single quote.

AND – when you want to include two conditions in a single query, you can combine conditions through the use of the AND keyword.

BETWEEN … AND … – When querying we can use these keywords to identify a number, say, between 30 and 60. (30 and 60 are included, the equivalent of using <= and >=)  Alternatively, we can search a text field for a word in the alphabet between ‘G’ and ‘K’, (which would include…

View original post 692 more words

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s