[MonetDB-users] insert syntax in example
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
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?
TIA
Zoltan Tomory
zoltan.tomory@mobot.org
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
- 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
participants (2)
-
Niels Nes
-
Zoltan Tomory