Fetch DEFAULT value from MySQL table or MySQL get DEFAULT value for Column or How to SELECT DEFAULT[Next...]

If you have already created your MySQL database and table and suddenly realize that one or more table columns need to be modified, you can either drop / delete / remove...[Next...]

Scope of this article is to guide beginners who have just started PHP programming and have never tried to connect to any database using PHP, although PHP have the...[Next...]

LAMP is the abbreviation of Linux, Apache, MySQL, PHP. In this article I’ll try to explain how you can install an Apache2 webserver on a CentOS 6.3...[Next...]

As per Wikipedia definition: LAMP is a solution stack of free, open source software. The acronym LAMP refers to the first letters...[Next...]

If you have noticed there is an exclamatory sign (!) after the post title, let me tell you I have deliberately placed it to express my surprise on the whole thing which I’m going t...[Next...]

I consider myself an amateur DBA because I’m not a professional MySQL DBA but at times I have to work with some MySQL Commands / Queries which are piece of cake for professional DB...[Next...]

If you have a situation in hand where you need to rename a STORED PROCEDURE in MySQL and not DROP it then there are 2 ways I could figure out to tackle it....[Next...]