Olee otú ịhọrọ MySQL nchekwa data? Họrọ iwu nchekwa data/okwu/ syntax na MySQL

Kedu otu esi ahọrọ nchekwa data MySQL ? Iwu/nkwupụta/nhazi nchekwa data MySQL .

MySQL họrọ nchekwa data

Mgbe ị jikọọ na nchekwa data MySQL, enwere ike ịnwe ọtụtụ ọdụ data enwere ike ịrụ ọrụ, yabụ ịkwesịrị ịhọrọ nchekwa data ịchọrọ ịrụ ọrụ.

Họrọ MySQL nchekwa data site na iwu ozugbo window

Enwere ike ịhọrọ otu nchekwa data ngwa ngwa na mysql> windo ozugbo.Ị nwere ike iji iwu SQL ịhọrọ nchekwa data akọwapụtara.

ihe atụ

Ọmụmaatụ na-esonụ na-ahọrọ ebe nchekwa data:

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

Mgbe ịmechara iwu a dị n'elu, ị họrọla nchekwa data chenweiliang nke ọma, a ga-arụkwa ọrụ ndị ọzọ na nchekwa data chenweiliang.

Rịba ama: Aha nchekwa data niile, aha tebụl, na ubi tebụl niile nwere mmetụta gbasara mkpụrụedemede. Ya mere, ịkwesịrị itinye aha ziri ezi mgbe ị na-eji iwu SQL.

Họrọ MySQL nchekwa data site na iji script PHP

PHP na-enye ọrụ mysqli_select_db ịhọrọ nchekwa data.Ọrụ a na-alaghachi TRUE ka emechara nke ọma, ma ọ bụghị ya na-alaghachi Ụgha.

ụtọ asụsụ

mysqli_select_db(connection,dbname);

ihe atụ

Ihe atụ na-esonụ na-egosi otu esi eji ọrụ mysqli_select_db iji họrọ nchekwa data:

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