Many to many relations are one of the mostly used relations in the relational database. It took a while for me to figure how to properly configure this relation in Symfony Doctrine. I am sharing this so it might be useful for someone. Used very simple example students and course. A student can opt for… Continue reading Symfony Doctrine Many to Many Relationship (ManyToMany)
Tag: mysql
Install MySQL 5.6 and phpMyAdmin on Ubuntu 16.04
To Install MySQL 5.6 and phpMyAdmin on Ubuntu just follow the command one by one bellow. For phpMyAdmin to work, you need PHP to be installed. To install PHP 5.6 😉
MySQL ORDER BY FIELD – Custom Field Sorting
Today I ran into a problem. I need to sort results of a given query by fixed column values. Example I have a column named status and which holds the following values 1,2,3,4 When I user normal sort method like Order By status ASC will return 1,2,3,4 Order By status DESC will return 4,3,2,1 Suppose… Continue reading MySQL ORDER BY FIELD – Custom Field Sorting