Do you know what is the use of TRUNCATE statement? How is it different from DELETE statement?
Submitted by: MuhammadTRUNCATE TABLE statement is used to delete a table permanently. It deletes all the records from the table.
Syntax:
TRUNCATE [TABLE] [database_name.]table_name;
Difference between DELETE and TRUNCATE statement:
☛ DELETE statement is used to remove one or more columns from a table as well as whole table. On the other hand, TRUNCATE TABLE statement is used to delete the whole table permanently.
☛ TRUNCATE TABLE statement is same as DELETE statement without a WHERE clause.
Submitted by: Muhammad
Syntax:
TRUNCATE [TABLE] [database_name.]table_name;
Difference between DELETE and TRUNCATE statement:
☛ DELETE statement is used to remove one or more columns from a table as well as whole table. On the other hand, TRUNCATE TABLE statement is used to delete the whole table permanently.
☛ TRUNCATE TABLE statement is same as DELETE statement without a WHERE clause.
Submitted by: Muhammad
Read Online MariaDB Job Interview Questions And Answers
Top MariaDB Questions
☺ | Tell me what Version Of Mariadb Is Workable On Windows 7 X64? |
☺ | Do you know what Is The Goal Of Mariadb? |
☺ | Tell me can I Get Help With Mariadb? Something's Broken!? |
☺ | Please explain what are the main features of MariaDB? |
☺ | Tell me how can you retrieve limited number of records from a table? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |