Yadda za a zabi MySQL database? Zaɓi umarnin bayanai/bayani/syntax a cikin MySQL

MySQL databaseYadda za a zabi?MySQLzaɓi umarnin bayanai/bayani/syntax

MySQL zaži database

Bayan kun haɗa zuwa bayanan MySQL, za a iya samun bayanai da yawa waɗanda za a iya sarrafa su, don haka kuna buƙatar zaɓar bayanan da kuke son aiki.

Zaɓi bayanan MySQL daga taga da sauri

Ana iya zaɓar takamaiman bayanan bayanai cikin sauƙi a cikin mysql> taga mai sauri.Kuna iya amfani da umarnin SQL don zaɓar takamaiman bayanai.

misali

Misali mai zuwa yana zaɓar ma'ajin bayanai:

[root@host]# mysql -u root -p
Enter password:******
mysql> use chenweiliang;
Database changed
mysql>

Bayan aiwatar da wannan umarni na sama, kun sami nasarar zaɓar ma'ajin bayanai na chenweiliang, kuma za a aiwatar da ayyukan da suka biyo baya a cikin ma'ajin bayanai na chenweiliang.

Sanarwa:Duk sunayen bayanai, sunayen tebur, da filayen tebur suna da hankali.Don haka kuna buƙatar shigar da madaidaicin suna lokacin amfani da umarnin SQL.

Zaɓi bayanan MySQL ta amfani da rubutun PHP

PHP yana ba da aikin mysqli_select_db don zaɓar bayanan bayanai.Aikin yana dawowa GASKIYA bayan nasarar aiwatarwa, in ba haka ba ya dawo KARYA.

nahawu

mysqli_select_db(connection,dbname);

misali

Misali mai zuwa yana nuna yadda ake amfani da aikin mysqli_select_db don zaɓar bayanan 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 '连接成功';
mysqli_select_db($conn, 'chenweiliang' );
mysqli_close($conn);
?>