Samuele Locatelli
14 lines
400 B
SQL
14 lines
400 B
SQL
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; |