SQL To insert content from Select Query

INSERT INTO `garment`.`meta_my_sequence_table`
            (`id`,
             `sequence`)

SELECT 0,TYPE_CODE FROM meta_transaction_types WHERE type_code LIKE '%R' ;

Share Article : SQL To insert content from Select Query

SQL To insert content from Select Query

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