From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <m.bykov@gmail.com>
X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on sa.int.altlinux.org
X-Spam-Level: 
X-Spam-Status: No, score=-2.2 required=5.0 tests=AWL,BAYES_00,SPF_PASS
	autolearn=ham version=3.2.5
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type:content-transfer-encoding;
	bh=2mCQ+igC8wLr7aEkoVgKB+I3BLbAby7XukS1gAqJ9OM=;
	b=N9mIx9dCHFgNlO/o+C+Kcq9SnWl3B8m6jGH6fArSV7PXNN1kvjFgkx0JleK07/8JRf
	h1PdHh/hLj9MqHj6u4DlPxcjLRefR4m+65zzryvLeSw2w373uLhjqb5aILYzu+aay7ai
	E5sPKicIwr4OJ9UtPIX3ELFaRMYAI8px2AYFs=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type
	:content-transfer-encoding;
	b=B8sR6eRf9BYi91OIqkDijfz8NP+yMJDJJxsMc0QbKHcGqoBPC5XqDJ/SmmHIGlv9iM
	+w3wajSIQ4OThyZ1lAFB4ac4W8ruhRT/YKoqMf+SwAUFalH4VkVe3o3tOjKxWOFg1+3D
	uUggmQXOy7eXaQXEj1S4mUJJhFtAHQqPZuZg8=
MIME-Version: 1.0
Date: Sun, 5 Jul 2009 17:21:43 +0400
Message-ID: <69c7dc8b0907050621n66a540efm89ae329903f71358@mail.gmail.com>
From: Michael Bykov <m.bykov@gmail.com>
To: ALT Linux Sisyphus discussions <sisyphus@lists.altlinux.org>
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: quoted-printable
Subject: [sisyphus] =?koi8-r?b?TXlTUUwgNS4xIMnaIOTFxMHMwQ==?=
X-BeenThere: sisyphus@lists.altlinux.org
X-Mailman-Version: 2.1.12
Precedence: list
Reply-To: ALT Linux Sisyphus discussions <sisyphus@lists.altlinux.org>
List-Id: ALT Linux Sisyphus discussions <sisyphus.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/options/sisyphus>,
	<mailto:sisyphus-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/sisyphus>
List-Post: <mailto:sisyphus@lists.altlinux.org>
List-Help: <mailto:sisyphus-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/sisyphus>,
	<mailto:sisyphus-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Sun, 05 Jul 2009 13:22:02 -0000
Archived-At: <http://lore.altlinux.org/sisyphus/69c7dc8b0907050621n66a540efm89ae329903f71358@mail.gmail.com/>
List-Archive: <http://lore.altlinux.org/sisyphus/>
List-Post: <mailto:sisyphus@altlinux.ru>

=F3=C1=CC=C0=D4,

=D3=CF=D2=D2=C9, =D0=D2=CF =E4=C5=C4=C1=CC, =CE=C1=D7=C5=D2=CE=CF=C5, =CF=
=C6=C6=D4=CF=D0=C9=CB.

=DA=C1=C7=C1=C4=CF=DE=CE=CF=C5 =D1=D7=CC=C5=CE=C9=C5, =CD=C9=C7=D2=C9=D2=CF=
=D7=C1=CC =CE=C1 5.1, =CB=C1=D6=C5=D4=D3=D1 =C2=C5=DA =D0=D2=CF=C2=CC=C5=CD=
. =E9 =D7=CF=D4 =D4=C5 =D2=C1=DA:

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;

=D7=D3=A3 =CF=D4=CC=C9=DE=CE=CF, select current_amount - =D7=D3=A3 =CF=D4=
=CC=C9=DE=CE=CF, =CE=CF

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

=F7 =DE=A3=CD =CD=CF=D6=C5=D4 =C2=D9=D4=D8 =D0=D2=C9=DE=C9=CE=C1? =EB=C1=CB=
 =D0=CF=D0=D2=C1=D7=C9=D4=D8?

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


=ED.