On 3/15/19, Scott Perry wrote:
> The behaviour of ALTER TABLE changed in 3.25.0 and breaks compatibility with
> many existing applications. Your statements (corrected for use of single
> quotes, as Ryan mentioned) work for me when `PRAGMA legacy_alter_table=1;`.
All true. But even so, SQLite
The behaviour of ALTER TABLE changed in 3.25.0 and breaks compatibility with
many existing applications. Your statements (corrected for use of single
quotes, as Ryan mentioned) work for me when `PRAGMA legacy_alter_table=1;`.
More info on SQLite's website:
Link to my database in in the original post.
https://drive.google.com/file/d/1RCPoPgoLdc2VgF2uX2zPFrkheFi9z3b_/view?usp=sharing
Tomasz Jerzykowski
W dniu 2019-03-15 14:46:19 użytkownik R Smith napisał:
> For a start, do not use single quotes for table names. In SQL, DB object
> identifiers
For a start, do not use single quotes for table names. In SQL, DB object
identifiers can either be unquoted or contained in double-quotes. SQLite
specifically even allows backticks or square brackets for compatibility,
but nobody likes single quotes.
I.e. change this:
drop table
I'm having corruption problem with a certain database file. You can download it
here:
https://drive.google.com/file/d/1RCPoPgoLdc2VgF2uX2zPFrkheFi9z3b_/view?usp=sharing
It was created with SQLite 3.8.7 or older version (I cannot say for sure now)
I open it with sqlite3.exe and run the following
5 matches
Mail list logo