MySQL 删除数据表

DROP TABLE table_name ;

root@host# mysql -u root -p
Enter password:*******
mysql> use geekdocs;
Database changed
mysql> DROP TABLE geekdocs_tbl
Query OK, 0 rows affected (0.8 sec)
mysql>

mysqli_query(connection,query,resultmode);

<?php
dbhost = 'localhost:3306';  // mysql服务器主机地址dbuser = 'root';            // mysql用户名
dbpass = '123456';          // mysql用户名密码conn = mysqli_connect(dbhost,dbuser, dbpass);
if(!conn )
{
  die('连接失败: ' . mysqli_error(conn));
}
echo '连接成功<br />';sql = "DROP TABLE geekdocs_tbl";
mysqli_select_db( conn, 'geekdocs' );retval = mysqli_query( conn,sql );
if(! retval )
{
  die('数据表删除失败: ' . mysqli_error(conn));
}
echo "数据表删除成功\n";
mysqli_close($conn);
?>

mysql> show tables;
Empty set (0.01 sec)