E faʻafefea ona tape e MySQL se laulau faʻamatalaga? MySQL database tape fa'atonuga laulau fa'amatalaga/fa'amatalaga/syntax

MySQLE fa'afefea ona tape le laulau fa'amaumauga?MySQL databasetape le faʻatonuga faʻamaumauga / faʻamatalaga / syntax

MySQL tape laulau

E faigofie tele le tapeina o laulau faʻamaumauga i MySQL, ae e tatau ona e matua faʻaeteete pe a e tapeina laulau, aua o faʻamaumauga uma o le a mou atu pe a uma ona faʻatinoina le faʻatonuga tape.

kalama

O loʻo taua i lalo le faʻasologa lautele mo le tapeina o se laulau MySQL:

DROP TABLE table_name ;

Aveese le laulau fa'amatalaga ile fa'amalama fa'atonu

I le mysql> command prompt window tape le laulau faʻamatalaga SQL faʻamatalaga o LA'AU FA'ATU :

Fa'ata'ita'iga

Ole fa'ata'ita'iga lea e tapeina le laulau fa'amaumauga 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>

Ave'ese fa'amaumauga e fa'aaoga ai le PHP script

PHP fa'aaoga le mysqli_query galuega e tape ai MySQL laulau.

O le galuega e lua taʻiala ma toe faʻafoʻi le TRUE pe a manuia le faʻatinoga, a leai e toe foʻi mai le FALSE.

h3> fa'asologa

mysqli_query(connection,query,resultmode);

Fa'ata'ita'iga

O le fa'ata'ita'iga o lo'o i lalo e fa'aaoga ai le PHP script e tape ai le laulau fa'amaumauga 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);
?>

A maeʻa le faʻataunuʻuina, e le mafai ona tatou vaʻaia le laulau chenweiliang_tbl e ala i le faʻaaogaina o le poloaiga lenei:

mysql> show tables;
Empty set (0.01 sec)