0

I want to alter a table by modifying many columns from varchar(200) to tinytext for one column i can use this request

ALTER TABLE contacts MODIFY "column_name" TINYTEXT

i can get a list of columns using this request

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA= "base561"
AND COLUMN_TYPE="varchar(200)"
AND TABLE_NAME="contacts"

How i can combine both requests that i cant modify all my columns to TINYTEXT.

Thank you.

0 Answers0