News

The ALTER TABLE.. MODIFY COLUMN statement modifies a column on an existing table. The modification can include changing the data type and attributes. To rename at the same time, use the CHANGE COLUMN ...
String sql = "ALTER TABLE mytable ADD COLUMN uidpublic UUID NOT NULL, ADD COLUMN type varchar (256) COLLATE "POSIX""; jdbcTemplate.execute (sql); The migration is okay, my table is altered. But a ...