Ta yaya MySQL ke share bayanan bayanai?Share MySQL bayanan bayanan umarni/syntax/bayani

MySQLYadda ake share bayanan bayanai?shareMySQL databaseUmurni/Syntax/Sanarwa

MySQL share database

sauke database ta amfani da mysqladmin

Shiga cikin uwar garken mysql azaman mai amfani na yau da kullun, ƙila ku buƙaci takamaiman gata don ƙirƙira ko share bayanan MySQL.

Don haka muna amfani da root user don shiga nan, tushen mai amfani yana da mafi girman iko kuma yana iya amfani da umarnin mysql mysqladmin don ƙirƙirar bayanai.

Dole ne a kula sosai lokacin share bayanan bayanai, saboda duk bayanan za su shuɗe bayan an aiwatar da umarnin sharewa.

Misalin da ke gaba yana share ma'ajin bayanai (an ƙirƙiri bayanan a babin da ya gabata):

[root@host]# mysqladmin -u root -p drop chenweiliang
Enter password:******

Bayan aiwatar da umarnin share bayanan da ke sama, akwatin gaggawa zai bayyana don tabbatar da ko an goge bayanan da gaske:

Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'chenweiliang' database [y/N] y
Database "chenweiliang" dropped

Share bayanai ta amfani da rubutun PHP

PHP yana amfani da aikin mysqli_query don ƙirƙira ko share bayanan MySQL.

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

nahawu

mysqli_query(connection,query,resultmode);

misali

Misali mai zuwa yana nuna amfani da aikin PHP mysqli_query don share bayanan bayanai:

<?
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 aiwatarwa, sakamakon lambar shine:

连接 成功

Database chenweiliang ya yi nasara

Lura: A lokacin da ake goge ma’adanar bayanai ta hanyar amfani da rubutun PHP, sakon tabbatarwa ba zai bayyana ba, kuma za a goge bayanan da aka kayyade kai tsaye, don haka ya kamata a kiyaye sosai wajen goge bayanan.