实验2 SQL数据定义

1.student表

sql1 = "INSERT INTO student VALUES('{}','{}','{}','{}','{}','{}');"
stu_id = 2021001000
stu_name = ['张','刘','王','李','钱','赵']
stu_sex=['男','女']
stu_age=[17,18,19,20,21,22]
stu_dept=['ma','cs','ch','en']
stu_school=['河北师范大学']
for i in range(1000):
    print(sql1.format(stu_id,stu_name[i%6],stu_sex[i%2],stu_age[i%6],stu_dept[i%4],stu_school[i%1]))
    stu_id+=1

（2）结果：

 

2.course表

(1)代码

sql1 = "INSERT INTO course VALUES('{}','{}','{}','{}');"
stu_no = [1,2,3,4,5,6]
stu_name=['语文','数学','英语','物理','生物','地理']
stu_pno=[111,112,113,114,115,116]
stu_credit=[1,1,2,3,4,5]
for i in range(1000):
    print(sql1.format(stu_no[i%6],stu_name[i%6],stu_pno[i%6],stu_credit[i%6]))

（2）结果

3.sc表

（1）代码

sql1 = "INSERT INTO sc VALUES('{}','{}','{}');"
stu_sno = 2021000000
stu_cno = [1,2,3,4,5,6]
stu_grade=[55,58,65,70,80,85,90,95]
for i in range(100000):
    print(sql1.format(stu_sno,stu_cno[i%6],stu_grade[i%8]))
    stu_sno+=1

（2）结果