Description: Learn how to use MySQL syntax with these references.

AND: This will do our command to two or more settings, I think reading the code will explain more than I can try to in normal English…

INSERT: Inserts a new row into an existing table of your database with the values you define for each field. Used in conjunction with mysql_connect() mysql_select_db() mysql_query()

ALTER: ALTER will change the table you specify, see the code example for a more clear idea of how it works…

NOT: This will SELECT all records from the db table WHERE ’something’ is NOT equal to ‘whatever’.

OR: The OR command will SELECT either one or the other… (again it is easier to look at the code to make sense of it.)

ORDER BY: Using ORDER BY will sort the results in a specific order based on the values of the desired column: see the example for more details…

CREATE TABLE: Using CREATE TABLE will do exactly that – create a new sql table in your database. See the example code for the syntax, each column you define also has to have a column data-type, this can be ‘text’, ‘char’, ‘blob’ amongst many, many

SELECT: The SELECT statement will select ’something’ FROM ’sometable’.

UPDATE: Using UPDATE will update a specified record with a new value. Or record in the db table.

DELETE: Using DELETE will remove (delete, even!) the record (row in the table) from the database. Usually used with a WHERE clause to restrict the deletion to a certain record or set of records.

WHERE: Used in conjuction with a SELECT statement, using WHERE will restrict the SELECT to a certain rule…