把没有成绩的学生添加到T2中成绩为0我做的非常复杂了,高手能不能简化一下啊,
insert into t2 (id) select id from (select t1.id ,t1.name,t2.成绩 from t1 left join t2 on t1.id=t2.id) as t where t.成绩 is null
update t2 set t2.成绩='0' where t2.成绩 is null分2句写的
insert into t2 (id) select id from (select t1.id ,t1.name,t2.成绩 from t1 left join t2 on t1.id=t2.id) as t where t.成绩 is null
update t2 set t2.成绩='0' where t2.成绩 is null分2句写的
解决方案 »
- mysql 正则 如何表示非空白字符?
- 关于MYSQL的数据类型转换机制。。
- 急啊~300分问这个问题了postgressql的
- 急!我的MYSQL打不开了,怎么回事呀?
- 刚要学MySQL,问一个比较弱智的问题
- mysql中没有mssqlserver中rule的概念吗
- 为什么我的 mysql总是提示Can't connect to local MySQLserver through socket' /tmp/mysql.sock'
- 在MySql中定义一对一关系
- mysql有关分页问题
- mysql 汉字字节
- 有关mysql中文大数据模糊搜索
- row 1 doesn't contain data for all columns
UPDATE t2 SET t2.score='0' WHERE t2.score IS NULL
select a.id,0 from t1 a left join t2 b on a.id=b.id where isnull(b.id)
insert into t2(id,成绩) select id,0 from t1
where id not in (select id from t2);