Thread View: chile.comp.programacion
4 messages
4 total messages
Started by Sting
Wed, 16 Feb 2011 16:07
Donde esta el error
Author: Sting
Date: Wed, 16 Feb 2011 16:07
Date: Wed, 16 Feb 2011 16:07
33 lines
2074 bytes
2074 bytes
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 ::::....
Re: Donde esta el error
Author: Pelao Despistao
Date: Wed, 16 Feb 2011 21:56
Date: Wed, 16 Feb 2011 21:56
40 lines
2530 bytes
2530 bytes
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... 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 ::::....
Re: Donde esta el error
Author: gatocl.maipu
Date: Thu, 17 Feb 2011 05:54
Date: Thu, 17 Feb 2011 05:54
48 lines
2739 bytes
2739 bytes
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 El 16/02/2011 01:07 p.m., Sting escribi�: > 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 ::::.... > >
Re: Donde esta el error
Author: gatocl.maipu
Date: Thu, 17 Feb 2011 05:54
Date: Thu, 17 Feb 2011 05:54
48 lines
2707 bytes
2707 bytes
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�: > 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 ::::.... > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads