/SQL/Replace string in whole database mysql stackoverflow

Replace string in whole database mysql stackoverflow

DECLARE col_names CURSOR FOR
  SELECT column_name
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE table_name = 'tbl_name'
  ORDER BY ordinal_position;


select FOUND_ROWS() into num_rows;

SET i = 1;
the_loop: LOOP

   IF i > num_rows THEN
        CLOSE col_names;
        LEAVE the_loop;
    END IF;


    FETCH col_names 
    INTO col_name;     

     //do whatever else you need to do with the col name

    SET i = i + 1;  
END LOOP the_loop;

Source: stackoverflow.com

Similar codes

1 vote177 views1 answer
Insert column after column mysql
SQL
0 vote146 views1 answer
Renommer schema sql
SQL
1 vote155 views1 answer
Mysql find tables with column name
SQL
1 vote169 views1 answer
Epoch time converter in snowflake
SQL
0 vote136 views1 answer
Postgres create extension if not exists
SQL
0 vote138 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
28 votes101 views6 answers
Distinct sql
SQL
16 votes172 views3 answers
Order by sql query
SQL
0 vote129 views1 answer
Remove from table where
SQL
5 votes142 views3 answers
Truncate function in sql oracle
SQL