MySQL rho tawm cov ntaub ntawv li cas? MySQL database rho tawm cov lus hais kom ua / nqe lus / syntax

Yuav ua li cas rho tawm ib lub rooj hauv MySQL ? MySQL database cov lus txib rho tawm lub rooj / cov lus hais / syntax

MySQL rho tawm rooj

Nws yooj yim heev rau rho tawm cov ntaub ntawv hauv MySQL, tab sis koj yuav tsum tau ceev faj heev thaum koj rho tawm cov ntxhuav, vim tias tag nrho cov ntaub ntawv yuav ploj tom qab ua tiav cov lus txib rho tawm.

qauv sau ntawv

Cov hauv qab no yog cov ntsiab lus dav dav rau kev rho tawm MySQL cov lus:

DROP TABLE table_name ;

Rho tawm cov ntaub ntawv hauv lub qhov rais hais kom ua

Hauv lub qhov rai mysql> command prompt, cov lus txib SQL los rho tawm lub rooj yog DROP TABLE :

piv txwv

Cov piv txwv hauv qab no tshem tawm cov ntaub ntawv rooj chenweiliang_tbl:

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

Rho tawm cov ntaub ntawv siv PHP tsab ntawv

PHP siv mysqli_query muaj nuj nqi los rho tawm MySQL ntxhuav.

Qhov kev ua haujlwm muaj ob qhov tsis muaj thiab rov qab TRUE yog tias kev ua tiav tiav, txwv tsis pub nws rov FALSE.

h3> syntax

mysqli_query(connection,query,resultmode);

piv txwv

Cov piv txwv hauv qab no siv cov ntawv PHP kom tshem tawm cov ntaub ntawv rooj chenweiliang_tbl:

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

Tom qab kev ua tiav tiav, peb tsis tuaj yeem pom lub rooj chenweiliang_tbl los ntawm kev siv cov lus txib hauv qab no:

mysql> show tables;
Empty set (0.01 sec)