• Jobs
  • About Us
  • professionals
    • Home
    • Jobs
    • Courses and challenges
  • business
    • Home
    • Post vacancy
    • Our process
    • Pricing
    • Assessments
    • Payroll
    • Blog
    • Sales
    • Salary Calculator

0

196
Views
Cómo convertir una línea con palabras clave de ÍNDICE ÚNICO de mySql a 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';

¿Cómo convertir esta línea: UNIQUE INDEX userID_UNIQUE ( userId ASC) de la sintaxis mySQL a la sintaxis H2?

about 3 years ago · Santiago Trujillo
1 answers
Answer question

0

Desde el sitio h2database.com :

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

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Our process Sales
Legal
Terms and conditions Privacy policy
© 2025 PeakU Inc. All Rights Reserved.

Andres GPT

Recommend me some offers
I have an error