db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Problem with insertng values to varchar column
Date Sun, 25 Apr 2010 14:40:58 GMT
Eranda Sooriyabandara wrote:
> ij> INSERT INTO table2 VALUES(`aa'),(`ab'),(`ac');
>  
> The message I got after fored exit,
> 
> ERROR 42X02: Lexical error at line 1, column 27.  Encountered: "`" (96), 
> after :

I think the mis-matched quotation marks caused the behavior that you see.

Try using only the single quotation mark (') for both the start and
end of the string, as in:

INSERT INTO table2 VALUES('aa'),('ab'),('ac');

thanks,

bryan

Mime
View raw message