Sidee MySQL u tirtirtaa miiska xogta? Xogta MySQL tirtir amarka miiska xogta/bayaan/ syntax

Sidee loo tirtiraa jadwalka MySQL ? Amarka/hadallada/qoraalka tirtirka miiska xogta MySQL

MySQL tirtir miiska

Aad bay u fududahay in la tirtiro miisaska xogta ee MySQL, laakiin waa inaad aad uga taxadartaa markaad tirtirto miisaska, sababtoo ah dhammaan xogta way baaba'aysaa ka dib markaad sameyso amarka tirtirka.

naxwaha

Kuwa soo socda ayaa ah ereyga guud ee tirtiridda miiska MySQL:

DROP TABLE table_name ;

Tirtir shaxda xogta ee daaqada degdega ah

Daaqadda mysql> ee amarka, bayaanka SQL ee lagu tirtirayo jadwalka waa DROP TABLE :

tusaale

Tusaalaha soo socdaa waxa uu tirtirayaa shaxda xogta 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>

Tirtir xogta la adeegsan karo adigoo isticmaalaya qoraalka PHP

PHP waxay isticmaashaa shaqada mysqli_query si ay u tirtirto miisaska MySQL.

Shaqadu waxay leedahay laba xuduud waxayna soo celisaa RUN haddii fulinta lagu guuleysto, haddii kale waxay soo noqotaa BEEN.

h3> syntax

mysqli_query(connection,query,resultmode);

tusaale

Tusaalaha soo socdaa wuxuu isticmaalaa qoraalka PHP si uu u tirtiro shaxda xogta 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);
?>

Kadib fulinta guusha leh, ma arki karno miiska chenweiliang_tbl anagoo adeegsanayna amarka soo socda:

mysql> show tables;
Empty set (0.01 sec)