Angela Mariela Crespo Herreras
PreguntaAyuda!
mysql> CREATE TABLE IF NOT EXISTS books (
-> book_id (INTEGER UNSIGNED, PRIMARY KEY, AUTO_INCREMENT),
-> author ,
-> title (VARCHAR (100), NOT NULL),
-> year (INTEGER UNSIGNED, NOT NULL, DEFAULT ‘1900’),
-> language (VARCHAR (2), NOT NULL, DEFAULT ‘es’, COMMENT ‘ISO 639-1 Language’),
-> cover_url (VARCHAR (500)),
-> price (DOUBLE (6,2), NOT NULL, DEFAULT ‘10.0’),
-> sellable (TINYINT (1), DEFAULT ‘1’),
-> copies (INTEGER, NOT NULL, DEFAULT ‘1’),
-> descripcion (TEXT));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(INTEGER UNSIGNED, PRIMARY KEY, AUTO_INCREMENT),
author ,
title (VARCHAR (100), ’ at line 2
Angela Mariela Crespo Herreras
Gracias mil, eso mismo era. Pude resolver.
Carlos Eduardo Gomez García
¡Hola!, lo más probable es que sea porque no le pusiste el tipo de dato a la columna
authorCREATE TABLE IF NOT EXISTS books ( -> book_id (INTEGER UNSIGNED, PRIMARY KEY, AUTO_INCREMENT), -> author (VARCHAR (100), NOT NULL), -> title (VARCHAR (100), NOT NULL), -> year (INTEGER UNSIGNED, NOT NULL, DEFAULT ‘1900’), -> language (VARCHAR (2), NOT NULL, DEFAULT ‘es’, COMMENT ‘ISO 639-1 Language’), -> cover_url (VARCHAR (500)), -> price (DOUBLE (6,2), NOT NULL, DEFAULT ‘10.0’), -> sellable (TINYINT (1), DEFAULT ‘1’), -> copies (INTEGER, NOT NULL, DEFAULT ‘1’), -> descripcion (TEXT));
