Category Archives: MySQL

Delete/Truncate data from all Tables in SQL Server

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

Export MySQL Data in CSV File Through External URL

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

MySQL storage engines

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