Hi,
I have a table as below.
CREATE TABLE If not exists test
(
ID NUMBER(5) NOT NULL,
NAME varchar(20),
) ;
I am trying to use csvwrite to write the contents of the table to a
file. But when I use the following csvwrite query, I am getting the
below syntax error.
call csvwrite('/opt/dump.csv', 'SELECT * FROM TEST where name='a'');
Syntax error in SQL statement "CALL CSVWRITE('/opt/dump.csv', 'SELECT
* FROM TEST where name='A[*]'') "; expected ")"; SQL statement:
call csvwrite('/opt/dump.csv', 'SELECT * FROM TEST where name='a'')
[42001-132] 42001/42001 (Help)
when I try to execute the query alone , it works fine.
SELECT * FROM TEST where name='a';
ID NAME
1 a
(1 row, 15 ms)
I am suspecting something I am doing wrong with escape sequence. Even
I tried the following two querirs using "escape" keyword also. But no
success.
call csvwrite('/opt/dump.csv', 'SELECT * FROM TEST where name=\'a\'
escape '\'');
Syntax error in SQL statement "CALL CSVWRITE('/opt/dump.csv', 'SELECT
* FROM TEST where name=\'A[*]\' escape '\'') "; expected ")"; SQL
statement:
call csvwrite('/opt/dump.csv', 'SELECT * FROM TEST where name=\'a\'
escape '\'') [42001-132] 42001/42001 (Help)
Can you please help me in correcting this query?
Thanks in advance,
Vijay
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
