Ta yaya MySQL ke share teburin bayanai? MySQL database share bayanan tebur umarnin/bayani/ syntax

MySQLYadda ake share teburin bayanai?MySQL databaseshare bayanan bayanai/bayani/ syntax

MySQL goge tebur

Yana da sauƙi a goge tebur ɗin bayanai a cikin MySQL, amma ya kamata ku yi hankali sosai lokacin da kuke share tebur, saboda duk bayanan za su ɓace bayan aiwatar da umarnin sharewa.

nahawu

Mai zuwa shine jumlar jumla don share tebur MySQL:

DROP TABLE table_name ;

Share tebur bayanai a cikin taga umarni da sauri

A cikin mysql> umarni da sauri taga share bayanan bayanan SQL bayanin shine SAUKAR TEBLAR :

misali

Misali mai zuwa yana share teburin bayanai 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>

Share bayanai ta amfani da rubutun PHP

PHP yana amfani da aikin mysqli_query don share tebur MySQL.

Aikin yana da sigogi biyu kuma yana dawo da GASKIYA idan aiwatarwar ya yi nasara, in ba haka ba ya dawo KARYA.

h3> syntax

mysqli_query(connection,query,resultmode);

misali

Misali mai zuwa yana amfani da rubutun PHP don share teburin bayanai 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);
?>

Bayan nasarar aiwatar da aiwatarwa, ba za mu iya ganin teburin chenweiliang_tbl ta amfani da umarni mai zuwa ba:

mysql> show tables;
Empty set (0.01 sec)