E faʻafefea ona fatuina le laulau faʻamaumauga i MySQL database? Fausia faʻatonuga laulau faʻamatalaga / faʻamatalaga / syntax i MySQL

MySQL databaseE fa'afefea ona fai se laulau fa'amatalaga?MySQLFausia faʻatonuga laulau faʻamatalaga / faʻamatalaga / syntax i totonu

MySQL fatuina laulau faʻamaumauga

O le fatuina o se laulau faʻamatalaga MySQL e manaʻomia ai faʻamatalaga nei:

• 表名
• igoa fanua laulau
• fa'amatala fanua laulau ta'itasi

kalama

O loʻo taua i lalo le faʻasologa lautele SQL mo le fatuina o laulau faʻamaumauga MySQL:

CREATE TABLE table_name (column_name column_type);

I le faʻataʻitaʻiga o loʻo mulimuli mai o le a matou fatuina le laulau faʻamaumauga chenweiliang_tbl i le database chenweiliang:

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;

Fa'ata'ita'iga su'esu'ega:

• Afai e te le mana'o ia i ai le fanua soloia O meatotino o fanua e mafai ona seti e pei LE FAʻAALIGA, pe a faʻaogaina le faʻamaumauga, pe a fai o faʻamaumauga na tuʻuina i totonu o lenei fanua osoloia , o le a lipotia se mea sese.
• AUTO_INCREMENT ua faauigaina o se uiga fa'aopoopo fa'a-autometi, e masani ona fa'aoga mo ki autu, ma o le tau o le a otometi lava ona fa'aopoopo i le 1.
• O le PRIMARY KEY keyword e faʻaaogaina e faʻamatala ai se koluma o le ki autu.E mafai ona e fa'aogaina le tele o koluma e fa'amatala ai le ki autu, fa'amavae i koma.
• ENGINE e setiina le afi e teu ai, ma le CHARSET e setiina le encoding.

Fausia le laulau mai le command prompt

MySQL laulau e mafai ona faigofie ona faia e ala i le mysql> faʻamalama faʻatonu.E mafai ona e faʻaogaina le faʻamatalaga SQL FAIA FUAFUAGA e fai le laulau fa'amaumauga.

Fa'ata'ita'iga

Ole fa'ata'ita'iga lea ole faia ole laulau fa'amaumauga 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>

Manatua:O le MySQL command terminator o se semicolon (;).

Fausia le laulau faʻamatalaga e faʻaaoga ai le PHP script

E mafai ona e faʻaogaina PHP mysqli_query() galuega e fai ai se laulau o fa'amaumauga mai se fa'amaumauga o iai.

O le galuega e lua taʻiala ma toe faʻafoʻi le TRUE pe a manuia le faʻatinoga, a leai e toe foʻi mai le FALSE.

kalama

mysqli_query(connection,query,resultmode);

Fa'ata'ita'iga

O le faʻataʻitaʻiga o loʻo i lalo e faʻaaoga ai le PHP script e fai ai se laulau faʻamaumauga:

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