Answer Posted / lalit samant
Where clause can de used with delete .
You can use where clause with drop or truncate
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to update info already in a table and delete a row(s) from a table.
Is mysql from oracle?
Write a query to fetch duplicate records from a table using mysql?
What does the file with the extension: frm, myd, and myi contain?
What is unsigned int in mysql?
I want to find out all databases starting with ‘test’, I have access to?
How to increment dates by 1 in mysql?
How do I restore a mysql database dump file in linux?
Tell us something about heap tables?
How many sql ddl commands are supported by 'mysql'?
What storage engines are used in MySQL?
In how many ways we can retrieve data in the result set of mysql using php?
What is cursor in mysql?
How many threads can mysql handle?
How to run a sql statement?