MySQL e hlakola tafole ea data joang? MySQL database e hlakola taelo ea tafole ea data / polelo / syntax

MySQLJoang ho hlakola tafole ea data?MySQL databasehlakola taelo ea data / polelo / syntax

MySQL hlakola tafole

Ho bonolo haholo ho hlakola litafole tsa data ho MySQL, empa u lokela ho ba hlokolosi haholo ha u hlakola litafole, hobane data eohle e tla nyamela kamora ho etsa taelo ea ho hlakola.

sebōpeho-puo

E latelang ke syntax e akaretsang ea ho hlakola tafole ea MySQL:

DROP TABLE table_name ;

Hlakola tafole ea data ka fensetere ea taelo ea kapele

Fensetereng ea mysql> taelo ea kapele hlakola polelo ea data ea SQL ke TS'ELISI TABELA :

Mohlala

Mohlala o latelang o hlakola tafole ea data 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>

Hlakola datatable u sebelisa PHP script

PHP e sebelisa mosebetsi oa mysqli_query ho hlakola litafole tsa MySQL.

Ts'ebetso e na le liparamente tse peli 'me e khutlisa TRUE haeba ts'ebetso e atlehile, ho seng joalo e khutlisa FALSE.

h3> poleloana

mysqli_query(connection,query,resultmode);

Mohlala

Mohlala o latelang o sebelisa sengoloa sa PHP ho hlakola tafole ea data 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);
?>

Kamora hore ts'ebetso e atlehe, ha re bone tafole ea chenweiliang_tbl ka ho sebelisa taelo e latelang:

mysql> show tables;
Empty set (0.01 sec)