From: Dmitry Vodennikov <vod@elecom.ru>
To: community@altlinux.ru
Subject: Re: [Comm] MySQL
Date: Thu, 20 Jan 2005 01:01:36 -0800
Message-ID: <41EF7370.6090809@elecom.ru> (raw)
In-Reply-To: <200501191816.05191.steely@bk.ru>
Sergey Zazhigaev пишет:
> Здравствуй, All!
>
> Подскажите плиз, из-за чего может происходить подобное?
> И как это можно исправить?
> ===========================
> Ошибка
>
> SQL-запрос :
>
> CREATE TABLE Month_stat(
> id int( 11 ) NOT NULL AUTO_INCREMENT ,
> MONTH tinyint( 4 ) default NULL ,
> year int( 11 ) default NULL ,
> name varchar( 255 ) NOT NULL default '',
> ip varchar( 18 ) NOT NULL default '0.0.0.0/0',
> IN bigint( 20 ) default NULL ,
> out bigint( 20 ) default NULL ,
> PRIMARY KEY ( id )
> ) TYPE = MYISAM COMMENT = 'Траффик по месяцам'
>
> Ответ MySQL:
>
> #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 'in
> bigint(20) default NULL,
> out bigint(20) default NULL,
Есть сильное подозрение, что IN - это reserved word для всех sql-серверов.
Вам надо почитать что-нибудь типа mysql reserved words, чтобы в будущем
не наступать на подобные грабли.
next prev parent reply other threads:[~2005-01-20 9:01 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2005-01-19 15:16 Sergey Zazhigaev
2005-01-19 15:43 ` Alex Gorbachenko
2005-01-20 9:01 ` Dmitry Vodennikov [this message]
2005-01-20 23:25 ` Alexey S. Kuznetsov
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=41EF7370.6090809@elecom.ru \
--to=vod@elecom.ru \
--cc=community@altlinux.ru \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
ALT Linux Community general discussions
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 community community/ http://lore.altlinux.org/community \
mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com
public-inbox-index community
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.community
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git