Computer Science, asked by himadrisahu114, 1 month 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

Physics, 21 days ago

A point object lies inside a transparent solid sphere of radius 20 cm and of refractive index n = 2. When the object is viewed from air through the nearest surface it is seen at a distance 5 cm from the surface. Find the apparent distance of object when it is seen through the farthest curved surface. 20cm Ans is 80 plz ecplain correctly ...

Biology, 21 days ago

4.-on-- 5. W--d-- 6.--r--lade 7.B---- 8.--f--ite 9. C--fr--t 10.--sul-. 11.D--gu--e 12. -- ti -- 13. Ap --0-- iate 14.--t--at 15. P--pa-- 16.-- ad -- ller 17.D---- 18. --n--de 19. C-- fecti -- ery 20.-- m -- is 21.----re 22. tr-ch 23. -- fe--e IT >>...

Math, 21 days ago

Find mean of the following distribution : 1) x : 0 1 2 3 4 5 f : 12 18 15 9 3 3 2) x : 15 16 17 18 19 20 f : 12 18 15 9 3 3 ...

Math, 1 month 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, 1 month ago

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

Math, 8 months ago

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

India Languages, 8 months ago

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

History, 8 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?