All for Joomla All for Webmasters

SQL DELETE ALL ROWS

The statement SQL DELETE ALL ROWS is used to delete all rows from the table. If you want to delete all the rows from student table the query would be like,

  1. DELETE FROM STUDENT_NAME;

Resulting table after using this query:

ID STUDENT_NAME ADDRESS
PinIt
submit to reddit

Leave a Reply

Top