CREATE DATABASE mywork //数据库名 mywork
CREATE TABLE gitlog(//表明gitlog
_id INT NOT NULL AUTO_INCREMENT,
wtitle VARCHAR(100) NOT NULL ,
wcontent VARCHAR(2000) NOT NULL ,//内容部位空最多2000字符
wstamp TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),//默认给当前时间戳,秒后面精确六位
PRIMARY KEY (_id) //指定主键
) DEFAULT CHARSET=utf8 //指定编码
INSERT INTO gitlog (wtitle,wcontent) VALUE (‘我喔喔’,’爱喔喔学习’)
SELECT * FROM gitlog
DROP TABLE gitlog //删除表