Category Archives: MySQL

MySQL storage engines

Posted on May 9, 2012 by harshal.kulkarni

MySQL supports the following the table types or storage engines: 1. ISAM 2. MyISAM 3. InnoDB 4. BerkeleyDB(BDB) 5. MERGE 6. HEAP While considering the table types you have to mainly focus on the following factors: 1. Transaction safe 2. … Continue reading →

Posted in MySQL | Tagged , , , , | Leave a comment

Export MySQL Data in CSV File Through External URL

Posted on April 1, 2012 by pravin.sonawane

As you know, many of your clients need MySQL data stored on a daily, weekly or monthly basis from you. But if there is no option to share this data through web application or any other medium, then it will be … Continue reading →

Posted in Database, MySQL | Tagged , , , , , | Leave a comment

Delete/Truncate data from all Tables in SQL Server

Posted on March 18, 2012 by amol.ahirrao

We usually use a dummy database for testing. It gets filled with a lot of unwanted temporary data. At the time of deployment we replicate this database into Live Database. While doing so we need to delete all data from … Continue reading →

Posted in Database, MySQL | Tagged , , , | Leave a comment