How to replace enum type in H2 database?

How to replace enum type in H2 database?

MySQL dialect:
CREATE TABLE My_Table ( my_column enum (‘first’, ‘second’, … ‘last’));

H2 dialect:
CREATE TABLE My_Table ( my_column ? (‘first’, ‘second’, … ‘last’));

What type is equivalent in H2 too the enum type from MySQL?

Solutions/Answers:

Solution 1:

I’m not sure

Read the rest “How to replace enum type in H2 database?”

Mysql left/inner join combination not working as expected

Mysql left/inner join combination not working as expected

I am trying to list product variations with their quantities ordered, BUT ALSO show the product variations where there is no quantity ordered. So I thought it would be as simple as selecting the products and doing a left join on the … Read the rest “Mysql left/inner join combination not working as expected”