mysql快速学习创建/删除数据表篇（六）

1

2

3

4

5

6

7

tutorials_tbl(

tutorial_id INT NOT NULL AUTO_INCREMENT,

tutorial_title VARCHAR(100) NOT NULL,

tutorial_author VARCHAR(40) NOT NULL,

submission_date DATE,

PRIMARY KEY ( w3cschool_id )

);

1

2

3

4

5

6

7

mysql> CREATE TABLE w3cschool_tbl(

-> w3cschool_id INT NOTNULL AUTO_INCREMENT,

-> w3cschool_titleVARCHAR(100) NOT NULL,

-> w3cschool_authorVARCHAR(40) NOT NULL,

-> submission_date DATE,

-> PRIMARY KEY (w3cschool_id )

-> );

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

$sql = "CREATE TABLEtutorials_tbl( "创建

"tutorial_id INT NOTNULL   AUTO_INCREMENT, ".

"tutorial_titleVARCHAR(100) NOT   NULL, ".

"tutorial_authorVARCHAR(40) NOT   NULL, ".

"submission_dateDATE, ".

"PRIMARY KEY (tutorial_id ));   "

;

$sql = "DROP TABLEw3cschool_tbl";删除

mysql_select_db( 'TUTORIALS' );

$retval = mysql_query( $sql, $conn); //判断是否成功而设置的参数；

if(! $retval )

{

die('数据表创建失败: ' . mysql_error());

}

echo "数据表创建成功\n";

mysql_close($conn);