Request to explain a topic

Database
#1

Hello sir,

I am requesting to explain Difference between Truncate and Delete.

Thanks and regards

#2

Truncate can remove the whole data from the table
syntax:- TRUNCATE TABLE TABLE_NAME;

DELETE can delete a particular data from the table by using where condition
syntax: DELETE from table_name where [condition]

it is not k-sensititve language so it does not matter for small and capital letters

1 Like
#3

I have a doubt regarding assignment question, i am unable to write the correct query for joing date.