Yuav xaiv MySQL database li cas? Xaiv cov lus txib / nqe lus / syntax hauv MySQL

MySQL databaseYuav xaiv li cas?MySQLxaiv database command/statement/syntax

MySQL xaiv database

Tom qab koj txuas mus rau MySQL database, tej zaum yuav muaj ntau lub databases uas tuaj yeem ua haujlwm, yog li koj yuav tsum xaiv cov ntaub ntawv koj xav ua haujlwm.

Xaiv MySQL database los ntawm lub qhov rais hais kom ua

Ib qho database tshwj xeeb tuaj yeem xaiv tau yooj yim hauv mysql> lub qhov rais tam sim.Koj tuaj yeem siv SQL cov lus txib los xaiv cov ntaub ntawv teev tseg.

piv txwv

Cov piv txwv hauv qab no xaiv cov database chenweiliang:

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

Tom qab ua tiav cov lus txib saum toj no, koj tau ua tiav xaiv chenweiliang database, thiab cov haujlwm tom ntej yuav raug tua hauv chenweiliang database.

Daim ntawv ceeb toom:Tag nrho cov npe database, lub npe ntawm lub rooj, thiab lub rooj teb yog qhov tseem ceeb.Yog li koj yuav tsum nkag mus rau lub npe raug thaum siv SQL hais kom ua.

Xaiv MySQL database siv PHP tsab ntawv

PHP muab cov haujlwm mysqli_select_db los xaiv cov ntaub ntawv.Txoj haujlwm rov qab TRUE tom qab ua tiav tiav, txwv tsis pub rov qab FALSE.

qauv sau ntawv

mysqli_select_db(connection,dbname);

piv txwv

Cov piv txwv hauv qab no qhia yuav ua li cas siv mysqli_select_db muaj nuj nqi los xaiv cov ntaub ntawv:

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