MySQL Basics In Pictures

Since the id field can't be blank (it has a NOT NULL property), putting a NULL value in it forces MySQL to automatically number the record (because the id field also has the property AUTO_INCREMENT).

The data in the table name is now organized like this:

Fields:

id

first

last

Record:

1

George

Washington

TIP: Text is enclosed within single quotes to let MySQL know that it's just text, not a command.

If the phrase

'What is the first name of the president named Washington whose values kept him from cutting down the cherry tree?'

was not enclosed in single quotes, MySQL might interpret the words name and values as commands, and get confused.

In these examples, single-quotes are used. Double-quotes perform the same function.