SQL学习记录
Python让我秃头
旅游管理小硕一枚,头秃学习python中~
展开
-
【SQLZOO】sum and count练习题记录
需要注意:where先筛选再聚合,having先聚合再筛选。having 用聚合函数,where不能用聚合函数1.Show the total population of the world.SELECT SUM(population)FROM world2.List all the continents - just once each.select distinct continent from world 3.Give the total GDP of Africa.select.原创 2020-11-12 12:03:11 · 107 阅读 · 1 评论 -
MySQL 1064报错处理
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into student(学号,姓名,出生日期,性别) values ('0002','çŒ' at line 4原创 2020-10-28 20:00:02 · 320 阅读 · 0 评论