On Fri, Aug 10, 2007 at 10:17:56AM -0500, Zoltan Tomory wrote:
The documentation examples at 3.1.6.1 have two variations:
Insert into TABLE (COL, …) values (COL*,…); which works where the values match the pattern of columns specified
Insert into TABLE values (COL,…); which seems not to work
in this case you should list values for each column in the table 'TABLE'.
Is this a typo in the documentation or have I committed a syntax error?
Also, I have syntax question about something I have not tried out. If I have a column I use for Last Name, how could I insert ‘O’Connell’ as the field is delimited with single quotes?
escape using \ or '. Niels
TIA
Zoltan Tomory
[1]zoltan.tomory@mobot.org
References
1. mailto:zoltan.tomory@mobot.org
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl