如何创建一个新表,该表根据名称获取其他表中列的平均值
16lz
2021-01-22
CREATE TABLE Average_Professor
SELECT ie.Instructor
,SUM(ie.instreffective_avg + h.howmuchlearned_avg + ir.instrrespect_avg +
iv.instroverall_avg + av.availability_avg)/5
FROM instreffective_average ie
JOIN howmuchlearned_average h USING (Instructor)
JOIN instrrespect_average ir USING (Instructor)
JOIN instructoroverall_average iv USING (Instructor)
JOIN availability_average av USING (Instructor)
GROUP BY Instructor
It's giving me error code 1166. If I omit "CREATE TABLE Professor_average" then the script runs, yet I don't have the table created.
它给了我错误代码1166.如果我省略“CREATE TABLE Professor_average”然后脚本运行,但我没有创建表。
1 个解决方案
#1
1
Try naming the calculation column:
尝试命名计算列:
CREATE TABLE Average_Professor
SELECT ie.Instructor
,SUM(ie.instreffective_avg + h.howmuchlearned_avg + ir.instrrespect_avg +
iv.instroverall_avg + av.availability_avg)/5 as calculation_value
FROM instreffective_average ie
JOIN howmuchlearned_average h USING (Instructor)
JOIN instrrespect_average ir USING (Instructor)
JOIN instructoroverall_average iv USING (Instructor)
JOIN availability_average av USING (Instructor)
GROUP BY Instructor
更多相关文章
- 通过Bash脚本语言逃避MYSQL命令行。
- 是否可以从另一个sql脚本中的存储过程调用sql脚本?
- 程序猿(媛)Shell脚本必备技能之一: 在Linux下如何自动备份mysql
- mysql主从同步报slave_sql_running:no的解决方案
- shell脚本中mysqldump的基本使用
- win7下Django的MySql安装,问题解决方案
- mysql 事物没提交导致事物一直运行解决方案
- 无法连接远程MySQL数据库的解决方案
- 使用Powershell对MySQL运行SQL脚本