Mailing List Archive


Back to the month index Back to the list index
HELLFiRE (dron@netclub.ru)
Mon, 6 Jan 1997 16:24:33 +0300 

Date: Mon, 6 Jan 1997 16:24:33 +0300
From: HELLFiRE <dron@netclub.ru>
Subject: [mSQL] Update problem
Message-Id: <Pine.3.89.9701061605.A9179-0100000@netclub.ru>

Why this query not working ?

table:
CREATE TABLE stat ( Acct_Session_Id CHAR(255) NOT NULL,
                    User_Name CHAR(255), Client_Port_Id INT )
CREATE UNIQUE INDEX idx1 ON stat ( Acct_Session_Id )

my query:
UPDATE stat SET User_Name = 'ipodisey' WHERE Acct_Session_Id = 'A0000007'
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
it say "Query OK. 1 row(s) modified or retrieved.", but nothing changed..
it is not updating User_Name ...it is updating integer values,but not
strings ;(

i running Linux 2.0.24 and msql2.0b1, accessing from localhost
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!