I-MySQL idala kanjani isizindalwazi?Dala i-MySQL database umyalo/isitatimende/i-syntax

MySQLUyenza kanjani i-database?dalaMySQL databaseUmyalo/Isitatimende/Syntax

Yakha i-database ye-MySQL

Dala i-database usebenzisa i-mysqladmin

Ngomsebenzisi ojwayelekile, ungase udinge amalungelo athile ukuze udale noma ususe imininingwane egciniwe ye-MySQL.

Ngakho sisebenzisa impande yomsebenzisi ukungena lapha. Umsebenzisi wempande unegunya eliphakeme kakhulu futhi angasebenzisa umyalo we-mysql mysqladmin ukuze akhe isizindalwazi.

Isibonelo

Umyalo olandelayo umane ukhombisa inqubo yokwakha isizindalwazi esiqanjwe ngokuthi i-chenweiliang:

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

Ngemuva kokuthi umyalo ongenhla ukhishwe ngempumelelo, kuzokwakhiwa i-MySQL database chenweiliang.

Dala i-database usebenzisa iskripthi se-PHP

I-PHP isebenzisa umsebenzi we-mysqli_query ukuze idale noma isuse imininingwane egciniwe ye-MySQL.

Umsebenzi unamapharamitha amabili futhi ubuyisela TRUE uma ukwenza kuphumelele, ngaphandle kwalokho ubuyisela FALSE.

uhlelo lolimi

mysqli_query(connection,query,resultmode);

Isibonelo

Isibonelo esilandelayo sibonisa ukusetshenziswa kwe-PHP ukwakha isizindalwazi:

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

Ngemva kokwenza ngempumelelo, imiphumela elandelayo ibuyiselwa:

uxhumano luphumelele

I-database ye-chenweiliang idalwe ngempumelelo