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 www.GlobalGuideLine.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 'ggl.tipbackup' doesn't existBe careful, when you use the "DROP TABLE" statement. All data rows are gone too.
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 www.GlobalGuideLine.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 'ggl.tipbackup' doesn't existBe careful, when you use the "DROP TABLE" statement. All data rows are gone too.
Comments Received:
Please give your suggestions and feedback: