Double quotes can be used to specify that you mean a database object when
the name of the object might be confused with a keyword. For example, my
company's database models a production system with various recipes. We
call them "cycles". But the word "cycle" appears to have some specific
meaning inside SQL (or at least, inside PostgreSQL). So, although the
query
SELECT * FROM cycle
works, we should probably use
SELECT * FROM "cycle"
to avoid any possible ambiguity.
RobR
On Fri, Sep 14, 2018 at 2:12 PM Rob Richardson <[email protected]>
wrote:
> The use of single quotes instead of double quotes in database queries is
> not limited to SQLite. That's part of the SQL standard.
>
> RobR
>
> On Fri, Sep 14, 2018 at 2:05 PM David Raymond <[email protected]>
> wrote:
>
>> Small typo:
>>
>> SELECT * FROM table2 JOIN table1
>> ON table1.rowid = table2.rowid
>> WHERE table1.name LIKE '%smth%'
>>
>>
>> -----Original Message-----
>> From: sqlite-users [mailto:[email protected]]
>> On Behalf Of Simon Slavin
>> Sent: Friday, September 14, 2018 1:59 PM
>> To: SQLite mailing list
>> Subject: Re: [sqlite] [SQLITE]select from a table and use its data to
>> select from another one
>>
>> On 14 Sep 2018, at 6:50pm, Maziar Parsijani <[email protected]>
>> wrote:
>>
>> > I have 2 tables with the same rowid now I want to :
>> > select rowid from table1 where table1 like "%smth%"
>> > select * from table2 where rowid =(selected rows before)
>> >
>> > I mean if I could do it in a same query.
>>
>> This is what JOIN is for.
>>
>> SELECT * FROM table2
>> JOIN table1.rowid = table2.rowid
>> WHERE table1.name LIKE '%smth%'
>>
>> Note that SQLite uses single quotes ' for text strings, not double quotes
>> ".
>>
>> Simon.
>> _______________________________________________
>> sqlite-users mailing list
>> [email protected]
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>> _______________________________________________
>> sqlite-users mailing list
>> [email protected]
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
