Ta yaya MySQL ke ƙirƙirar bayanai?Ƙirƙirar umarnin MySQL/bayani/syntax

MySQLYadda ake ƙirƙirar rumbun adana bayanai?halittaMySQL databaseUmurni/Sanarwa/Syntax

MySQL ƙirƙirar bayanai

Ƙirƙiri bayanan bayanai ta amfani da mysqladmin

Tare da mai amfani na yau da kullun, kuna iya buƙatar takamaiman gata don ƙirƙira ko share bayanan MySQL.

Don haka muna amfani da root user don shiga nan, tushen mai amfani yana da mafi girman iko kuma yana iya amfani da umarnin mysql mysqladmin don ƙirƙirar bayanai.

misali

Umurni mai zuwa yana nuna tsarin ƙirƙirar bayanai mai suna chenweiliang:

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

Bayan an aiwatar da umarnin da ke sama cikin nasara, za a ƙirƙiri tushen bayanai na MySQL chenweiliang.

Ƙirƙirar bayanai ta amfani da rubutun PHP

PHP yana amfani da aikin mysqli_query don ƙirƙira ko share bayanan MySQL.

Aikin yana da sigogi biyu kuma yana dawo da GASKIYA idan aiwatarwar ya yi nasara, in ba haka ba ya dawo KARYA.

nahawu

mysqli_query(connection,query,resultmode);

misali

Misali mai zuwa yana nuna amfani da PHP don ƙirƙirar bayanai:

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

Bayan nasarar aiwatarwa, ana dawo da sakamako masu zuwa:

连接 成功

An ƙirƙiri bayanan chenweiliang cikin nasara