Skip to content

Instantly share code, notes, and snippets.

@lhcpig
Last active October 16, 2015 15:42
Show Gist options
  • Save lhcpig/43f97974849b2754ffe5 to your computer and use it in GitHub Desktop.
Save lhcpig/43f97974849b2754ffe5 to your computer and use it in GitHub Desktop.
  • show variables like'character_set_%'; 查看编码
  • set names utf8; 设置编码
  • load data infile "/answer" into table test1 fields terminated by '|'; mysql导入数据
  • update a join b on a.id = b.id set a.columnToUpdate = [something];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment