>
> INSERT INTO SELECT * FROM ;
>
> However, this only works if already exists, which is actually
> quite cumbersome..
> Is there a way to make the new table 'on the fly"?
create table newtable as select * from oldtable;
Bernhard
___
sqlite-users
Hi folks,
I would like to query a table and put the result in a new table, as in
INSERT INTO SELECT * FROM ;
However, this only works if already exists, which is actually
quite cumbersome..
Is there a way to make the new table 'on the fly"?
Regards,
Bertwim
On 21 Sep 2013, at 12:14am, Jared Albers wrote:
> I was unsure if the rowid of a subquery even existed until I selected it. I
> reviewed the output and determined that it was what I expected of a rowid
> from a subquery (simply an auto-incremented int of the result set
>After laboriously translating your schema and query into something
>readable, I get script shown below.
Apologies. I assumed you planned on recreating the database and that
readability wouldn't be an issue.
>We (all SQLite developers have been consulted and agree) conclude that the
>result of
Hello,
There is a minimalist one here:
https://github.com/gwenn/sqliterd
It depends on c/go compilers and the graphviz dot command...
Regards.
On Fri, Sep 20, 2013 at 2:26 PM, Jason H wrote:
> Don't forget about ODBC tools... Just use ta SQLite ODBC driver...
>
>
>
On Fri, Sep 20, 2013 at 9:23 AM, Keith Medcalf wrote:
>
> Nice fix Richard, and it works as you have documented.
>
> With the added [cebd6fc551] to reset iCurrentTime when the statement is
> reset, my testing indicates that if the p->iCurrentTime=0; added at line
> 570 of
Nice fix Richard, and it works as you have documented.
With the added [cebd6fc551] to reset iCurrentTime when the statement is reset,
my testing indicates that if the p->iCurrentTime=0; added at line 570 of vdbe.c
by the original patch [daf6ba413c] (change fragment [56e648f5ba9a9181]) is
Don't forget about ODBC tools... Just use ta SQLite ODBC driver...
From: dd
To: General Discussion of SQLite Database
Sent: Friday, September 20, 2013 8:11 AM
Subject: [sqlite] Any tool to create erd from sqlite
I am looking for tool which generates er diagrams from existing database.
Any suggetions?
Thanks in advance.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Igor Korot wrote:
> I need to check if the COMMIT is successful.
> But what should I do if it fails?
If the database is currently locked, you should try again later. (But
this would be better handled with a busy handler.)
If there is some I/O error that prevents you from writing, the COMMIT
10 matches
Mail list logo