Article View: chile.comp.programacion
Article #219Re: Donde esta el error
From: 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 ::::.... > >
Technical Details
Message-ID:
<ijid91$3hu$2@news.nivel5.cl>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news2.glorb.com!news.kjsl.com!news.nivel5.cl!not-for-mailReferences:
<ijhaov$vll$1@news.nivel5.cl>Show Full Headers
Complete Article Headers
X-Google-Thread: 1593cb,84aa32026b491ac1 X-Google-NewGroupId: yes X-Google-Attributes: gide499fe1f24,domainid0,public,usenet X-Google-Language: ENGLISH,CP1252 Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news2.glorb.com!news.kjsl.com!news.nivel5.cl!not-for-mail From: "gatocl.maipu" <besr.maipuSINESTO@gmail.com> Newsgroups: chile.comp.programacion Subject: Re: Donde esta el error Date: Thu, 17 Feb 2011 02:54:52 -0300 Organization: Varios Lines: 48 Message-ID: <ijid91$3hu$2@news.nivel5.cl> References: <ijhaov$vll$1@news.nivel5.cl> NNTP-Posting-Host: pc-33-146-161-190.cm.vtr.net Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Trace: news.nivel5.cl 1297922145 3646 190.161.146.33 (17 Feb 2011 05:55:45 GMT) X-Complaints-To: news@news.nivel5.cl NNTP-Posting-Date: Thu, 17 Feb 2011 05:55:45 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.2.14) Gecko/20110207 Thunderbird/3.1.8 In-Reply-To: <ijhaov$vll$1@news.nivel5.cl>