Mailing List Archive


Back to the month index Back to the list index
Steve Lawrence (lawst@discoveryweb.com)
Tue, 24 Sep 1996 08:53:29 -0600 

From: lawst@discoveryweb.com (Steve Lawrence)
Subject: Re: [mSQL] am i missing something
Date: Tue, 24 Sep 1996 08:53:29 -0600
Message-Id: <19960924145203.AAA14579@steve.discoveryweb.com>

>
>
> mSQL > insert into quests (id, qno, quest,rdate) values (3940376, 1,
'preop', 843291258)\g
>
> Query OK.

I always put ' ' symbols around my data like so:

mSQL > insert into quests (id, qno, quest,rdate) values ('3940376', '1',
'preop', '843291258')\g

Now, I usually use char data types too, so that may be what is going on
there, but then I never get the problem you are either.

--------------------------------------------------------------------------
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!