E faʻafefea e MySQL ona tape se faʻamaumauga?Aveese le MySQL database command/syntax/statement

MySQLE fa'afefea ona tape le fa'amaumauga?tapeinaMySQL databasePoloaiga / Syntax / Faʻamatalaga

MySQL tape fa'amaumauga

tu'u fa'amaumauga e fa'aaoga ai mysqladmin

Ulufale i le mysql server o se tagata masani, atonu e te manaʻomia ni avanoa faʻapitoa e fatuina pe tape ai MySQL databases.

O lea matou te faʻaogaina le root user e saini ai iinei.O le root user e iai le pule sili ona maualuga ma e mafai ona faʻaaoga le mysql mysqladmin command e fatu ai se database.

Faʻaeteete tele pe a tapeina se faʻamaumauga, aua o faʻamatalaga uma o le a alu ese pe a maeʻa le tapeina o le poloaiga.

O le faʻataʻitaʻiga o loʻo i lalo e tapeina le database chenweiliang (o le database na faia i le mataupu muamua):

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

A maeʻa ona faʻatinoina le faʻatonuga o loʻo i luga e tape le faʻamaumauga, o le a faʻaalia se pusa vave e faʻamaonia pe ua tapeina le database:

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

Aveese fa'amaumauga e fa'aaoga ai le PHP script

PHP faʻaaoga le mysqli_query galuega e fatu pe tape MySQL databases.

O le galuega e lua taʻiala ma toe faʻafoʻi le TRUE pe a manuia le faʻatinoga, a leai e toe foʻi mai le FALSE.

kalama

mysqli_query(connection,query,resultmode);

Fa'ata'ita'iga

O le faʻataʻitaʻiga lea e faʻaalia ai le faʻaogaina o le PHP mysqli_query galuega e tape ai se faʻamaumauga:

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

A maeʻa le faʻataunuʻuina manuia, o le numera o le iʻuga o le:

manuia fesootaiga

Ua soloi lelei le chenweiliang database

Manatua: Pe a tapeina se faʻamaumauga e faʻaaoga ai le PHP script, o le a le faʻaalia le faʻamaoniga o le feʻau, ma o le faʻamaumauga faʻamaonia o le a tape saʻo, o lea e tatau ai ona e matua faʻaeteete pe a tape le faʻamaumauga.