Momwe mungasankhire database ya MySQL? Sankhani lamulo la database/statement/syntax mu MySQL

MySQL databaseKodi kusankha?MySQLsankhani lamulo la database/statement/syntax

MySQL sankhani database

Mukalumikiza ku database ya MySQL, pakhoza kukhala ma database angapo omwe mungagwiritse ntchito, ndiye muyenera kusankha nkhokwe yomwe mukufuna kugwiritsa ntchito.

Sankhani database ya MySQL kuchokera pawindo lolamula

Dongosolo linalake likhoza kusankhidwa mosavuta pawindo la mysql> mwamsanga.Mutha kugwiritsa ntchito malamulo a SQL kuti musankhe database yomwe mwasankha.

Chitsanzo

Chitsanzo chotsatirachi chimasankha nkhokwe ya chenweiliang:

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

Pambuyo pochita lamulo ili pamwambapa, mwasankha bwino nkhokwe ya chenweiliang, ndipo ntchito zotsatila zidzachitidwa mu database ya chenweiliang.

Zindikirani:Mayina onse ankhokwe, mayina atebulo, ndi magawo atebulo ndizovuta kwambiri.Chifukwa chake muyenera kuyika dzina lolondola mukamagwiritsa ntchito lamulo la SQL.

Sankhani database ya MySQL pogwiritsa ntchito PHP script

PHP imapereka ntchito mysqli_select_db kusankha database.Ntchitoyi imabweza TRUE ikatha kuchita bwino, apo ayi imabwezera FALSE.

galamala

mysqli_select_db(connection,dbname);

Chitsanzo

Chitsanzo chotsatirachi chikuwonetsa momwe mungagwiritsire ntchito mysqli_select_db ntchito kusankha nkhokwe:

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