U ka khetha database ea MySQL joang? Khetha taelo ea database / polelo / syntax ho MySQL

Mokhoa oa ho khetha database ea MySQL ? Litaelo/lipolelo/senoto tsa khetho ea database ea MySQL .

MySQL khetha database

Ka mor'a hore u hokahane le database ea MySQL, ho ka 'na ha e-ba le li-database tse ngata tseo u ka sebetsang ho tsona, kahoo u lokela ho khetha database eo u batlang ho sebetsa ho eona.

Khetha database ea MySQL ho tsoa fensetereng ea taelo ea litaelo

Setsi sa database se ikhethileng se ka khethoa habonolo ho mysql> fensetere e potlakileng.U ka sebelisa litaelo tsa SQL ho khetha database e boletsoeng.

Mohlala

Mohlala o latelang o khetha database chenweiliang:

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

Ka mor'a ho phethahatsa taelo e ka holimo, u atlehile ho khetha polokelo ea polokelo ea chenweiliang, 'me mesebetsi e latelang e tla etsoa sebakeng sa polokelo ea chenweiliang.

Ela Hloko: Mabitso ohle a database, mabitso a litafole, le masimo a litafole a na le mongolo o hlakileng. Ka hona, o hloka ho kenya mabitso a nepahetseng ha o sebedisa ditaelo tsa SQL.

Khetha database ea MySQL u sebelisa PHP script

PHP e fana ka mosebetsi mysqli_select_db ho khetha database.Ts'ebetso e khutlisa TRUE kamora ts'ebetso e atlehileng, ho seng joalo e tla khutlisa FALSE.

sebōpeho-puo

mysqli_select_db(connection,dbname);

Mohlala

Mohlala o latelang o bontša mokhoa oa ho sebelisa mosebetsi oa mysqli_select_db ho khetha 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 '连接成功';
mysqli_select_db($conn, 'chenweiliang' );
mysqli_close($conn);
?>