MySQL e theha database joang?Theha taelo ea database ea MySQL / polelo / syntax

MySQLMokhoa oa ho theha database?bopaMySQL databaseTaelo/Polelo/Statex

MySQL theha database

Theha database u sebelisa mysqladmin

Ka mosebelisi ea tloaelehileng, o ka hloka litokelo tse khethehileng ho theha kapa ho hlakola li-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.

Mohlala

Taelo e latelang e bontša feela mokhoa oa ho theha database e bitsoang chenweiliang:

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

Ka mor'a hore taelo e ka holimo e phethoe ka katleho, database ea MySQL chenweiliang e tla etsoa.

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

Kamora ts'ebetso e atlehileng, liphetho tse latelang li khutlisoa:

khokahano e atlehile

Setsi sa polokelo ea litaba chenweiliang se entsoe ka katleho