MySQL e hlakola database joang?Hlakola taelo ea database ea MySQL/syntax/statement

MySQLMokhoa oa ho hlakola database?hlakolaMySQL databaseTaelo/Syntax/Polelo

MySQL hlakola database

tlohela database u sebelisa mysqladmin

Kena ho seva sa mysql joalo ka mosebelisi ea tloaelehileng, o kanna oa hloka litokelo tse khethehileng ho theha kapa ho hlakola database tsa MySQL.

Kahoo re sebelisa mosebelisi oa motso ho kena mona.Mosebelisi oa motso o na le matla a phahameng ka ho fetesisa mme a ka sebelisa taelo ea mysql mysqladmin ho theha database.

Tlhokomelo e kholo e tlameha ho nkoa ha u hlakola database, kaha data eohle e tla be e felile ka mor'a hore taelo ea ho hlakola e phethoe.

Mohlala o latelang o hlakola database chenweiliang (database e entsoe khaolong e fetileng):

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

Kamora ho etsa taelo e kaholimo ea ho hlakola database, ho tla hlaha lebokose le potlakileng ho netefatsa hore na database e hlile e hlakotsoe:

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

Hlakola database u sebelisa PHP script

PHP e sebelisa mosebetsi oa mysqli_query ho theha kapa ho hlakola li-database tsa MySQL.

Ts'ebetso e na le liparamente tse peli 'me e khutlisa TRUE haeba ts'ebetso e atlehile, ho seng joalo e khutlisa FALSE.

sebōpeho-puo

mysqli_query(connection,query,resultmode);

Mohlala

Mohlala o latelang o bonts'a ts'ebeliso ea ts'ebetso ea PHP mysqli_query ho hlakola database:

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

Kamora ts'ebetso e atlehileng, sephetho sa nomoro ke:

khokahano e atlehile

Database chenweiliang hlakolwa ka katleho

Tlhokomeliso: Ha o hlakola database o sebelisa sengoloa sa PHP, molaetsa oa netefatso o ke ke oa hlaha, mme database e boletsoeng e tla hlakoloa ka kotloloho, kahoo o lokela ho ba hlokolosi haholo ha o hlakola database.