MySQL inogadzira sei dhatabhesi?Gadzira MySQL database command/statement/syntax

MySQLNzira yekugadzira database?gadziraMySQL databaseCommand/Statement/Syntax

MySQL kugadzira database

Gadzira dhatabhesi uchishandisa mysqladmin

Nemushandisi akajairwa, ungangoda rombo rakanaka kugadzira kana kudzima MySQL dhatabhesi.

Saka isu tinoshandisa mudzi wemushandisi kupinda pano.Mudzi wemudzi ane chiremera chepamusoro uye anogona kushandisa mysql mysqladmin command kugadzira dhatabhesi.

muenzaniso

Murairo unotevera unongoratidza maitiro ekugadzira dhatabhesi inonzi chenweiliang:

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

Mushure mekunge murairo uri pamusoro waitwa zvinobudirira, iyo MySQL database chenweiliang ichagadzirwa.

Gadzira dhatabhesi uchishandisa PHP script

PHP inoshandisa mysqli_query basa kugadzira kana kudzima MySQL dhatabhesi.

Basa racho rine maparamendi maviri uye rinodzorera TRUE kana kuurayiwa kwabudirira, zvikasadaro inodzorera FALSE.

girama

mysqli_query(connection,query,resultmode);

muenzaniso

Muenzaniso unotevera unoratidza kushandiswa kwePP kugadzira dhatabhesi:

<?
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 = 'CREATE DATABASE chenweiliang';
$retval = mysqli_query($conn,$sql );
if(! $retval )
{
 die('创建数据库失败: ' . mysqli_error($conn));
}
echo "数据库 chenweiliang 创建成功\n";
mysqli_close($conn);
?>

Mushure mekuita zvinobudirira, zvinotevera zvinodzoserwa:

kubatana kwabudirira

Iyo database chenweiliang yakagadzirwa zvinobudirira