SQL syntax error

Question

I use phpMyAdmin and want to create a table. I use the visual interface for creating the table but I'm gonna post the code from "Preview SQL" option:

CREATE TABLE `baza`.`koncert` ( 
    `koncert_id` INT(10) NOT NULL AUTO_INCREMENT , 
    `koncert_naziv` VARCHAR(50) NULL , 
    `koncert_lokacija` VARCHAR(50) NOT NULL , 
    `koncert_datum` DATE NULL DEFAULT NULL , 
    `koncert_cijena` DOUBLE(10) NOT NULL , 
    `koncert_slika` VARCHAR(500) NOT NULL ) 
ENGINE = InnoDB CHARSET=utf8 COLLATE utf8_croatian_ci;

And I get this error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL version for the right syntax to use near ')' NOT NULL, 'koncert_slika' VARCHAR(500) NOT NULL ) ENGINE=InnoDB CHARSET=ut

I tried setting the 'koncert_datum' default value to CURRENT_TIMESTAMP, but then I get an error "Invalid default value for 'koncert_datum'". I just don't understand what could possibly be wrong (and I used the phpMyAdmin visual interface to try create the table!)

javier · Accepted Answer · 2017-02-13 23:04:48Z

2

According to the documentation https://dev.mysql.com/doc/refman/5.7/en/floating-point-types.html the DOUBLE type needs total digits and decimal digits. Something like

`koncert_cijena` DOUBLE(12,2) NOT NULL ,

answered Feb 13, 2017 at 23:04

javier

1081 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bernard Polman Over a year ago

Thank you. Besides this, I've also had to add primary_key(koncert_id). Now it's working.

Mithunram · Accepted Answer · 2017-02-13 22:54:23Z

0

Check the schema and ensure baza.koncert is present and try running them by removing "ENGINE = InnoDB CHARSET=utf8 COLLATE utf8_croatian_ci" this.

answered Feb 13, 2017 at 22:54

Mithunram

485 bronze badges

Collectives™ on Stack Overflow

SQL syntax error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related