Answer Posted / udhayakumar
delete is used to delete one or more rows from the table
where as truncate to delete all the rows without its
structure from the table
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how to use 'mysql' to run sql statements? : Sql dba
What is rename command in sql?
What does stand for in sql?
How is indexing done in search engines?
what is the difference between myisam static and myisam dynamic? : Sql dba
Write a sql query to convert all character to uppercase after hypen.
How insert into statements in sql?
Explain two easy sql optimizations.
How does postgresql compare to oracle/db2/ms sql server/informix?
how to concatenate two character strings? : Sql dba
How to avoid duplicate records in a query?
What are local and global Indexes and where they are useful.
Does sql use python?
What are the properties of a transaction?
What is sql*plus?
