Collections:
Drop an Existing Table in MySQL
How To Drop an Existing Table in MySQL?
✍: FYIcenter.com
If you want to delete an existing table and its data rows, you can use the "DROP TABLE" statement as shown in the tutorial script below:
mysql> SELECT * FROM tipBackup; +----+-------------+-------------------------+-------------+ | id | subject | description | create_date | +----+-------------+-------------------------+-------------+ | 1 | Learn MySQL | Visit dev.fyicenter.com | 2006-07-01 | +----+-------------+-------------------------+-------------+ 1 row in set (0.40 sec) mysql> DROP TABLE tipBackup; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM tipBackup; ERROR 1146 (42S02): Table 'fyi.tipbackup' doesn't exist
Be careful, when you use the "DROP TABLE" statement. All data rows are gone too.
⇒ Create an Index for a Given Table in MySQL
⇐ Rename an Existing Table in MySQL
2018-02-14, 1358🔥, 0💬
Popular Posts:
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...