MySQL vs MongoDB (NoSQL) database MongoDB vs MySQL: Comparison Between Relational and Document Oriented Database Both are used for storing the data and free to use that is both comes under open-sources software. MongoDB might be unfamiliar at least to some of us as it is a relatively new compared to other established databases…
Import MySQL database using command line If you have a very large SQL dump file to import and you know very well that it is not very easy to import using phpMyAdmin, even if you split it in many pieces, it is also be hard using PHP script as it will time out after…
Prevent gaps/holes in a MySQL table AUTO_INCREMENT Primary Key field. Generally during the MySQL database development you create tables with a Primary Key, a very simple way to create a primary key is make it Auto-increment and unsigned integer with Not Null property right? I think most of you generally follow the above…
WordPress plugin activate deactivate all at once and Quickly Sometimes during troubleshooting, it’s recommend to deactivate all plugins and activate them one by one and suppose at that time you will not able to login in WordPress admin (wp-admin) or white screen of death. At the same point we need to disable all the plugin…
WordPress stores the URL in his database, one of my colleague is new bie for WordPress.He has developed a new WordPress site and client has given all the data to him.After making the full site ready, he get stuck that four most important tables have URL in it, so should all the data need to…
What is the difference between GROUP BY and ORDER BY in MySql? Mostly this question has been asked by the interviewer, even if you have used it many times but at that time generally the guy not satisfied the interviewer by the answer. Please go through the below and give very appropriate answer…
