CREATE TABLE <new table name> (
	fieldname fieldtype (options),
	fieldname2 fieldtype2 (options2),
	...
);

example:
CREATE TABLE example_table (
  id int(10) DEFAULT '0' NOT NULL auto_increment,
  status tinyint(3),
  username varchar(20),
  email varchar(255),
  description text,
  datecreated datetime,
  lastupdated datetime,
  PRIMARY KEY (id)
);
			

ALTER TABLE <table> DROP <field>;

ALTER TABLE <table> CHANGE <oldfieldname> <newfieldname> <fieldtype> <fieldoptions>;

examples:
ALTER TABLE example_table ADD password varchar(8) AFTER username;

ALTER TABLE example_table DROP datecreated;

ALTER TABLE example_table CHANGE description personal_profile varchar(255);

examples:
INSERT INTO example_table (id,status,username,datecreated) VALUES (NULL,1,'testuser',NOW());

INSERT INTO example_table VALUES (NULL,1,'testuser','testuser@mysql.com','This is a description.',NOW(),NULL);

Special Cases: If a field is defined as auto_increment then "NULL" should be passed.
Formatting: Dates and times can be in a number of formats but the recommended format is: yyyy-mm-dd hh:mm:ss

examples:
DELETE FROM example_table; - Deletes all rows from example_table

DELETE FROM example_table WHERE id=1; - Deletes only the row with id 1

DELETE FROM example_table WHERE username LIKE 'u%'; - Deletes all rows where the username starts with "u"

examples:
UPDATE example_table SET username='newusername',lastupdated=NOW() WHERE id=1; - Changes the username for the user with id 1 to "newusername" and changes the 'lastupdated' field to the current date and time

examples:
SELECT * FROM example_table; - selects all data in each row

SELECT id,status,username FROM example_table; - selects 3 fields from every row

SELECT id,status,username FROM example_table WHERE username='user'; - selects 3 fields from every row that corresponds to the username "user"

SELECT id,status,username FROM example_table WHERE username='user' ORDER BY datecreated,lastupdated; - same as above ordered by when the user's were created, and when the datecreated is the same orders by when their record was last updated

SELECT COUNT(*) FROM example_table; - returns the number of rows in the table

SELECT id,status,username FROM example_table WHERE (username='user' AND password='pass'); - selects fields from every row where the username is "user" and the password is "pass" (both must be true)

SELECT id,status,username FROM example_table WHERE username LIKE 'u%'; - selects fields from every row where the username starts with "u" and is followed by 0 or more characters

SELECT id,status,username FROM example_table WHERE username LIKE 'u%' LIMIT 0,5; - same as above except will only return 5 rows starting at the 0th (first row found) row

SELECT id,status,username FROM example_table WHERE username LIKE '%u' ORDER BY username,lastupdated DESC LIMIT 1,6; - similar to above but the username's are first ordered alphabetically and the 1st-6th (second through seventh) rows are returned

Multi-table

SELECT table1.id AS userid, table2.email AS useremail, table2.lastupdated AS last_login FROM table1,table2 WHERE ((table1.id > 10 AND table2.email LIKE '%@%') AND (table1.id = table2.id)) ORDER BY email DESC LIMIT 0,20; - can you guess?

The field list may contain a number of specialized variants including, *, COUNT(*). The "AS" keyword allows a field name to be aliased to another, for example: SELECT verylongfieldname AS vlfn makes the values in "verylongfieldname" appear as values in a field named "vlfn" instead.

Fields may be selected from multiple tables in the same query, but may require a field to be related in each table. When selecting from multiple tables non-unique fields will conflict if the table name is not included, for example if you are selecting from table1 and table2 and both have an "id" field then the field(s) you are selecting and the field(s) you are querying will need to be stated completely, such as table1.id and table2.id .

• When specifying a field value that is not an integer or NULL the value must be included in <single quotes>, Example: username='brianm'
• When using a field value that is included in single quotes, all single quotes therein must be "escaped", the escape sequence is one of: \' or '' Example: field value = can't, would look like contraction='can\'t' -or- contraction='can''t'
• When creating a table with an auto_increment field, the field must be of an integer type (any size) and must be established as a PRIMARY KEY (see example under CREATE)