Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is normalization and list the different types of normalization?
Which software is used for mysql?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
How can you change the name of any existing table by using the sql statement?
What is difference between inner vs self vs cross?
How do I install mysql workbench?
How can we optimize stored procedure?
Write a program using the select statement, while loop.
What are the steps involved in query processing?
Why we use mysqli instead of mysql?
How to get the number of rows selected or affected by a sql statement?
How many columns can a table have?
Why MySQL is used?
What is sql vs mysql?
What is the limit of mysql database?
