On Thu, 4 Jul 2013 22:52:26 +0100, Simon Slavin <slav...@bigfraud.org>
wrote:
>
> I assume you missed a comma:
>
> create table lookup (index int, start int, end int)
indeed
> But actually it’s a bad idea to use the words
> 'index' and 'end’ for columns because they're
> used as reserved words in SQL.
I agree.
> So try something like
> create table lookup (rowindex int, rangestart int, rangeend int)
Even better:
create table lookup (
rowindex INTEGER PRIMARY KEY
, rangestart int
, rangeend int
);
This way, rowindex aliases the internal ROWID column, saving an integer
column. Also, JOIN performance on rowindex will be better as it removes
one level of indirection.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
