Posted by Jerry Stuckle on 10/01/06 21:01

larry@portcommodore.com wrote:
> C. wrote:
>
>>INSERT INTO MyTable (col1, col2) VALUES ('value1','value2')
>>
>>Should work on both.
>>
>
>
> Except on numbers? I read quoting number values in an SQL statement is
> not standard (and optional on MySQL).
>
> Larry
>

No. Numbers are not quoted in MySQL, per the SQL standard.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]