Ingaba iMySQL iyenza njani idatabase?Yenza umyalelo wesiseko se-MySQL / ingxelo/isintaksi

Ungayenza njani i-database kwi-MySQL ? Imiyalelo/iingxelo/isintaksi yokudala i-database ye-MySQL.

I-MySQL yenza isiseko sedatha

Yenza isiseko sedatha usebenzisa i-mysqladmin

Ngomsebenzisi oqhelekileyo, unokufuna amalungelo athile okudala okanye ukucima i-MySQL yolwazi.

Ke sisebenzisa ingcambu yomsebenzisi ukungena apha Umsebenzisi wengcambu unegunya eliphezulu kwaye unokusebenzisa umyalelo we-mysql mysqladmin ukwenza idatabase.

Umzekelo

Lo myalelo ulandelayo ubonisa ngokulula inkqubo yokwenza idatabase enegama elithi chenweiliang:

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

Emva kokuba lo myalelo ungentla uphunyezwe ngempumelelo, i-MySQL database chenweiliang iyakwenziwa.

Yenza isiseko sedatha usebenzisa iscript sePHP

I-PHP isebenzisa umsebenzi we-mysqli_query ukwenza okanye ukucima i-MySQL yogcino-lwazi.

Umsebenzi uneparameters ezimbini kwaye ubuyisela TRUE ukuba uphumezo luphumelele, kungenjalo ibuyisela FALSE.

Igrama

mysqli_query(connection,query,resultmode);

Umzekelo

Lo mzekelo ulandelayo ubonisa ukusetyenziswa kwe-PHP ukwenza isiseko sedatha:

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

Emva kokuphunyezwa ngempumelelo, ezi ziphumo zilandelayo ziyabuyiswa:

unxibelelwano luphumelele

I-database chenweiliang yenziwe ngempumelelo