MySQL cheat sheet & examples

Chung Tran | 20 January 2014 , |

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

Useful postgresql database administration commands

Chung Tran | 13 November 2013 , |

Some useful commands for administrating postgreSQL database. 1. Viewing all current Postgresql connections to Database server SELEC...

Should we use ENUM type in mySQL?

Chung Tran | 31 July 2013 , |

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