Kodi MySQL imachotsa bwanji database?Chotsani MySQL database command/syntax/statement

MySQLMomwe mungachotsere database?kufufutaMySQL databaseCommand/Syntax/Statement

MySQL chotsani database

tsitsani database pogwiritsa ntchito mysqladmin

Lowani ku seva ya mysql ngati wogwiritsa ntchito wamba, mungafunike mwayi wapadera kuti mupange kapena kufufuta ma database a MySQL.

Chifukwa chake timagwiritsa ntchito root user kulowa apa.Wogwiritsa ntchito mizu ali ndi ulamuliro wapamwamba kwambiri ndipo amatha kugwiritsa ntchito mysql mysqladmin command kupanga database.

Samalani kwambiri mukachotsa nkhokwe, chifukwa deta yonse idzachoka pambuyo poti lamulo lochotsa liperekedwa.

Chitsanzo chotsatirachi chimachotsa nkhokwe ya chenweiliang (database idapangidwa m'mutu wapitawo):

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

Pambuyo pochita lamulo lochotsa pamwambapa, bokosi lofulumira lidzawoneka kuti litsimikizire ngati deta yachotsedwadi:

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

Chotsani database pogwiritsa ntchito PHP script

PHP imagwiritsa ntchito mysqli_query ntchito kupanga kapena kufufuta nkhokwe za MySQL.

Ntchitoyi ili ndi magawo awiri ndipo imabweretsanso TRUE ngati ntchitoyo ikuyenda bwino, apo ayi imabwezeretsa FALSE.

galamala

mysqli_query(connection,query,resultmode);

Chitsanzo

Chitsanzo chotsatirachi chikuwonetsa kugwiritsa ntchito PHP mysqli_query ntchito kuchotsa deta:

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

Pambuyo pochita bwino, zotsatira za nambala ndi:

kulumikizana kwatheka

Database chenweiliang yafufutidwa bwino

Chidziwitso: Mukachotsa nkhokwe pogwiritsa ntchito PHP script, uthenga wotsimikizira sudzawonekera, ndipo deta yotchulidwa idzachotsedwa mwachindunji, kotero muyenera kusamala kwambiri pochotsa deta.