I-MySQL iyisusa kanjani isizindalwazi?Susa umyalo wesizindalwazi/i-syntax/isitatimende se-MySQL

MySQLIndlela ukususa database?susaMySQL databaseUmyalo/Syntax/Isitatimende

MySQL susa database

yehlisa i-database usebenzisa i-mysqladmin

Ngena ngemvume kuseva ye-mysql njengomsebenzisi ojwayelekile, ungase udinge amalungelo athile ukuze udale noma ususe imininingwane egciniwe ye-MySQL.

Ngakho sisebenzisa impande yomsebenzisi ukungena lapha. Umsebenzisi wempande unegunya eliphakeme kakhulu futhi angasebenzisa umyalo we-mysql mysqladmin ukuze akhe isizindalwazi.

Qaphela kakhulu lapho ususa isizindalwazi, njengoba yonke idatha izobe ingasekho ngemva kokukhishwa komyalo wokususa.

Isibonelo esilandelayo sisusa i-database chenweiliang (isizindalwazi sakhiwe esahlukweni esandulele):

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

Ngemva kokwenza umyalo ongenhla wokususa idatha egciniwe, ibhokisi elisheshayo lizovela ukuze liqinisekise ukuthi isizindalwazi sisusiwe ngempela yini:

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

Susa isizindalwazi usebenzisa iskripthi se-PHP

I-PHP isebenzisa umsebenzi we-mysqli_query ukuze idale noma isuse imininingwane egciniwe ye-MySQL.

Umsebenzi unamapharamitha amabili futhi ubuyisela TRUE uma ukwenza kuphumelele, ngaphandle kwalokho ubuyisela FALSE.

uhlelo lolimi

mysqli_query(connection,query,resultmode);

Isibonelo

Isibonelo esilandelayo sibonisa ukusetshenziswa komsebenzi we-PHP mysqli_query ukususa isizindalwazi:

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

Ngemuva kokwenza ngempumelelo, umphumela wenombolo uthi:

uxhumano luphumelele

Isizindalwazi se-chenweiliang sisuswe ngempumelelo

Qaphela: Lapho ususa i-database usebenzisa iskripthi se-PHP, umlayezo wokuqinisekisa ngeke uvele, futhi i-database ecacisiwe izosuswa ngokuqondile, ngakho kufanele uqaphele kakhulu lapho ususa imininingwane.