創(chuàng)建user表代碼
CREATE TABLE `user`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(128) NOT NULL DEFAULT '',
`gender` TINYINT(4) NOT NULL DEFAULT '0',
`age` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY(`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
PHP轉(zhuǎn)Go語(yǔ)言碼農(nóng)，一起進(jìn)步:企鵝:3401889728
2018-11-15
bee generate scaffold user -fields="id:int64,name:string,gender:int,age:int" -driver=mysql -conn="root:123@tcp(127.0.0.1:3306)/imooc"
其中:
user 是指數(shù)據(jù)表名
-fields=后面的id:int64,name:string,gender:int,age:int根據(jù)自己創(chuàng)建的user表字段來(lái)
-driver=數(shù)據(jù)庫(kù)類(lèi)型 選項(xiàng)有 mysql /oracle/sql 等
conn="root:123@tcp(127.0.0.1:3306)/imooc"
conn="數(shù)據(jù)庫(kù)用戶(hù)名:密碼@tcp(數(shù)據(jù)庫(kù)IP:端口號(hào))/當(dāng)前項(xiàng)目數(shù)據(jù)庫(kù)名字"
此時(shí)我的1.數(shù)據(jù)庫(kù)用戶(hù)名是root，2.密碼123，3.數(shù)據(jù)庫(kù)IP:127.0.0.1，4.端口號(hào)3306， 5.當(dāng)前項(xiàng)目數(shù)據(jù)庫(kù)名字imooc
2018-11-15
INSERT INTO user (name,gender,age) VALUES('zhangsan',1,21);
INSERT INTO user (name,gender,age) VALUES('lisi',0,22);
INSERT INTO user (name,gender,age) VALUES('wangwu',1,20);