Ungayikhetha kanjani i-database ye-MySQL? Khetha umyalo wesizindalwazi/isitatimende/i-syntax ku-MySQL

MySQL databaseIndlela yokukhetha?MySQLkhetha umyalo wesizindalwazi/isitatimende/i-syntax

Khetha i-database ye-MySQL

Ngemva kokuxhuma ku-database ye-MySQL, kungase kube nemininingwane eminingi engasetshenziswa, ngakho udinga ukukhetha i-database ofuna ukuyisebenzisa.

Khetha i-database ye-MySQL kuwindi lomyalo womyalo

I-database ethile ingakhethwa kalula ku-mysql> ifasitela elisheshayo.Ungasebenzisa imiyalo ye-SQL ukuze ukhethe isizindalwazi esishiwo.

Isibonelo

Isibonelo esilandelayo sikhetha i-database chenweiliang:

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

Ngemva kokwenza umyalo ongenhla, ukhethe ngempumelelo isizindalwazi se-chenweiliang, futhi imisebenzi elandelayo izokwenziwa kusizindalwazi se-chenweiliang.

Isaziso:Wonke amagama esizindalwazi, amagama ethebula, nezinkambu zethebula zibucayi kakhulu.Ngakho udinga ukufaka igama elilungile uma usebenzisa umyalo we-SQL.

Khetha isizindalwazi se-MySQL usebenzisa iskripthi se-PHP

I-PHP ihlinzeka ngomsebenzi mysqli_select_db ukukhetha isizindalwazi.Umsebenzi ubuyisela TRUE ngemva kokwenza ngempumelelo, ngaphandle kwalokho ubuyisela okuthi FALSE.

uhlelo lolimi

mysqli_select_db(connection,dbname);

Isibonelo

Isibonelo esilandelayo sibonisa indlela yokusebenzisa umsebenzi we-mysqli_select_db ukuze ukhethe 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 '连接成功';
mysqli_select_db($conn, 'chenweiliang' );
mysqli_close($conn);
?>