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

Reply via email to