Kodi MySQL imapanga bwanji database?Pangani MySQL database command/statement/syntax

MySQLMomwe mungapangire database?panganiMySQL databaseCommand/Statement/Syntax

MySQL pangani database

Pangani database pogwiritsa ntchito mysqladmin

Ndi wogwiritsa ntchito wamba, mungafunike mwayi wapadera kuti mupange kapena kufufuta nkhokwe za MySQL.

Chifukwa chake timagwiritsa ntchito root user kulowa apa.Wogwiritsa ntchito mizu ali ndi ulamuliro wapamwamba kwambiri ndipo amatha kugwiritsa ntchito mysql mysqladmin command kupanga database.

Chitsanzo

Lamulo lotsatirali limangowonetsa njira yopangira database yotchedwa chenweiliang:

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

Lamulo ili pamwambapa litachitidwa bwino, MySQL database chenweiliang idzapangidwa.

Pangani database pogwiritsa ntchito PHP script

PHP imagwiritsa ntchito mysqli_query ntchito kupanga kapena kufufuta nkhokwe za MySQL.

Ntchitoyi ili ndi magawo awiri ndipo imabweretsanso TRUE ngati ntchitoyo ikuyenda bwino, apo ayi imabwezeretsa FALSE.

galamala

mysqli_query(connection,query,resultmode);

Chitsanzo

Chitsanzo chotsatirachi chikuwonetsa kugwiritsa ntchito PHP kupanga nkhokwe:

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

Pambuyo pochita bwino, zotsatira zotsatirazi zimabwezedwa:

kulumikizana kwatheka

Chenweiliang database idapangidwa bwino