LoginSignup
2
0

More than 5 years have passed since last update.

@shiba0410

mysqlへのDDLインポート

Last updated at Posted at 2018-04-06

コマンドライン上からMySQLへのDDLインポートは

mysql -u root -p <db_name> <<ddl_path>

インポートの際に

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = InnoDB'

このエラーはmysqlのバージョンによる記法の違いが原因なので、対応する箇所を「ENGINE=InnoDB」に書き換える

2
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
2
0