In the console input Update - Database - then execute the transaction after the verbose

Set @ columnType:=(select case the lower (IS_NULLABLE) when the 'no' then CONCAT (column_type, 'the not null') when 'yes' then column_type end from information_schema. The columns where table_name=' Address 'and column_name=' Address 'and table_schema=DATABASE ());
The set @ SQLSTMT:=(select concat (' the alter table ` Address ` change ` Address ` ` Address1 ` ', @ columnType));
Prepare STMT from @ SQLSTMT;
The execute STMT.
Deallocate prepare STMT.

Don't understand what meaning, and then there was a error

You have an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1
'NULL'For the solution!