56,678
社区成员
发帖
与我相关
我的任务
分享
user001中文 e10adc3949ba59abbe56e057f20f883e NULL
user002 e10adc3949ba59abbe56e057f20f883e NULL
user003 e10adc3949ba59abbe56e057f20f883e NULL
user004 e10adc3949ba59abbe56e057f20f883e NULL
user005 e10adc3949ba59abbe56e057f20f883e NULL
user006 e10adc3949ba59abbe56e057f20f883e NULL
user007 e10adc3949ba59abbe56e057f20f883e NULL
user008 e10adc3949ba59abbe56e057f20f883e NULL
user009 e10adc3949ba59abbe56e057f20f883e NULL
user010 e10adc3949ba59abbe56e057f20f883e NULL
user008 e10adc3949ba59abbe56e057f20f883e NULL
user009 e10adc3949ba59abbe56e057f20f883e NULL
user010 e10adc3949ba59abbe56e057f20f883e NULL
LOAD DATA LOCAL INFILE "D:/users.txt"
INTO TABLE users
FIELDS TERMINATED BY "\t" ENCLOSED BY ""
LINES TERMINATED BY "\n" STARTING BY "" (username, password, avatar)
LOAD DATA LOCAL INFILE "D:/users.txt"
INTO TABLE users
FIELDS TERMINATED BY "\t" ENCLOSED BY ""
LINES TERMINATED BY "\n" STARTING BY ""
(username, password, @x)
set avatar=if(@x='NULL',null,@x);