随笔档案「2014年10月」 - yangyh

10 2014 档案

Mysql insert without auto-increase when duplicate

摘要：INSERT INTO video_tag_all(tagname,ctime) SELECT '利物浦',1413954816 FROM video_tag_all WHERE (SELECT last_insert_id(id) FROM video_tag_all WHER... 阅读全文

posted @ 2014-10-22 13:41 yangyh 阅读(499) 评论(1) 推荐(0)

Mysql Grant权限

摘要：查看用户权限：SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;权限取决于最上一条记录的值如果需要收回权限：REVOKE ALL PRIVILEGES ON *.* FROM 'root'@'ip1';上面这条SQL将置G... 阅读全文

posted @ 2014-10-08 20:43 yangyh 阅读(892) 评论(0) 推荐(0)