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

MySql Tips