Isalathiso senqaku
MySQLUyenza njani idatabase?dalaMySQL databaseUmyalelo/Ingxelo/Isintaksi
I-MySQL yenza isiseko sedatha
Yenza isiseko sedatha usebenzisa i-mysqladmin
Ngomsebenzisi oqhelekileyo, unokufuna amalungelo athile okudala okanye ukucima i-MySQL yolwazi.
Ke sisebenzisa ingcambu yomsebenzisi ukungena apha Umsebenzisi wengcambu unegunya eliphezulu kwaye unokusebenzisa umyalelo we-mysql mysqladmin ukwenza idatabase.
Umzekelo
Lo myalelo ulandelayo ubonisa ngokulula inkqubo yokwenza idatabase enegama elithi chenweiliang:
[root@host]# mysqladmin -u root -p create chenweiliang Enter password:******
Emva kokuba lo myalelo ungentla uphunyezwe ngempumelelo, i-MySQL database chenweiliang iyakwenziwa.
Yenza isiseko sedatha usebenzisa iscript sePHP
I-PHP isebenzisa umsebenzi we-mysqli_query ukwenza okanye ukucima i-MySQL yogcino-lwazi.
Umsebenzi uneparameters ezimbini kwaye ubuyisela TRUE ukuba uphumezo luphumelele, kungenjalo ibuyisela FALSE.
Igrama
mysqli_query(connection,query,resultmode);
IParamu | inkcazo |
---|---|
uqhagamshelwano | Kufuneka.Ixela uqhagamshelwano lweMySQL oluza kusetyenziswa. |
umbuzo | Okufunekayo, ikhankanya umtya wombuzo. |
imowudi yeziphumo | Ukhetho.a rhoqo.Inokuba nawaphi na amaxabiso alandelayo:
|
Umzekelo
Lo mzekelo ulandelayo ubonisa ukusetyenziswa kwe-PHP ukwenza isiseko sedatha:
yenza idatabase
<?
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);
?>
Emva kokuphunyezwa ngempumelelo, ezi ziphumo zilandelayo ziyabuyiswa:
unxibelelwano luphumelele
I-database chenweiliang yenziwe ngempumelelo
Ndiyathemba Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kwabelwana "Iyenza njani i-MySQL idatabase?Yenza iMySQL Database Commands/Statements/Syntax" ukukunceda.
Wamkelekile ukwabelana ngekhonkco leli nqaku:https://www.chenweiliang.com/cwl-459.html
Wamkelekile kwisitishi seTelegram sebhlog kaChen Weiliang ukufumana uhlaziyo lwamva nje!
📚 Esi sikhokelo sinexabiso elikhulu, 🌟Eli lithuba elinqabileyo, ungaliphoswa! ⏰⌛💨
Yabelana kwaye uthanda ukuba uyathanda!
Ukwabelana kwakho kunye nezinto ozithandayo ziyinkuthazo yethu eqhubekayo!