Web development lesson 45 php mysql delete query example



Published
#pashto #deleting_data
deleting data from database tables
Using the SQL DELETE statement, you can remove records from a table much like when you insert data into a table. When combined with the WHERE clause, it is often used to remove only the records that meet certain requirements.

The DELETE statement's fundamental grammar is as follows:

DELETE FROM table_name WHERE column_name=some_value

Let's create a SQL query that uses the DELETE statement and the WHERE clause, then we'll run it by providing it to the PHP mysqli query() function to remove the records from the tables. Think about the people table in the demonstration database:
Category
Web design
Be the first to comment