Computer Science, asked by himadrisahu114, 12 hours ago

What is the difference between truncate and delete in MYSQL?

Answers

Answered by sakash20207

Delete is a DML command whereas truncate is DDL command. .Truncate can be used to delete the entire data of the table without maintaining the integrity of the table. On the other hand , delete statement can be used for deleting the specific data.

Answered by Anonymous

sorry

I don't know about this question .

. ________________________________

...

....

Previous Question

Next Question

Similar questions

Math, 7 hours ago

(-108)÷(-12) with step by step...

Physics, 7 hours ago

When the compression is incident on rigid wall it is reflected 1)Compression with a phase change of p. 2)Compression with no phase change. 3)Rarefaction with a phase change of p. 4)Rarefaction with no phase change ...

Social Sciences, 7 hours ago

5. Que. 2- Tick the correct answer :- 1. The southernmost Himalayas are known as, a) Shiwaliks b) Himadri c) Himachal 2. Sahyadras is also known as, a) Aravali b) Western Ghats c) Himadri 3. The oldest mountain range in India is the a) Aravali Hills b) Western Ghats c)'Himalayas 4. The world's highest rainfall occurs in. a) Mumbai b) Asansol c) Mawsynram 5. Mangrove forests can thrive in, a)...

Math, 12 hours ago

let A={p, q, r, s}and R be a universal relation On A. write down the relation R. find out the smallest and largest subset Of The universal relation which is equivalence relation?

Math, 12 hours ago

1. समीकरण 4 sin-e-1 के हल हैं: (a) nπ +π\3 (b) 2nπ+π\3 (c) nπ+π\6 (b) 2nπ-π\3 (d) 2nπ .

Math, 7 months ago

In the adjoinig figure if line m || line n and line p is a transversal then find x ...

India Languages, 7 months ago

बर्बाद होने याचा अर्थ काय आहे ...

History, 7 months ago

How can picnics be part of social harmony?

What is the difference between truncate and delete in MYSQL?​

Answers

What is the difference between truncate and delete in MYSQL?