May 24, 2011
Running multiple MySQL instances on MacOsX
Recently I had to look at a tool developed in-house to archive data from a main db cluster to an … Read More “Running multiple MySQL instances on MacOsX”
Category: MySQL
October 10, 2008
Exporting query details to csv file
Founded somewhere in the net. Really useful. From the Unix commandline (Bourne Shell compatible): output tab-seperated: echo “select * from … Read More “Exporting query details to csv file”
August 23, 2007
Import data into table from a file
Very useful feature of mysql: CREATE TEMPORARY TABLE table1(id int); LOAD DATA LOCAL INFILE ‘/dir/file’ INTO TABLE table1