Nzira yekusarudza MySQL database? Sarudza dhatabhesi murairo / chirevo / syntax muMySQL

MySQL databaseNzira yekusarudza?MySQLsarudza database command/statement/syntax

MySQL sarudza database

Mushure mekunge wabatana neDatabase yeMySQL, panogona kunge paine dhatabhesi dzakawanda dzinogona kushandiswa, saka unofanirwa kusarudza dhatabhesi yaunoda kushanda.

Sarudza dhatabhesi reMySQL kubva pahwindo rekuraira

Imwe dhatabhesi inogona kusarudzwa zviri nyore mumysql> yekukurumidza hwindo.Iwe unogona kushandisa SQL mirairo kusarudza iyo yakatarwa database.

muenzaniso

Muenzaniso unotevera unosarudza dhatabhesi chenweiliang:

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

Mushure mekuita murairo uri pamusoro, wakabudirira kusarudza chenweiliang dhatabhesi, uye mashandiro anotevera achaitwa mudura re chenweiliang.

ziviso:Mazita ese epa database, mazita etafura, uye minda yetafura inyaya-sensitive.Saka iwe unofanirwa kuisa zita chairo kana uchishandisa iyo SQL command.

Sarudza MySQL dhatabhesi uchishandisa PHP script

PHP inopa basa mysqli_select_db kusarudza dhatabhesi.Basa racho rinodzosa TRUE mushure mekuita kwakabudirira, zvikasadaro rinodzosera FALSE.

girama

mysqli_select_db(connection,dbname);

muenzaniso

Muenzaniso unotevera unoratidza maitiro ekushandisa mysqli_select_db basa kusarudza dhatabhesi:

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