Thanks for your answer. I'd like to know to what extent I can convert a Sqlite schema to a Mysql one, but I find the question interesting for itself. What if we forget about modifying commands and care only about retrieval?
Clemens Ladisch wrote: I wonder why you want to know this? Well, anything where you cannot use joins in the first place, such as UPDATE/DELETE commands: DELETE FROM question WHERE type_id IN (SELECT id FROM question_type WHERE name LIKE '%homework%') _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users