🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: chile.comp.programacion
Article #219

Re: Donde esta el error

#219
From: gatocl.maipu
Date: Thu, 17 Feb 2011 05:54
48 lines
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-mail
References: <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>