471,887 Members | 1,163 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,887 software developers and data experts.

SQLITE -> MySQL syntax differences complete list

1,584 Expert 1GB
I'm trying to convert an SQLITE database to MySQL syntax and it seems every resource I find on google is only half complete.

I want to create this thread to sum them all up in one central location; Finally a bulleted list of all the rules you have to apply to your script to completely and fully transfer /any/ sqlite schema dump to a MySQL one.

For this I need your help; I'll start with the popular few, anyone notice any other difference, please post it in a reply. Please keep the same bulleted numbering. If you correct a mistake, note the bullet number (e.g. number 3 is wrong, should be...)

2. Replace all double quotes " with back-ticks `
3. Remove any line that begins with "sqlite..."
5. ???

Thanks in advance for helping this resource; I'm sure many will find it useful.

Jul 6 '09 #1
1 8707
1,584 Expert 1GB
5. Replace "shortint" with "tinyint"

Optional: Add DROP TABLE IF EXISTS or IF NOT EXISTS to table commands, based on your specific needs of course.

Optional: Ignore the "metadata" table that sqlite dump creates.

Jul 6 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Ruby Tuesday | last post: by
2 posts views Thread by aum | last post: by
3 posts views Thread by Daniel | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.