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 memory table in mysql?
What are the differences between char and nchar?
What is default schema in mysql?
How many threads can mysql handle?
When to use order by in delete statement?
what is database black box testing? : Mysql dba
How do I run a query in mysql?
Explain Access Control Lists.
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
What is row level locking?
Why do we use the mysql database server?
How many ways we can retrieve the date in result set of mysql using php?
what is mysql optimization in brief?
What is difference between mysql and mysqli?
Can you tell few best practices to be followed for optimization in sql?
