//Create a tableCreate Table User(tutorial_idINT not NULLauto_increment, Tutorial_titleVARCHAR( -) not NULL, Tutorial_authorVARCHAR( +) not NULL, submission_date date,PRIMARY KEY(tutorial_id)); Query OK,0Rows Affected (0.61sec)
//Create a banner tableCreate TableBanner (IDINT not NULLauto_increment, Img_urlvarchar(255) not NULL, Web_urltext not NULL, Addtimedatetime, PRIMARY KEY(ID));
//CREATE TABLE 3Create Table(' uid 'int( One) COMMENT'User ID', ' subject 'varchar( -)CHARACTER SETUtf8mb4DEFAULT NULLCOMMENT'Room title', ' Praise_num 'int( -)DEFAULT '0'COMMENT'To Click the number of likes', ' Gold_num 'int( -)DEFAULT '0'COMMENT'the number of shells received in this live', ' Watch_num 'int( One)DEFAULT '0'COMMENT'View Count', ' Review_url 'varchar( $) COLLATE Utf8mb4_unicode_ciDEFAULT NULLCOMMENT'Replay Address URL', ' Addtime 'timestamp NULL DEFAULT Current_timestampCOMMENT'creation Time', ' Endtime 'timestamp NULL DEFAULT NULLCOMMENT'End Time', PRIMARY KEY(UID));//Delete a tableDROP TABLE User;
Create, delete tables