PHP Hercules [023 section]create table creating a new table SQL write notes (2015-08-27)

2015-08-27 PHP Force 023. CREATE table creates a new table SQL writing note

Http://www.cnblogs.com/dalitongxue/p/4762182.html

Reference:

Description and comment information for the MySQL field

http://blog.csdn.net/chelen_jak/article/details/45689139

DROP TABLE IF EXISTStest_table; CREATE TABLEtest_table (test_idint  not NULLAuto_incrementPRIMARY KEYCOMMENT'primary KEY (self-growth)', Test_keyvarchar(Ten) not NULLCOMMENT'type', Test_valuevarchar( -) not NULLCOMMENT'value', Test_typeint  not NULLCOMMENT'Internal Type', Test_belongtointCOMMENT'Subordinate Relationship', Test_gradeint DEFAULT 1COMMENT'level', Test_remarkvarchar( -) COMMENT'Notes', Test_visiblebit DEFAULT 1COMMENT'is visible'  )

CREATE Table writes notes, neither

Remark varchar (200)//Notes

It's not

Remark varchar (+) DESC remarks

It's not

Remark varchar (COMMENT) Notes

It's not

Remark varchar (COMMENT ' remarks ')

But
Remark varchar (COMMENT) ' remarks ';

Of course, the last field does not have a comma behind it.

On this matter, also toss half a day. Whining

Used to be, now forget. Ha ha

2015-08-27 PHP Force 023. CREATE table creates a new table SQL writing note

PHP Hercules [023 section]create table creating a new table SQL write notes (2015-08-27)