filmov
tv
SQL delete table command by using DROP query and before deleting checking if TABLE exists
Показать описание
We can delete table by using this query
DROP table table_name
If the table is not existing then we will get error message, if we don’t want to error message then we can use this query. This query will generate warning ( not error ) message if the table student is not available.
DROP table IF EXISTS student
We can delete multiple tables by using this command
DROP TABLE student1, student2, student3, student4
Copy of student mysql dump
Tutorial on Delete table
#SQL #DeleteTable #queryDelete #plus2net #MySQLDelete #DeleteQuery #DeleteIfExists #plus2net
DROP table table_name
If the table is not existing then we will get error message, if we don’t want to error message then we can use this query. This query will generate warning ( not error ) message if the table student is not available.
DROP table IF EXISTS student
We can delete multiple tables by using this command
DROP TABLE student1, student2, student3, student4
Copy of student mysql dump
Tutorial on Delete table
#SQL #DeleteTable #queryDelete #plus2net #MySQLDelete #DeleteQuery #DeleteIfExists #plus2net