[sqlite] SQL Syntax To Copy A Table

2015-03-29 Thread Maurizio Trevisani
I suggest to use the CloneTable function Have a look at https://www.gaia-gis.it/fossil/libspatialite/wiki?name=CloneTable It copies the table and all of its triggers, indexes, etc. Maurizio 2015-03-26 16:35 GMT+01:00, John McKown : > On Thu, Mar 26, 2015 at 10:29 AM, Nigel Verity > wrote: >>

[sqlite] Why is empty string not equal to empty blob?

2015-03-29 Thread Luuk
On 29-3-2015 18:53, Simon Slavin wrote: > >> On 29 Mar 2015, at 5:31pm, Luuk wrote: >> >> On 19-3-2015 16:02, Simon Slavin wrote: >>> >>> One is a string. The other is a BLOB. SQLite doesn't even get as far as >>> testing the contents, it knows they are of different types. >> >>

[sqlite] Why is empty string not equal to empty blob?

2015-03-29 Thread Luuk
On 19-3-2015 16:02, Simon Slavin wrote: > > On 19 Mar 2015, at 2:56pm, Paul wrote: > >> Maybe this question was already asked and explained. >> Or maybe it is documented somewhere (could not fiund it). >> Sorry, if this is the case, but why does >> >> SELECT '' = x''; >> >> yields 0? > > One is a

[sqlite] Why is empty string not equal to empty blob?

2015-03-29 Thread Simon Slavin
> On 29 Mar 2015, at 5:31pm, Luuk wrote: > > On 19-3-2015 16:02, Simon Slavin wrote: >> >> One is a string. The other is a BLOB. SQLite doesn't even get as far as >> testing the contents, it knows they are of different types. > > C:\temp>sqlite3 > SQLite version 3.8.8.3 2015-02-25 13:29:11

[sqlite] Why is empty string not equal to empty blob?

2015-03-29 Thread Keith Medcalf
On Sunday, 29 March, 2015 10:31, Luuk inquired: >On 19-3-2015 16:02, Simon Slavin wrote: >> On 19 Mar 2015, at 2:56pm, Paul wrote: >>> Maybe this question was already asked and explained. >>> Or maybe it is documented somewhere (could not fiund it). >>> Sorry, if this is the case, but why does