It looks like you are using the sqlite3 shell, so experiment with .separator
Have you used .help?
Rgds,
Simon
yes i am using sqlite3 shell, i mean not to make display like mysql does, but
the difference column that i want like mysql does.
take a look at this different
A1221|SMALL|FOOD|CAKE|HOMS 1|2007-05-06 11:31:57|2007-05-06 11:42:46|649 (this
is done with sqlite)
A1221 SMALL FOOD CAKE HOMS 1 2007-5-6 11:31:57 2007-5-6
11:31:57 0 (this is done with mysql)
why in sqlite we got (649) : 2007-05-06 11:31:57|2007-05-06 11:42:46|649
and in mysql we got (0) : 2007-5-6 11:31:57 2007-5-6 11:31:57 0
or i think the reason is like i found in mysql documentation like this :
"If you use LEFT JOIN to find rows that do not exist in some table and you have
the following test: col_name IS NULL in the WHERE part, where col_name is a
column that is declared as NOT NULL, MySQL stops searching for more rows (for a
particular key combination) after it has found one row that matches the LEFT
JOIN condition. "
i also have test with left join but the result don't like mysql does.
sory for my less knowledge
thanks
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
