ALT Linux Sisyphus discussions
 help / color / mirror / Atom feed
From: Michael Bykov <m.bykov@gmail.com>
To: ALT Linux Sisyphus discussions <sisyphus@lists.altlinux.org>
Subject: [sisyphus] MySQL 5.1 из Дедала
Date: Sun, 5 Jul 2009 17:21:43 +0400
Message-ID: <69c7dc8b0907050621n66a540efm89ae329903f71358@mail.gmail.com> (raw)

Салют,

сорри, про Дедал, наверное, оффтопик.

загадочное явление, мигрировал на 5.1, кажется без проблем. И вот те раз:

mysql> show fields from assets;
+-------------------+---------------+------+-----+---------+----------------+
| Field             | Type          | Null | Key | Default | Extra          |
+-------------------+---------------+------+-----+---------+----------------+
| accessible        | int(11)       | YES  |     | NULL    |                |
| current_amount    | int(11)       | YES  |     | NULL    |                |
| store_id          | int(11)       | YES  | MUL | 0       |                |
| group_id          | int(11)       | YES  | MUL | 0       |                |

select * from assets where store_id > 0;

всё отлично, select current_amount - всё отлично, но

mysql> select * from assets where accessible > 0;
ERROR 1064 (42000): 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 'accessible > 0' at line 1

В чём может быть причина? Как поправить?

MySQL5.1-server-5.1.28-alt0.1.i586.rpm


М.


             reply	other threads:[~2009-07-05 13:21 UTC|newest]

Thread overview: 3+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2009-07-05 13:21 Michael Bykov [this message]
2009-07-05 13:42 ` Vladimir Lettiev
2009-07-05 13:49   ` Michael Bykov

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=69c7dc8b0907050621n66a540efm89ae329903f71358@mail.gmail.com \
    --to=m.bykov@gmail.com \
    --cc=sisyphus@lists.altlinux.org \
    /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 Sisyphus discussions

This inbox may be cloned and mirrored by anyone:

	git clone --mirror http://lore.altlinux.org/sisyphus/0 sisyphus/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 sisyphus sisyphus/ http://lore.altlinux.org/sisyphus \
		sisyphus@altlinux.ru sisyphus@altlinux.org sisyphus@lists.altlinux.org sisyphus@lists.altlinux.ru sisyphus@lists.altlinux.com sisyphus@linuxteam.iplabs.ru sisyphus@list.linux-os.ru
	public-inbox-index sisyphus

Example config snippet for mirrors.
Newsgroup available over NNTP:
	nntp://lore.altlinux.org/org.altlinux.lists.sisyphus


AGPL code for this site: git clone https://public-inbox.org/public-inbox.git