Me pehea te hanga a MySQL i te papanga raraunga?Waihangahia te whakahau / tauākī / syntax MySQL pātengi raraunga

Me pēhea te waihanga i tētahi pātengi raraunga i roto i te MySQL ? Ngā whakahau/ngā tauākī/ngā tikanga whakamahi mō te waihanga i tētahi pātengi raraunga MySQL.

MySQL hanga pātengi raraunga

Waihangahia he pātengi raraunga mā te whakamahi mysqladmin

Ma te kaiwhakamahi noa, ka hiahia pea koe ki nga mana motuhake ki te hanga, ki te whakakore ranei i nga papaa raraunga MySQL.

Na ka whakamahi matou i te kaiwhakamahi pakiaka ki te takiuru ki konei Ko te kaiwhakamahi pakiaka te mana teitei ka taea te whakamahi i te tono mysql mysqladmin ki te hanga i tetahi papaa raraunga.

Akoranga

Ko te whakahau e whai ake nei e whakaatu ana i te tukanga o te hanga i tetahi papaa raraunga ko chenweiliang:

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

I muri i te whakahaerenga angitu o te whakahau i runga ake nei, ka hangaia te chenweiliang pātengi raraunga MySQL.

Waihangahia te papaunga raraunga ma te whakamahi i te tuhinga PHP

Ka whakamahi a PHP i te mahi mysqli_query ki te hanga, ki te muku ranei i nga papaunga raraunga MySQL.

E rua nga tawhā o te mahi ka whakahoki i te TRUE mena ka angitu te mahi, ki te kore ka hoki mai te HERE.

wetereo

mysqli_query(connection,query,resultmode);

Akoranga

Ko te tauira e whai ake nei e whakaatu ana i te whakamahinga o te PHP ki te hanga i tetahi papaunga raraunga:

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

Whai muri i te mahi angitu, ka whakahokia nga hua e whai ake nei:

i angitu te hononga

I pai te hanga o te chenweiliang pātengi raraunga