SETNAMES UTF8;SET foreign_key_checks =0;-- ------------------------------Table structure for ' yunzhi_teacher '-- ----------------------------DROPTABLEIFEXISTS' Yunzhi_teacher ';CREATETABLE' Yunzhi_teacher ' (' ID 'int11)UnsignedNotNULL Auto_increment,' Name 'varchar60LDEFAULT‘‘COMMENT' Name ',' Sex ' tinyint (1)UnsignedNotNullDEFAULT' 0 'COMMENT' 0 men, 1 women ',' Username 'varchar16)NotNullCOMMENT' User name ',' Email 'varchar30)DEFAULT‘‘COMMENT' Mailbox ',' Create_time 'int11)UnsignedNotNullDEFAULT' 0 'COMMENT' Create Time ',' Update_time 'int11)UnsignedNotNullDEFAULT' 0 'COMMENT' Update Time ', PRIMARYKEY (' ID '))Engine=myisam auto_increment=3DEFAULTCharset=utf8;-- ------------------------------Records of ' yunzhi_teacher '-- ----------------------------BEGIN;insert into ' Yunzhi_teacher ' Span class= "Hljs-keyword" >values ( ' 1 ', ' Zhang San ', ' 0 ', ' Zhangsan ', ' [email protected] ', ' 123123 ', ' 123213 '), ( ' 2 ', ' John Doe ', ' 0 ', ' Lisi ', [ Email protected] ', ' 123213 ', ' 1232 '); commit; set foreign_key_checks = 1;
MySQL Build Table