Wednesday, February 10, 2010

MySql Tips


Loading data from a text file :
LOAD DATA INFILE 'aino.txt' INTO TABLE products_options_values (products_options_values_name);
 
(Text file is read from the database directory of the default database)

Removing spaces :
update products_options_values set products_options_values_name = REPLACE(products_options_values_name,' ' ,'');

Share Article : MySql Tips
Share/Save/Bookmark