Bawo ni MySQL ṣe paarẹ data data kan?Pa MySQL database aṣẹ/syntax/gbólóhùn

MySQLBii o ṣe le pa ibi ipamọ data rẹ kuro?parẹMySQL databaseÒfin / Sintasi / Gbólóhùn

MySQL pa database

silẹ database lilo mysqladmin

Wọle si olupin mysql gẹgẹbi olumulo deede, o le nilo awọn anfani kan pato lati ṣẹda tabi pa awọn data data MySQL rẹ.

Nitorina a lo olumulo root lati wọle si ibi. Olumulo root ni aṣẹ ti o ga julọ ati pe o le lo aṣẹ mysql mysqladmin lati ṣẹda aaye data kan.

Itọju nla ni a gbọdọ ṣe nigba piparẹ data data kan, nitori gbogbo data yoo lọ lẹhin pipaṣẹ piparẹ naa.

Apẹẹrẹ atẹle npa aaye data rẹ chenweiliang (a ti ṣẹda data data ni ori iṣaaju):

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

Lẹhin ṣiṣe pipaṣẹ aṣẹ data data ti o wa loke, apoti ti o tọ yoo han lati jẹrisi boya data data ti paarẹ gaan:

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

Pa database rẹ nipa lilo PHP akosile

PHP nlo iṣẹ mysqli_query lati ṣẹda tabi pa awọn apoti isura infomesonu MySQL rẹ.

Iṣẹ naa ni awọn paramita meji ati pada TÒÓTỌ ti ipaniyan ba ṣaṣeyọri, bibẹẹkọ o pada FALSE.

girama

mysqli_query(connection,query,resultmode);

Apeere

Apẹẹrẹ atẹle n ṣe afihan lilo iṣẹ PHP mysqli_query lati pa data data rẹ rẹ:

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

Lẹhin ipaniyan aṣeyọri, abajade nọmba jẹ:

asopọ ti ṣaṣeyọri

Aaye data chenweiliang ti paarẹ ni aṣeyọri

Akiyesi: Nigbati o ba npaarẹ data data nipa lilo iwe afọwọkọ PHP kan, ifiranṣẹ ijẹrisi naa kii yoo han, ati pe ibi ipamọ data pato yoo paarẹ taara, nitorinaa o yẹ ki o ṣọra pupọ nigbati o ba npaarẹ data naa.