I-MySQL ilisusa kanjani ithebula ledatha? Isizindalwazi se-MySQL sisusa umyalo wetafula ledatha/isitatimende/i-syntax

MySQLUlisusa kanjani ithebula ledatha?MySQL databasesusa umyalo wedathatable/isitatimende/i-syntax

Ithebula le-MySQL lokususa

Kulula kakhulu ukususa amatafula edatha ku-MySQL, kodwa kufanele uqaphele kakhulu lapho ususa amatafula, ngoba yonke idatha izonyamalala ngemva kokwenza umyalo wokususa.

uhlelo lolimi

Okulandelayo i-syntax evamile yokususa ithebula le-MySQL:

DROP TABLE table_name ;

Susa ithebula ledatha efasiteleni lomyalo womyalo

Ewindini le-mysql> umyalo susa isitatimende sedatha ye-SQL DROP TABLE :

Isibonelo

Isibonelo esilandelayo sisusa ithebula ledatha elithi 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>

Susa i-datatable usebenzisa umbhalo we-PHP

I-PHP isebenzisa umsebenzi we-mysqli_query ukususa amatafula e-MySQL.

Umsebenzi unamapharamitha amabili futhi ubuyisela TRUE uma ukwenza kuphumelele, ngaphandle kwalokho ubuyisela FALSE.

h3> i-syntax

mysqli_query(connection,query,resultmode);

Isibonelo

Isibonelo esilandelayo sisebenzisa umbhalo we-PHP ukususa ithebula ledatha elithi 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);
?>

Ngemuva kokuthi ukubulawa kuphumelele, asikwazi ukubona ithebula le-chenweiliang_tbl ngokusebenzisa umyalo olandelayo:

mysql> show tables;
Empty set (0.01 sec)