Ingaba iMySQL iyicima njani idatabase?Cima i-MySQL yedatha yomyalelo/isintaksi/ingxelo

MySQLUcima njani uvimba weenkcukacha?cimaMySQL databaseUmyalelo/Isintaksi/Ingxelo

MySQL cima idatabase

yehlisa isiseko sedatha usebenzisa i-mysqladmin

Ngena kwiseva ye-mysql njengomsebenzisi oqhelekileyo, unokufuna amalungelo athile okudala okanye ukucima i-MySQL yolwazi.

Ke sisebenzisa ingcambu yomsebenzisi ukungena apha Umsebenzisi wengcambu unegunya eliphezulu kwaye unokusebenzisa umyalelo we-mysql mysqladmin ukwenza idatabase.

Qaphela kakhulu xa ucima isiseko sedatha, njengoko yonke idatha iya kube ingekho emva kokuba umyalelo wokucima uphunyeziwe.

Lo mzekelo ulandelayo ucima i-database chenweiliang (uvimba weenkcukacha wenziwa kwisahluko esingaphambili):

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

Emva kokuphumeza lo myalelo ungasentla ukucima i-database, ibhokisi ye-prompt iya kubonakala iqinisekisa ukuba i-database icinyiwe ngokwenene:

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

Cima idatabase usebenzisa iscript sePHP

I-PHP isebenzisa umsebenzi we-mysqli_query ukwenza okanye ukucima i-MySQL yogcino-lwazi.

Umsebenzi uneparameters ezimbini kwaye ubuyisela TRUE ukuba uphumezo luphumelele, kungenjalo ibuyisela FALSE.

Igrama

mysqli_query(connection,query,resultmode);

Umzekelo

Lo mzekelo ulandelayo ubonisa ukusetyenziswa komsebenzi we-PHP mysqli_query ukucima isiseko sedatha:

<?
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);
?>

Emva kokuphunyezwa ngempumelelo, isiphumo senani sithi:

unxibelelwano luphumelele

Isiseko sedatha sicinywe ngempumelelo

Qaphela: Xa ucima i-database usebenzisa iskripthi se-PHP, umyalezo wokuqinisekisa awuyi kuvela, kwaye i-database echaziweyo iya kususwa ngokuthe ngqo, ngoko kufuneka uqaphele kakhulu xa ucima i-database.