On Tue, Jun 28, 2011 at 8:50 PM, thilo wrote:
> > use SINGLE quotes, not double quotes.
> bummer, Thanks a lot
>
i PROMISE that you won't find such an obvious bug in sqlite3 ;).
sqlite uses single quotes because that's what ANSI SQL specifies. MySQL uses
(or can use) double
On 6/28/2011 8:45 PM, Stephan Beal wrote:
> On Tue, Jun 28, 2011 at 8:42 PM, thilo wrote:
>
>> sqlite> select (select v from t1 where n="a") wrong,* from a1;
>>
>
> use SINGLE quotes, not double quotes.
bummer, Thanks a lot
thilo
--
Dipl. Ing. Thilo Jeremias
Zur Rabenwiese
Use single quotes instead of double
sqlite> select (select v from t1 where n='a') wrong,* from a1;
wrong|a|b
2000|123|456
2000|999|999
Michael D. Black
Senior Scientist
NG Information Systems
Advanced Analytics Directorate
From:
string literals are enclose in single quotes not double quotes"
select (select v from t1 where n='a') wrong,* from a1;
On 6/28/2011 11:42 AM, thilo wrote:
> select (select v from t1 where n="a") wrong,* from a1;
___
sqlite-users mailing list
On Tue, Jun 28, 2011 at 8:42 PM, thilo wrote:
> sqlite> select (select v from t1 where n="a") wrong,* from a1;
>
use SINGLE quotes, not double quotes.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users
Hello there!
I found a strange behavior while doing a
select with a sub select that has a where clause with a value (here
'a') which is the same as a column id:
What am I missing here ?
SQLite version 3.7.5
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .mode
6 matches
Mail list logo