SQL Delete Statement

0
125

sqltuts

If you want to delete a record from any MySQL table, then you can use SQL DELETE Statement.

1.)command at mysql> prompt

2.) any script like PHP.

The WHERE clause is used when a uuser wantsto delete selected rows in a table of a given database.

Deleting Data from Command Prompt:

SQL DELETE Statment with WHERE clause is used in order to delete selected data into MySQL table tutorials_table.

Example:

Deleting Data Using PHP Script:

Example:

 

 

Facebook Comments

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.