MySQL cheat sheet & examples

MySQL cheat sheet & examples, a list of useful mysql commands provides you the most commonly used. Show all databases mysql> s...

Error loading MySQLdb module image not found Mac OSX 10.9 Mavericks

I faced the following problem when try to run a django project in Mac OSX 10.9 Mavericks. It has Mysql-python module installed already. ...

Should we use ENUM type in mySQL?

Question: Lets say in some random table, you have a column named  status . It's real-world values would be either  enabled  or  disab...

[2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock)

I tried Yii Framework migration by using yiic in console. when yiic migrate database, it try to connect to db following the information that...