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
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
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
3 matches
Mail list logo