Shulou(Shulou.com)06/02 Report--

This article introduces the relevant knowledge of "MySQL Delete PHP has what role". In the actual case operation process, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

Delete statements are used to delete rows from database tables.

Delete data from database

Delete From statement is used to delete records from database tables.

syntax

DELETE FROM table_name

WHERE some_column = some_value

Note: Note the WHERE clause in the Delete syntax. The WHERE clause specifies which records need to be deleted. If you omit the WHERE clause, all records will be deleted!

In order for PHP to execute the above statement, we must use the mysqli_query() function. This function is used to send queries or commands to MySQL connections.

examples

Please see the "Persons" table below:

FirstName LastName Age

Peter Griffin 35

Glenn Quagmire 33

The following example deletes all records in the "Persons" table where LastName='Griffin':

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.