Kedu ka MySQL si emepụta nchekwa data?Mepụta MySQL nchekwa data iwu/nkwupụta/syntax

MySQLKedu ka esi emepụta nchekwa data?mepụtaMySQL nchekwa dataIwu/Nkwupụta/Syntax

MySQL mepụta nchekwa data

Mepụta nchekwa data site na iji mysqladmin

Site na onye ọrụ nkịtị, ị nwere ike ịchọ ohere dị iche iche iji mepụta ma ọ bụ hichapụ ọdụ data MySQL.

Ya mere, anyị na-eji onye ọrụ mgbọrọgwụ banye ebe a, onye ọrụ mgbọrọgwụ nwere ikike kachasị elu ma nwee ike iji mysql mysqladmin iwu ịmepụta nchekwa data.

ihe atụ

Iwu na-esonụ na-egosipụta nnọọ usoro ịmepụta nchekwa data aha chenweiliang:

[root@host]# mysqladmin -u root -p create chenweiliang
Enter password:******

Mgbe emechara iwu a dị n'elu nke ọma, a ga-emepụta nchekwa data MySQL chenweiliang.

Mepụta nchekwa data site na iji script PHP

PHP na-eji ọrụ mysqli_query mepụta ma ọ bụ hichapụ ọdụ data MySQL.

Ọrụ ahụ nwere parampat abụọ wee weghachi TRUE ma ọ bụrụ na ogbugbu ahụ gara nke ọma, ma ọ bụghị ya, ọ ga-alaghachi FALSE.

ụtọ asụsụ

mysqli_query(connection,query,resultmode);

ihe atụ

Ihe atụ na-esonụ na-egosi iji PHP mepụta 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 '连接成功
';
$sql = 'CREATE DATABASE chenweiliang';
$retval = mysqli_query($conn,$sql );
if(! $retval )
{
 die('创建数据库失败: ' . mysqli_error($conn));
}
echo "数据库 chenweiliang 创建成功\n";
mysqli_close($conn);
?>

Mgbe emechara nke ọma, eweghachite nsonaazụ ndị a:

njikọ gara nke ọma

Emepụtara nchekwa data chenweiliang nke ọma