摘要: import pymysql user = input('username: ') pwd = input('password: ') conn = pymysql.connect(host='127.0.0.1',user='root',password='123',database='db666') cursor = conn.cursor() sql = "select * from us... 阅读全文
posted @ 2019-03-02 23:02 Tim-code 阅读(217) 评论(0) 推荐(0) 编辑
摘要: 表结构 -- 成绩大于60分-- select * from score where num >60-- 课程表中老师任课的个数是多少?-- SELECT * FROM course;-- SELECT teacher_id,count(cname)FROM course GROUP BY teac 阅读全文
posted @ 2019-03-02 07:30 Tim-code 阅读(152) 评论(0) 推荐(0) 编辑