>> SELECT COUNT(*) FROM A,B
>
>Is "A,B" a way of expressing "A JOIN B" ? I've never seen it before.
Yes. It is part of the SQL language definition since before there was an SQL
language definition.
"," means "JOIN" or more pedantically "INNER JOIN". "ON" means "WHERE". The
only circumstance
On 8 Dec 2013, at 11:03pm, skywind mailing lists
wrote:
> SELECT COUNT(*) FROM A,B
Is "A,B" a way of expressing "A JOIN B" ? I've never seen it before.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mail
On Sun, Dec 8, 2013 at 5:27 AM, JamesWildDev wrote:
> Hello.
>
> I'm developing a small games engine in my spare time which stores all of
> its
> content in a SQLite3 database file, with a C#/.NET/Mono editor package
> creating records and a portable C/OpenGL player application performing
> querie
Assume I have the following tables:
CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude,
FromLongitude,TillLongitude);
and there is an index on A for Latitude,Longitude. B is filled using
INSERT INTO B SELECT
On 8 Dec 2013, at 9:34pm, Nikos Platis wrote:
> I tried to order a table by a column containing greek strings and I found
> out that sqlite does not sort them correctly. It probably uses the order of
> greek characters in the Unicode table, while the correct order is vastly
> different.
If you'
On Sun, Dec 8, 2013 at 11:34 PM, Nikos Platis wrote:
>
> Unfortunately, this ordering of greek characters is useless in practice, so
> the correctly behavior should be implemented.
>
You can implement your own CI-AI greek collation and use it in your columns
that contain greek text. It really is
I tried to order a table by a column containing greek strings and I found
out that sqlite does not sort them correctly. It probably uses the order of
greek characters in the Unicode table, while the correct order is vastly
different.
Here is the correct order of greek characters (mixed case) as pr
Hello.
I'm developing a small games engine in my spare time which stores all of its
content in a SQLite3 database file, with a C#/.NET/Mono editor package
creating records and a portable C/OpenGL player application performing
queries to load content and generate the data required. It's proving to
8 matches
Mail list logo
