Answer the question
In order to leave comments, you need to log in
What is this dump syntax and how to transfer it to mysql?
I got a dump like this:
CREATE TABLE [books](
[_id] INTEGER PRIMARY KEY,
[name_book] TEXT,
[autor_link] TEXT);;
Answer the question
In order to leave comments, you need to log in
This is the syntax of MS SQL.
But sqlite also knows how to do it for compatibility: https://www.sqlite.org/lang_keywords.html
Therefore, import first into sqlite, then export normally. In normal standard quotes - if your mysql is in sql_mode=ANSI_QUOTES - or in mysql-specific apostrophes `.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question