Yadda ake ƙirƙirar tebur bayanai a cikin MySQL database? Ƙirƙiri umarnin tebur na bayanai/bayani/ syntax a cikin MySQL

MySQL databaseYadda ake ƙirƙirar tebur bayanai?MySQLƘirƙiri umarnin tebur na bayanai/bayani/syntax a ciki

MySQL ƙirƙirar tebur bayanai

Ƙirƙirar teburin bayanai na MySQL yana buƙatar bayanai masu zuwa:

• Sunan tebur
• sunan filin tebur
• ayyana kowane filin tebur

nahawu

Mai zuwa shine babban haɗin SQL don ƙirƙirar tebur bayanan MySQL:

CREATE TABLE table_name (column_name column_type);

A cikin misali mai zuwa za mu ƙirƙiri teburin bayanai chenweiliang_tbl a cikin ma'ajin bayanai na 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;

Misali bincike:

• Idan ba ku son filin ya kasance null Ana iya saita kaddarorin filayen azaman BA NULL ba, lokacin aiki da ma'ajin bayanai, idan bayanan da aka shigar a cikin wannan filin nenull , za a ba da rahoton kuskure.
• An bayyana AUTO_INCREMENT azaman sifa mai haɓakawa ta atomatik, gabaɗaya ana amfani da ita don maɓalli na farko, kuma ƙimar za a ƙara ta ta atomatik ta 1.
• Ana amfani da kalmar PRIMARY keyword don ayyana shafi azaman maɓalli na farko.Kuna iya amfani da ginshiƙai da yawa don ayyana maɓalli na farko, waɗanda waƙafi suka rabu.
• ENGINE yana saita injin ajiya, kuma CHARSET yana saita rufaffiyar.

Ƙirƙiri tebur daga saurin umarni

Za a iya ƙirƙirar tebur na MySQL cikin sauƙi ta taga mysql> umarni.Kuna iya amfani da bayanin SQL KIRKIRA BAYA don ƙirƙirar teburin bayanai.

misali

Mai zuwa shine misali na ƙirƙirar tebur data 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>

Lura:Ƙarshen umarni na MySQL wani yanki ne (;).

Ƙirƙiri teburin bayanai ta amfani da rubutun PHP

Kuna iya amfani da PHP's mysqli_query() aiki don ƙirƙirar tebur na bayanai daga bayanan da ke akwai.

Aikin yana da sigogi biyu kuma yana dawo da GASKIYA idan aiwatarwar ya yi nasara, in ba haka ba ya dawo KARYA.

nahawu

mysqli_query(connection,query,resultmode);

misali

Misali mai zuwa yana amfani da rubutun PHP don ƙirƙirar teburin bayanai:

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