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`,...
Code language: JavaScript (javascript)

DELETE

DELETE FROM tablename WHERE `col4`=`val6`
Code language: JavaScript (javascript)

Note

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

e.g.

SELECT * FROM tablename WHERE `id`='15'
Code language: JavaScript (javascript)

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; }
Code language: PHP (php)
Tags:
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments