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, 1873🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...