Ungayikhetha njani isiseko sedatha yeMySQL? Khetha umyalelo wesiseko sedatha/ingxelo/isintaksi kwi-MySQL

MySQL databaseIndlela yokukhetha?MySQLkhetha umyalelo wesiseko sedata/ingxelo/isintaksi

MySQL khetha isiseko sedatha

Emva kokuba uqhagamshele kwi-database ye-MySQL, kunokubakho iinkcukacha ezininzi ezinokuthi zisebenze, ngoko kufuneka ukhethe i-database ofuna ukuyisebenzisa.

Khetha i-database ye-MySQL kwifestile yomyalelo womyalelo

Isiseko sedatha esithile sinokukhethwa ngokulula kwi-mysql> iwindow ekhawulezayo.Ungasebenzisa imiyalelo yeSQL ukukhetha idatabase ekhankanyiweyo.

Umzekelo

Lo mzekelo ulandelayo ukhetha i-database chenweiliang:

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

Emva kokuphumeza lo myalelo ungentla, ukhethe ngempumelelo isiseko sedata se-chenweiliang, kwaye imisebenzi elandelayo iya kwenziwa kwisiseko sedatha se-chenweiliang.

Phawula:Onke amagama edathabheyibhile, amagama etheyibhile, kunye nemihlaba yetheyibhile inobuzaza.Ngoko kufuneka ufake igama elichanekileyo xa usebenzisa umyalelo weSQL.

Khetha isiseko sedatha seMySQL usebenzisa iscript sePHP

PHP ibonelela ngomsebenzi mysqli_select_db ukukhetha idatabase.Umsebenzi ubuyisela TRUE emva kophumezo oluyimpumelelo, kungenjalo ubuyisela FALSE.

Igrama

mysqli_select_db(connection,dbname);

Umzekelo

Lo mzekelo ulandelayo ubonisa indlela yokusebenzisa mysqli_select_db umsebenzi ukukhetha uvimba weenkcukacha:

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