Deleting a data table in MySQL is very easy to do, but you should be careful when you delete a table, because all the data disappears when you execute the delete command.
GrammarThe following is a general syntax for deleting MySQL data tables:
To delete a data table in a command prompt window;
Delete the data table in the Mysql> Command Prompt window The SQL statement is drop table :
InstanceThe following example deletes the data table tutorials_tbl:
Delete a data table using a PHP script[Email protected] # mysql-u root-pEnter password:* ******mysql>use tutorials; Database changedmysql> DROP TABLE tutorials_tblQuery OK,0(0.8 SEC)mysql>
PHP uses the mysql_query function to delete MySQL data tables.
The function has two parameters, returns TRUE on successful execution, or FALSE.
h3> syntax
BOOL mysql_query( sql,);
| Parameters | Description |
|---|---|
| Sql | Necessary. Specifies the SQL query to send. Note: The query string should not end with a semicolon. |
| Connection | Optional. Specifies the SQL connection identifier. If not specified, the previous open connection is used. |
The following example uses a PHP script to delete a data table tutorials_tbl:
<title>Creating MySQL Tables</title><body><?Php$dbhost= ' localhost:3036 ';$dbuser= ' Root ';$dbpass= ' Rootpassword ';$conn=Mysql_connect($dbhost,$dbuser,$dbpass);If(!$conn){ Die(' Could not connect: ' .Mysql_error());}Echo' Connected successfully<br/> ';$sql= "DROP TABLE tutorials_tbl";mysql_select_db( ' Tutorials ' );$retval=Mysql_query($sql, $conn ); if (! $retval ) { die ( ' Could not delete table: '
MySQL Delete data table
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
