Kedu ka MySQL si ehichapụ nchekwa data?Hichapụ MySQL nchekwa data iwu/ syntax/ nkwupụta

MySQLOtu esi ehichapụ nchekwa data?hichapụMySQL nchekwa dataIwu/Syntax/Nkwupụta

MySQL hichapụ nchekwa data

dobe nchekwa data site na iji mysqladmin

Banye na ihe nkesa mysql dị ka onye ọrụ nkịtị, ị nwere ike ịchọ ohere dị iche iche iji mepụta ma ọ bụ hichapụ ọdụ data MySQL.

Ya mere, anyị na-eji onye ọrụ mgbọrọgwụ banye ebe a, onye ọrụ mgbọrọgwụ nwere ikike kachasị elu ma nwee ike iji mysql mysqladmin iwu ịmepụta nchekwa data.

A ghaghị ịkpachara anya mgbe ị na-ehichapụ nchekwa data, n'ihi na data niile ga-apụ mgbe emechara iwu ihichapụ.

Ọmụmaatụ na-esonụ na-ehichapụ ọdụ data chenweiliang (e kere nchekwa data na isiakwụkwọ gara aga):

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

Mgbe emechara iwu dị n'elu ka ihichapụ nchekwa data ahụ, igbe ozugbo ga-apụta iji gosi ma ehichapụrụ nchekwa data n'ezie:

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

Hichapụ nchekwa data site na iji script PHP

PHP na-eji ọrụ mysqli_query mepụta ma ọ bụ hichapụ ọdụ data MySQL.

Ọrụ ahụ nwere parampat abụọ wee weghachi TRUE ma ọ bụrụ na ogbugbu ahụ gara nke ọma, ma ọ bụghị ya, ọ ga-alaghachi FALSE.

ụtọ asụsụ

mysqli_query(connection,query,resultmode);

ihe atụ

Ihe atụ na-esonụ na-egosi iji PHP mysqli_query ọrụ ihichapụ nchekwa data:

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

Mgbe emechara nke ọma, nsonaazụ ọnụọgụ bụ:

njikọ gara nke ọma

Chenweiliang database ehichapụrụ nke ọma

Mara: Mgbe ị na-ehichapụ data site na iji script PHP, ozi nkwenye agaghị apụta, na nchekwa data akọwapụtara kpọmkwem ga-ehichapụ ozugbo, yabụ ị kwesịrị ịkpachara anya mgbe ị na-ehichapụ nchekwa data.