The Rambling Chronicles: Notes

Posts Tagged ‘sql’

1. MySQL string replace

   23rd Mar 2010

   Keep forgetting this. Replace a string in all rows:

   UPDATE <table> SET <column> = REPLACE(<column>, '<string to find>', '<string to replace>');

   Tags: mysql, replace, sql, string
   

   
   No Comments »

2. MySQL reset auto_increment

   6th Sep 2009

   Because I keep forgetting it: ALTER TABLE the_table AUTO_INCREMENT= 0

   Tags: auto_increment, mysql, sql
   

   
   2 Comments »

3. import CSV into MySQL

   5th Sep 2009

   Run from mysql program with FILE privileges or it won’t work.

   LOAD DATA LOCAL INFILE '/importfile.csv'
   INTO TABLE test_table
   FIELDS TERMINATED BY ','
   LINES TERMINATED BY '\n'
   (field1, filed2, field3);

   Note: Path needs to be absolute

   Tags: csv, import, mysql, sql
   

   
   No Comments »