Browsing: MySQL Snippet

This section contains various MySQL snippet or call it hacks related to mysql database server. These codes proves more than useful in day to day programming.

MySQL Snippet Mysql Snippet
2

Most newbies make mistake by not creating primary-foreign key relationship between tables. They just assume table column as primary-foreign which leads to many error later on. In this tutorial you will learn the write sql to create foreign keys and join tables.

MySQL Snippet Mysql Snippet
0

There are times when you prefer using mysql function over PHP function. For example in case of fetching names of user from a table you want to get the concatenated user name (first name, middle name, last name).

Get more stuff like this
in your inbox

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.