Monthly Archives: January 2009
Export MySQL table as csv file
Exporting from an RDBMS always depends on the syntax of the specific RDBMS in question. For MySQL, here is how to transform a SELECT statement into a CSV export: SELECT a,b INTO OUTFILE ‘/tmp/result.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED … Continue reading
Posted in Data Warehouse, Dedicated Servers, Hosting Support, Managed Hosting Tagged csv, MySQL Leave a comment
Drop Index in MySQL takes forever
Even though for our core systems we have migrated most databases to DB2, we still have to deal with MySQL for some side systems, such as CRM, Blog, etc. One of the MySQL features that I recently noticed is … Continue reading
Posted in Data Warehouse, Dedicated Servers, Hosting Support, Managed Hosting Tagged drop index, myisamchk, MySQL, SQL Leave a comment
 |