Papa Kuhikuhi ʻatikala
MySQLPehea e hana ai i kahi waihona?hanaMySQL waihonaKauoha/Haʻiʻōlelo/Syntax
Hana ʻo MySQL i ka waihona
E hana i kahi waihona me ka mysqladmin
Me kahi mea hoʻohana maʻamau, pono paha ʻoe i nā pono kikoʻī e hana a holoi paha i nā waihona MySQL.
No laila, hoʻohana mākou i ka mea hoʻohana kumu e komo ai ma ʻaneʻi. ʻO ka mea hoʻohana kumu ka mana kiʻekiʻe loa a hiki ke hoʻohana i ke kauoha mysql mysqladmin e hana i kahi waihona.
laʻana
Hōʻike wale kēia kauoha i ke kaʻina o ka hana ʻana i kahi waihona i kapa ʻia ʻo chenweiliang:
[root@host]# mysqladmin -u root -p create chenweiliang Enter password:******
Ma hope o ka hoʻokō pono ʻia ʻana o ke kauoha i luna, e hana ʻia ka MySQL database chenweiliang.
E hana i ka waihona me ka PHP script
Hoʻohana ʻo PHP i ka hana mysqli_query e hana a holoi paha i nā waihona MySQL.
Loaʻa i ka hana ʻelua mau ʻāpana a hoʻihoʻi i ka TRUE inā kūleʻa ka hoʻokō ʻana, inā ʻaʻole e hoʻi mai FALSE.
ʻōlelo ʻōlelo
mysqli_query(connection,query,resultmode);
hāmeʻa | ho'ākāka |
---|---|
pili ana | Pono.Hōʻike i ka pilina MySQL e hoʻohana. |
nīnau hulina | Pono, kuhikuhi i ke kaula nīnau. |
ʻano hopena | Koho.he mau.Hiki ke loaʻa kekahi o kēia mau waiwai:
|
laʻana
Hōʻike kēia hiʻohiʻona i ka hoʻohana ʻana iā PHP e hana i kahi waihona:
hana waihona
<?
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);
?>
Ma hope o ka hoʻokō pono ʻana, e hoʻihoʻi ʻia nā hopena aʻe:
ua holomua ka pilina
Ua hana maikaʻi ʻia ka waihona chenweiliang
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kaʻana like "Pehea ʻo MySQL e hana ai i kahi waihona?E hana i nā kauoha / ʻōlelo / Syntax MySQL Database e kōkua iā ʻoe.
Welina mai e kaʻana like i ka loulou o kēia ʻatikala:https://www.chenweiliang.com/cwl-459.html
Welina mai i ke kahawai Telegram o ka moʻomanaʻo ʻo Chen Weiliang e kiʻi i nā mea hou loa!
📚 He waiwai nui kēia alakaʻi, 🌟He manawa kakaikahi kēia, mai poina! ⏰⌛💨
Kaʻana like a like inā makemake ʻoe!
ʻO kāu kaʻana like a me kou makemake ʻo kā mākou hoʻoikaika mau!