mysql tips

1. Do not use 'database'  as a column name. 

You get error for the following query:

select name, status, database from config where id = 1

2. ERROR 1062 (23000) : Duplicate entry

解决办法 导出这个表 然后 去掉主键 后的unique就OK了 很简单

3. Can't start server : Bind on unix socket: Permission denied

修改/opt/lampp/var/mysql的写权限