编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE student (
	id int AUTO_INCREMENT PRIMARY KEY,
	title varchar(255) NOT NULL,
	time varchar(255) NOT NULL,
	classification varchar(255) NOT NULL
);

INSERT INTO student VALUES (1, '图文故事|环境日,跟随总书记领悟守护绿水青山之道', '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (2, '增绿就是增优势,植树就是植未来',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (3, '千年窑火 生生不息',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (4, '《二十四节气七十二候》系列高清视频:芒种',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (5, '消费制造齐发力 激活经济回升向好新动能',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (6, '世界环境日丨发现“隐藏款”环保新青年!',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (7, '“集装箱指数”透露外贸出口加快趋势',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (8, '黑色矿山逐绿前行',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (9, '政策打好“组合拳” 进一步激发汽车消费市场活力',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (10, '便利消费无障碍 多地出台举措让外卡支付更轻松',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (11, '【45°瞰安徽】走进天柱山',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (12, '文化中国行|传承于田间地头的非遗技艺',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (13, '又到考试季 来看看这份减压攻略 | 高考加油站',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (14, '全国安全生产月公益广告:畅通生命通道',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (15, '贵州扎实推动生态文明建设实现“六个出新绩”',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (16, '美在东方 | 天蓝地绿水清 绘就美丽中国新画卷',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (17, '文化中国行·诗意节令|芒种:风吹麦成浪 静待稻花香',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (18, '人人讲安全、个个会应急',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (19, '划菱桶、玩漂移 看各地龙舟赛出哪些新花样',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (20, '星光不负赶路人 多项暖心细致措施为考生保驾护航',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (21, '扮"靓"生态底色 百姓共享河畅、水清、岸绿、景美',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (22, '国家发展改革委提出5方面措施推动社会信用体系建设',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (23, '【光明时评】夯实人才根基 助力创新发展',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (24, '让我们的文化基因代代相传',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (25, '中国发展新能源产业惠及全球',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (26, '从易处着手与先啃硬骨头',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (27, '加强统筹协调,下好“一盘棋”',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (28, '【中国有约】“成就中国大片,讲好中国故事”',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (29, '捷克驻华使馆副馆长马金用中文演唱《东方红》',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (30, '逐渐“沉没”的连接,温室效应如何影响全球网络',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (31, '通讯|音乐搭台,中巴两国共庆建交50周年',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (32, '中国趋势|美国对华加征301关税有违WTO规则',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (33, '国际观察|议席不及预期 “莫迪3.0”压力不小',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (34, '西藏迎来虫草采挖季',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (35, '组图丨拉萨河绽放生态之美',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (36, '聚金融之力赋能“开放新疆”',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (37, '文化中国行丨G219线(新疆段)玩法上新故事多',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (38, '暖新闻',  '2030-06-06 20:29:57', 'yw_gov');
INSERT INTO student VALUES (39, '“小时候教你走路,现在,妈妈再教一次……”',  '2030-06-06 20:29:57', 'yw_gov');
INSERT INTO student VALUES (40, '拜登称若台海发生军事冲突美军有可能介入 外交部回应',  '2030-06-06 20:29:57', 'yw');
INSERT INTO student VALUES (41, '山西沁县政协主席郭建宇被刺身亡 嫌犯据称系离异独居',  '2030-06-06 20:29:57', 'yw');
SELECT * FROM student;