MySQL Main Query Types Used in PHP to Select, Insert, Update and Delete Data

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