MySQL inodzima sei tafura yedata? MySQL dhatabhesi bvisa data tafura yekuraira / chirevo / syntax

MySQLNzira yekudzima tafura yedata?MySQL databasebvisa datatable command/statement/syntax

MySQL bvisa tafura

Zviri nyore kwazvo kudzima matafura edata muMySQL, asi iwe unofanirwa kungwarira paunodzima matafura, nekuti data rese rinopera mushure mekuita yekudzima kuraira.

girama

Inotevera ndiyo yakajairika syntax yekudzima tafura yeMySQL:

DROP TABLE table_name ;

Bvisa tafura yedata muwindo rekuraira

Mune mysql> yekuraira yekukurumidza hwindo bvisa iyo data tafura SQL statement iri DROP TABLE :

muenzaniso

Muenzaniso unotevera unodzima tafura yedata 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>

Delete datatable uchishandisa PHP script

PHP inoshandisa mysqli_query basa kudzima MySQL matafura.

Basa racho rine maparamendi maviri uye rinodzorera TRUE kana kuurayiwa kwabudirira, zvikasadaro inodzorera FALSE.

h3> syntax

mysqli_query(connection,query,resultmode);

muenzaniso

Muenzaniso unotevera unoshandisa PHP script kudzima tafura yedata 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);
?>

Mushure mekubudirira kuurayiwa, hatigone kuona iyo chenweiliang_tbl tafura nekushandisa unotevera kuraira:

mysql> show tables;
Empty set (0.01 sec)