Donde esta el error

Sting

unread,

Feb 16, 2011, 11:07:16 AM2/16/11

to

CREATE TABLE `restaurantes` (
`restaurante_ID` mediumint(3) NOT NULL auto_increment,
`restaurante_long` varchar(30) NOT NULL default '0',
`restaurante_lat` varchar(30) NOT NULL default '0',
`restaurante_nombre` varchar(50) NOT NULL default ",
`restaurante_coment` text NOT NULL,
`restaurante_marcador` char(2) NOT NULL default ",
`restaurante_cocina` varchar(50) NOT NULL default ",
`restaurante_direcc` varchar(50) NOT NULL default ",
`restaurante_url` varchar(50) NOT NULL default ",
`restaurante_precio` varchar(10) NOT NULL default ",
`restaurante_ip` varchar(15) NOT NULL default ",
`restaurante_month` smallint(2) NOT NULL default '0',
`restaurante_day` smallint(2) NOT NULL default '0',
`restaurante_year` smallint(2) NOT NULL default '0',
`restaurante_time` varchar(15) NOT NULL default ",
`restaurante_valoracion` char(2) NOT NULL default '0',
PRIMARY KEY (`restaurante_ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

me tira este error

#1064 - 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
'ā?

Gracias de antemano

...:::: Sting ::::....

Pelao Despistao

unread,

Feb 16, 2011, 4:56:45 PM2/16/11

to

No debiese dar problemas salvo que los caracteres " sean comillas dobles y
no dos comillas simples.

Saludos.

"Sting" escribió en el mensaje de noticias:ijhaov$vll$1...@news.nivel5.cl...

gatocl.maipu

unread,

Feb 17, 2011, 12:54:25 AM2/17/11

to

Pusiste los valores default vacions con una sola " deben se
''.
Ademas al corregir eso me sale esto

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:062
Transfer Time : 00:00:00:000
Total Time : 00:00:00:062
Warning Code : 1287
'TYPE=storage_engine' is deprecated and will be removed in a future
release. Please use 'ENGINE=storage_engine' instead

> 'â?

gatocl.maipu

unread,

Feb 17, 2011, 12:54:52 AM2/17/11

to

Pusiste los valores default con una sola " deben se

''.
Ademas al corregir eso me sale esto

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:062
Transfer Time : 00:00:00:000
Total Time : 00:00:00:062
Warning Code : 1287
'TYPE=storage_engine' is deprecated and will be removed in a future
release. Please use 'ENGINE=storage_engine' instead

El 16/02/2011 01:07 p.m., Sting escribió:

> 'â?