Answer Posted / senthil d
Delete Command - Options to Delete particular record using
where clause and to delete all records. Table structure
remains. But it slower in performance as we compared with
truncate command
Drop Command - Drops the entire table from data base
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How is data stored in mysql?
How to find second highest salary from a table?
How many TRIGGERS are allowed in MySql table?
How do you rename a procedure in mysql?
Which statement is used to delete a table in MySQL.
What is the difference between the LIKE and REGEXP operators?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
How can you find out the version of the installed mysql?
How to Change a users password from unix shell.
How we can get the current date in mysql?
How to calculate the difference between two time values?
What is inner join in mysql?
What is difference between mysqli and pdo?
How many sql dml commands are supported by 'mysql'?
How do I exit mysql?
