MySQL Basics In Pictures

• Starting
• Administration
• Tables
• Queries
• Security
• Web

Here are the datatypes and properties for these fields:

• INT

  CREATE TABLE name (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, first CHAR(25), last CHAR(25) );

  The INT datatype for the id field ensures it will contain only integers—numbers, not text.

• NOT NULL

  CREATE TABLE name (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, first CHAR(25), last CHAR(25) );

  The NOT NULL property ensures the id field cannot be left blank.

• PRIMARY KEY

  CREATE TABLE name (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, first CHAR(25), last CHAR(25) );

  The PRIMARY KEY property makes id the key field in the table.

  In any database table, one field should be the key field—a field that can contain no duplicates. In this table, name, the id field is the key field because it contains the PRIMARY KEY property.

  This means the name table can't have two records with an id of 35.