search

anyongjin / mysql_ibd

import data from ibd files for mysql
MIT License
28 stars 5 forks source link

quotes when creating sql using tosql #21

Closed demirciberkan closed 8 hours ago

demirciberkan commented 9 hours ago

Here is an example produced by the tosql arg.

DROP TABLE IF EXISTS account_sessions; CREATE TABLE account_sessions ( session_id varchar(255) NOT NULL, account_id int unsigned NOT NULL, login_time timestamp NOT NULL DEFAULT 'CURRENT_TIMESTAMP', PRIMARY KEY (session_id) ) ENGINE=InnoDB;

CURRENT_TIMESTAMP should not be quoted as string here

anyongjin commented 9 hours ago

Thanks for the feedback, it should has been resolved. Please pull the latest code and try again. If you encounter any issues and know how to solve them, you are also welcome to submit a pull request directly

demirciberkan commented 8 hours ago

Thank you so much