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;
}
