UZPENG/Mysql.md

Last active February 28, 2018 11:09

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/UZPENG/9e1c6c52321b742956a8dde8a371ddb6.js"></script>
Save UZPENG/9e1c6c52321b742956a8dde8a371ddb6 to your computer and use it in GitHub Desktop.

Download ZIP

sql语句

Raw

Mysql.md

常用sql

delete from guazi where id 
in 
(select g1.id from 
(select * from guazi) as g1 
inner join 
(select * from guazi) as g2
using(name) 
where g1.id != g2.id);

命令

更改mysql时区 set time_zone="+8:00"

刷新权限
flush privileges