SELECT CONCAT( 'ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' MODIFY ', COLUMN_NAME, ' ', COLUMN_TYPE, ' NOT NULL DEFAULT \'\';' ) AS query_di_correzione FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'eqn_prod' AND DATA_TYPE IN ( 'blob', 'tinyblob', 'mediumblob', 'longblob' ) AND IS_NULLABLE = 'NO' AND COLUMN_DEFAULT IS NULL;