By definition, A % B B. Thus, if B fits into an int (be it 32-bit or
16-bit or otherwise), then A % B would too.
I'm not sure this is *strictly* true if negative numbers are involved; e.g.
-4 % -3 = -1.
But it's still true to say it's closer to zero, and thus should always fit
into an int.
I'm considering working with a dump of the SQL database, and I'm anxious to
make sure that nothing gets lost in the transformation.
I'm aware that the database will effectively be vacuumed and that rowids
won't be preserved. I'm happy about the first and can live with the second.
What else isn't
Is it possible to use triggers for this?
Yes.
Triggers may be created on views, as well as ordinary tables, by
specifying INSTEAD OF in the CREATE TRIGGER statement. If one or more ON
INSERT, ON DELETE or ON UPDATE triggers are defined on a view, then it is
not an error to execute an INSERT,
I can see situations in which you might want to create a new table with a
name that wasn't already taken: at which point simple knowledge would let
you reconsider your choice of table name without affecting the db in any
way, success or fail.
On Thu, Dec 6, 2012 at 10:57 AM, Hick Gunter
If you get no rows returned, you could query SELECT COUNT(*) FROM table1;
(If you get rows returned, you know that the number skipped is the size of
your offset.)
On Thu, Dec 6, 2012 at 11:44 AM, Steffen Mangold
steffen.mang...@balticsd.de wrote:
Hi,
I want to know if there is a possibility
... SELECT b FROM mytable WHERE b = c will give you each row of the
database which has identical b and c values.
... SELECT b FROM mytable AS m2 WHERE m2.b = m1.c will join the two views
of the database together, so if mytable contains
b,c
1,2
2,3
the combined table for this subquery looks like:
The behaviour of quoting with [identifier] or `identifier` seems to do what
you want, but, as the docs say, these are not standard SQL.
http://www.sqlite.org/lang_keywords.html
It's not a great option, since it forces you to have nonstandard SQL, but
it's a potentially useful one to have on the