P
P
pcdesign2019-12-27 10:08:02
MySQL
pcdesign, 2019-12-27 10:08:02

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);;

All in square brackets.
What is this dump and how to transfer it to mysql?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2019-12-27
@pcdesign

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 question

Ask a Question

731 491 924 answers to any question