Tuesday, 9 June 2020

delete

how to delete the row from table
delete from dummy.studentinfo where name=4;
how to delete the total table
drop table dummy.studentinfo;
how to delete the database required
drop database database1;








DELETE
DELETE FROM table_name WHERE condition;
DELETE ROW
DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';
DELETE FROM table_name;
DELETE ALL RECORDS





delete from where
drop table
drop database


how to delete the row of matched only



how to delete the total table



how to delete the database

No comments:

Post a Comment