Company logo
  • Jobs
  • Bootcamp
  • About Us
  • For professionals
    • Home
    • Jobs
    • Courses
    • Questions
    • Teachers
    • Bootcamp
  • For business
    • Home
    • Our process
    • Plans
    • Assessments
    • Payroll
    • Blog
    • Sales
    • Calculator

0

98
Views
How to convert line with UNIQUE INDEX key words from mySql to H2
CREATE TABLE IF NOT EXISTS Account (
  `userId` INT NOT NULL AUTO_INCREMENT,
  `first_name` VARCHAR(45) NOT NULL,
  `last_name` VARCHAR(45) NOT NULL,
  `email` VARCHAR(45) NULL,
  `ICQ` INT NULL,
  `home_address` VARCHAR(45) NULL,
  `work_address` VARCHAR(45) NULL,
  `skype` VARCHAR(45) NULL,
  `additional_info` VARCHAR(450) NULL,
  PRIMARY KEY (`userId`))
 UNIQUE INDEX `userID_UNIQUE` (`userId` ASC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account';

how to convert this line: UNIQUE INDEXuserID_UNIQUE(userIdASC) from mySQL syntax to H2 syntax ?

8 months ago · Santiago Trujillo
1 answers
Answer question

0

From the site h2database.com :

ALTER TABLE Account ADD CONSTRAINT userID_UNIQUE UNIQUE(userId);
8 months ago · Santiago Trujillo Report
Answer question
Find remote jobs