Tsab ntawv teev npe
Yuav ua li cas los tsim ib lub rooj hauv MySQL database ? MySQL cov lus txib/cov lus hais/syntax rau kev tsim ib lub rooj.
MySQL tsim cov ntaub ntawv
Tsim ib lub rooj MySQL cov ntaub ntawv yuav tsum muaj cov ntaub ntawv hauv qab no:
- Lub npe ntawm lub rooj
- lub npe daim teb
- txhais txhua lub rooj teb
qauv sau ntawv
Cov hauv qab no yog qhov dav dav SQL syntax rau tsim MySQL cov ntaub ntawv rooj:
CREATE TABLE table_name (column_name column_type);
Hauv qhov piv txwv hauv qab no peb yuav tsim cov ntaub ntawv rooj chenweiliang_tbl hauv chenweiliang database:
CREATE TABLE IF NOT EXISTS `chenweiliang_tbl`( `chenweiliang_id` INT UNSIGNED AUTO_INCREMENT, `chenweiliang_title` VARCHAR(100) NOT NULL, `chenweiliang_author` VARCHAR(40) NOT NULL, `submission_date` DATE, PRIMARY KEY ( `chenweiliang_id` ) )ENGINE=InnoDB DEFAULT CHARSET=utf8;
Piv txwv kev tsom xam:
- Yog koj tsis xav kom teb NUJ Cov khoom ntawm cov teb tuaj yeem raug teeb tsa raws li TSIS TXHOB, thaum khiav cov database, yog cov ntaub ntawv nkag rau hauv daim teb noNUJ , qhov yuam kev yuav raug qhia.
- AUTO_INCREMENT txhais tau tias yog tus cwj pwm pib nce ntxiv, feem ntau yog siv rau tus yuam sij tseem ceeb, thiab tus nqi yuav raug nce los ntawm 1.
- PRIMARY KEY lo lus tseem ceeb yog siv los txhais ib kem ua tus yuam sij tseem ceeb.Koj tuaj yeem siv ntau kab los txheeb xyuas tus yuam sij tseem ceeb, sib cais los ntawm commas.
- ENGINE teeb tsa lub cav cia, thiab CHARSET teeb tsa tus lej encoding.
Tsim lub rooj los ntawm kev hais kom ua
Cov lus qhia hauv MySQL siv tau yooj yim los ntawm lub qhov rai hais kom ua mysql>. Koj siv tau cov lus txib SQL CREATE TABLE los tsim cov lus qhia.
piv txwv
Cov hauv qab no yog ib qho piv txwv ntawm kev tsim cov ntaub ntawv rooj chenweiliang_tbl:
root@host# mysql -u root -p Enter password:******* mysql> use chenweiliang; Database changed mysql> CREATE TABLE chenweiliang_tbl( -> chenweiliang_id INT NOT NULL AUTO_INCREMENT, -> chenweiliang_title VARCHAR(100) NOT NULL, -> chenweiliang_author VARCHAR(40) NOT NULL, -> submission_date DATE, -> PRIMARY KEY ( chenweiliang_id ) -> )ENGINE=InnoDB DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.16 sec) mysql>
Lus Cim: Tus MySQL command terminator yog ib lub semicolon (;).
Tsim cov ntaub ntawv siv PHP tsab ntawv
Koj siv tau PHP's mysqli_query() function los tsim ib lub rooj hauv ib lub database uas twb muaj lawm.
Qhov kev ua haujlwm muaj ob qhov tsis muaj thiab rov qab TRUE yog tias kev ua tiav tiav, txwv tsis pub nws rov FALSE.
qauv sau ntawv
mysqli_query(connection,query,resultmode);
| Tsis | 描述 |
|---|---|
| kev twb kev txuas | Yuav tsum tau.Qhia meej txog MySQL kev sib txuas siv. |
| lus nug | Yuav tsum tau, qhia cov kab lus nug. |
| hom kev tshwm sim | xaiv tau.ib qho tsis tu ncua.Yuav yog ib qho ntawm cov txiaj ntsig hauv qab no:
|
piv txwv
Cov piv txwv hauv qab no siv PHP tsab ntawv los tsim ib lub rooj ntaub ntawv:
Tsim cov ntaub ntawv
<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('连接失败: ' . mysqli_error($conn));
}
echo '连接成功<br />';
$sql = "CREATE TABLE chenweiliang_tbl( ".
"chenweiliang_id INT NOT NULL AUTO_INCREMENT, ".
"chenweiliang_title VARCHAR(100) NOT NULL, ".
"chenweiliang_author VARCHAR(40) NOT NULL, ".
"submission_date DATE, ".
"PRIMARY KEY ( chenweiliang_id ))ENGINE=InnoDB DEFAULT CHARSET=utf8; ";
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
die('数据表创建失败: ' . mysqli_error($conn));
}
echo "数据表创建成功\n";
mysqli_close($conn);
?>Tom qab ua tiav kev ua tiav, koj tuaj yeem saib lub rooj qauv los ntawm kab hais kom ua.
Vam tias, tsab xov xwm "Yuav Ua Li Cas Tsim Ib Lub Rooj Ntaub Ntawv hauv MySQL Database? Cov Lus Qhia/Cov Lus Qhia/Syntax rau Kev Tsim Ib Lub Rooj Ntaub Ntawv hauv MySQL" uas tau muab qhia rau ntawm Chen Weiliang lub blog ( https://www.chenweiliang.com/ ) yuav pab tau koj.
Xav qhia qhov txuas ntawm tsab xov xwm no: https://www.chenweiliang.com/cwl-457.html
