+ 5

What the deffrence between drope and delete in mysql

17th Jun 2018, 9:16 PM
MOHAMED BURMA MOHAMED ABDALLA
MOHAMED BURMA MOHAMED ABDALLA - avatar
2 Answers
+ 3
drop statement affects the structure of the item (tables or views as example), or remove the item itself, but delete affects the data which inserted in the table. (DDL vs DML)😉 Hope it's helping..
17th Jun 2018, 9:58 PM
ADIL GAAFER
ADIL GAAFER - avatar
+ 1
drop- remove table delete- remove row in table
21st Jun 2018, 8:53 PM
Arman Minasyan