Yuav ua li cas los tsim cov ntaub ntawv hauv MySQL database? Tsim cov ntaub ntawv cov lus hais kom ua / nqe lus / syntax hauv MySQL

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 txuasYuav tsum tau.Qhia meej txog MySQL kev sib txuas siv.
lus nugYuav 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:

  • MYSQLI_USE_RESULT (siv qhov no yog tias koj xav tau khaws cov ntaub ntawv ntau)
  • MYSQLI_STORE_RESULT (default)

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.

评论 评论

您的邮箱地址不会被公开。必填项已用*标注

Scroll rau saum