[h2] Re: H2 DB fails to add multiple columns at the same time

Hi, You caught that error, because that the MySQL query incomparable with the h2 syntax. (I suppose) look at http://www.h2database.com/html/grammar.html#alter_table_add. This case contains two problems: 1. You should remove the keyword "COLUMN" from your query. 2. Second, add multiple columns

[h2] H2 DB fails to add multiple columns at the same time

Hi, I'm trying to run this query on a H2 DB MYSQL mode instance: ALTER TABLE `data` ADD COLUMN `creation_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, ADD COLUMN `last_modified_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, ADD COLUMN user_name varchar(384)