Create an sql dump using the ".dump" command of the sqlite3 shell
tool:
$ echo .dump | sqlite3 database_file.db > dump.sql
Or just put the database file up for download somewhere. Or if you
prefer, send it to me by email. If this bug is present in current
versions, we need to fix it. But it's
Thanks Dan for the reply,
How would I go about creating a sql dump?
As for the ORDER BY clause, I do this:
SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c INNER JOIN
tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id AND a.d_id =
d.id AND c.e_id = e.id ORDER BY a.some_ot
On Mar 4, 2009, at 4:41 AM, Jonathon wrote:
> Hello,
>
> I am executing a query such as:
Can you post a database (or sql dump thereof) to run your queries
against? Also say exactly what ORDER BY clause you are adding to
the end of the query that causes it to return incorrect results?
Thanks,
Da
Hello,
I am executing a query such as:
1. SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c INNER
JOIN tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id AND
a.d_id = d.id AND c.e_id = e.id;
2.
3. CREATE TABLE tableA (
4. id INTEGER NOT NULL
On Mon, 2 Mar 2009 13:59:13 -0500, "Fazoogled"
wrote:
>I used to have a good cheat sheet on Joins that I cannot find anywhere. Must
>have been cleaning house and had a \delete' attack. But I'm going to need it
>for a little exercise I'm doing at home where I have a many to many table
>with a 'con
I used to have a good cheat sheet on Joins that I cannot find anywhere. Must
have been cleaning house and had a \delete' attack. But I'm going to need it
for a little exercise I'm doing at home where I have a many to many table
with a 'connector' (what I call it) table in between. I'm going to be
f
On Thu, 2007-02-01 at 21:18 +0100, Info wrote:
> If I use the following inner join of 3 tables:
>
> SELECT T1.A
> FROM(T1 INNER JOIN T2 ON T1.A=T2.A) INNER JOIN T3 ON T1.B=T3.B
>
> SQLite returns an error message saying that the column T1.A does not exist.
> If I run this statement on MysQL,
If I use the following inner join of 3 tables:
SELECT T1.A
FROM(T1 INNER JOIN T2 ON T1.A=T2.A) INNER JOIN T3 ON T1.B=T3.B
SQLite returns an error message saying that the column T1.A does not exist.
If I run this statement on MysQL, Oracle or DB2, they accept it. And in
fact, this is correct
8 matches
Mail list logo
