?? genrec.awk
字號:
END { srand(); USER_INFO="user_info.ctl"; printf("load data\ninfile *\nappend\ninto table user_info\nfields terminated by '|'\n(\n\tloginname\t\tchar(12),\n\tcreate_ts\tdate(14) 'YYYYMMDDHH24MISS',\n\tupdate_ts\tdate(14) 'YYYYMMDDHH24MISS',\n\tstatus\t\tchar(1),\n\tpassword\t\tchar(8),\t\n\tnickname\t\tchar(20),\n\tregister_dt\tchar(8),\n\tage\t\tinteger external,\n\tincome\t\tinteger external,\n\temail\t\tchar(30),\n\taddress\t\tchar(100),\n\tintroduction\t\tchar(500)\n)\nbegindata\n") > USER_INFO; for(i=1; i<=3000000; i++) { printf("arron%07d|20020101000000|20020101000000|1|%06d|阿隆%07d|20020101|%02d|%012.0lf|zhou_arron_%07d@xxx.com|中國上海南京西路%07d號|The Truth Is Out There\n",i,int(rand()*1000000),i,int(rand()*50),rand()*10000,i,i) >> USER_INFO; }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -