There is MySQL Dump - http://pastebin.com/ez4hmL9k How can I run this query to add a table to some local database.
Errors occur when executing the query, it does not understand the type "int", then "AUTO_INCREMENT".
How to be?
3 answers
On the SQLite site, there is a linux shell script that converts a MySQL dump into the desired form.
If you have problems with it - take a look at this section on the official SQLite website.
Nofate ♦ Nofate
32.5k 13 57 86
|
ANSI SQL standard anyway support all DBMS. But the advanced SQL in each of them is implemented differently. This applies to functions, and attributes, and everything else. Therefore, you need to find a conversion tool or adapt the resulting file yourself before downloading.
orkaan orkaan
708 3 eight
- Do you happen to know such a tool? - zerpico
- Good links for SQLite are @Nofate. At one time, I used en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL to convert from MySQL to PostgreSQL. - orkaan
|
Read from the file the query and bring them to a form understandable for SQLite, Compact
YYY YYY
1,338 6 7
- There are very large requests, I will take them to mind for a very long time. Considering that even opening such a file still hangs - zerpico
|