How do you delete records from mysql

[todayme]

Could someone please show me how to delete records from mysql.

 

Maybe even an example in a loop that deletes records based on a criteria.

[mem0ri]

Syntax:

 

DELETE FROM table WHERE condition

 

 

For more info, go to http://www.mysql.com, click 'documentation', and search for "DELETE SYNTAX"

[PC Nerd]

isnt it DROP

 

cant remember whether DROP is for racords of fields

 

 

goodluck

 

[Iceman512]

Hi there,

 

Here's an excellent resource for a solid grounding in DELETE for PHP, MySQL: http://www.w3schools.com/php/php_mysql_delete.asp

 

Otherwise, the query will have to look something like this:

 

mysql_query("DELETE FROM Person WHERE LastName='Griffin'");

 

Regards,

Iceman

[bilis_money]

drop is deleting the entire table or database.