MySQL Main Query Types

SELECT

SELECT * FROM tablename

INSERT

INSERT INTO tablename (col1, col2, col3,..) VALUES (val1, val2, val3,…)

UPDATE

UPDATE tablename SET `col1`=`val1`, `col2`=`val2`, `col3`=`val3`,…

DELETE

DELETE FROM tablename WHERE `col4`=`val6`

Note

You will use a lot of WHERE clauses as well along with the above.

e.g. SELECT * FROM tablename WHERE `id`=’15’

In PHP

Calling to MySQL is really easy in PHP, just use the mysql_query() function.

e.g.

mysql_query("SELECT * FROM tablename")
$query = mysql_query("SELECT * FROM tablename");
while ($result = mysql_fetch_object($query)) {
echo $result->aColumnNameInMysql;
}