students_name-productor
批量生成学生信息的SQL语句,主要包括生成随机姓名的功能,如下:
insert into name(name,age,sex,yuwen_score,shuxue_score)values(林洁凡,93,女,71,13)
insert into name(name,age,sex,yuwen_score,shuxue_score)values(范贞晶,83,女,4,37)
insert into name(name,age,sex,yuwen_score,shuxue_score)values(黎丹莉,10,女,96,28)
insert into name(name,age,sex,yuwen_score,shuxue_score)values(康兰蓉,49,女,73,100)
insert into name(name,age,sex,yuwen_score,shuxue_score)values(毕艳艳,62,女,57,42)(Batch SQL statements generated student information, including the name of the function to generate a random, as follows:
insert into name (name, age, sex, yuwen_score, shuxue_score) values (Anna Fan, 93, female, 71,13)
insert into name (name, age, sex, yuwen_score, shuxue_score) values (Fan Zhen Jing, 83, female, 4,37)
insert into name (name, age, sex, yuwen_score, shuxue_score) values (Li Danli, 10, female, 96,28)
insert into name (name, age, sex, yuwen_score, shuxue_score) values (Kanglan Rong, 49, female, 73,100)
insert into name (name, age, sex, yuwen_score, shuxue_score) values (Bi Yanyan, 62, female, 57,42))
- 2013-12-07 21:37:09下载
- 积分:1