E faʻafefea ona filifili MySQL database? Filifili faʻamaumauga faʻamaumauga / faʻamatalaga / syntax i MySQL

MySQL databaseE faapefea ona filifili?MySQLfilifili le faʻatonuga faʻamaumauga / faʻamatalaga / syntax

MySQL filifili faʻamaumauga

A maeʻa ona e faʻafesoʻotaʻi i le MySQL database, atonu e tele faʻamaumauga e mafai ona faʻaogaina, o lea e tatau ai ona e filifilia le database e te manaʻo e faʻaogaina.

Filifili le MySQL database mai le faamalama o le poloaiga

E faigofie ona filifilia se faʻamaumauga faʻapitoa i le mysql> faʻamalama vave.E mafai ona e faʻaogaina tulafono SQL e filifili ai faʻamaumauga faʻamaumauga.

Fa'ata'ita'iga

Ole fa'ata'ita'iga lea e filifilia ai le database chenweiliang:

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

A maeʻa le faʻatinoina o le faʻatonuga o loʻo i luga, ua e filifilia ma le manuia le chenweiliang database, ma o gaioiga mulimuli ane o le a faʻatinoina i le chenweiliang database.

Fa'aaliga:O igoa uma o fa'amaumauga, igoa o laulau, ma fanua o laulau e fa'atatau i mata'itusi.O lea e tatau ona e ulufale i le igoa saʻo pe a faʻaaoga le SQL command.

Filifili MySQL database e faʻaaoga ai le PHP script

PHP e maua ai le galuega mysqli_select_db e filifili ai se faʻamaumauga.O le galuega e toe fo'i mai le TRUE pe a mae'a fa'ataunu'u manuia, a fa'apea e toe fo'i mai le FALSE.

kalama

mysqli_select_db(connection,dbname);

Fa'ata'ita'iga

O le faʻataʻitaʻiga lea e faʻaalia ai le faʻaogaina o le mysqli_select_db galuega e filifili ai se faʻamaumauga:

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