在运行在线SQL时进行写入查询结果集出现问题

Discuss / SQL / 在运行在线SQL时进行写入查询结果集出现问题

Back

Topic source

#1 Created at ... [Delete] [Delete and Lock User]

使用

INSERT INTO statistics (class_id, average) SELECT class_id, AVG(score) FROM students GROUP BY class_id;

这个语句系统报错了，说是NULL value in NOT NULL COLUMN,

然后在AVG(score)后面加一个average 才运行成功

廖老师，这是为什么呀？

#2 Created at ... [Delete] [Delete and Lock User]

同问

#3 Created at ... [Delete] [Delete and Lock User]

在线sql就是js模拟的数据库，不支持复杂的sql，目的是让你快速跑结果，不需要搭环境

sql编写是否无误一切以mysql运行结果为准