数据库表SignUp,其中有以下字段"ID" "Email” “State” “City”四个字段。TXT文本文件内容如下:[email protected]
[email protected]
[email protected]
[email protected]
...我想把此类型TXT文件的内容导入到SignUp表中,达到如下效果:ID Email State City
1 [email protected] china 23
2 [email protected] china 06
3 [email protected] china 31
4 [email protected] china 16
其中"ID"字段递增,"Email"字段就是TXT文本的内容,"State"默认是china,"City"字段从01-31随机写入麻烦各位高手给一个写入的语句,感谢!
[email protected]
[email protected]
[email protected]
...我想把此类型TXT文件的内容导入到SignUp表中,达到如下效果:ID Email State City
1 [email protected] china 23
2 [email protected] china 06
3 [email protected] china 31
4 [email protected] china 16
其中"ID"字段递增,"Email"字段就是TXT文本的内容,"State"默认是china,"City"字段从01-31随机写入麻烦各位高手给一个写入的语句,感谢!
INTO TABLE SignUp(Email);UPDATE SignUp SET
City=RAND()*31;SELECT * FROM SignUp;