mysql2sqlite icon indicating copy to clipboard operation
mysql2sqlite copied to clipboard

Alter table syntax into create table.

Open andyg2 opened this issue 3 years ago • 0 comments

I've used your excellent converter but I've hit a snag. My SQL dumps separate the keys assignments into separate ALTER TABLE queries.

Is there any way I can a) force my dumps to not do this, or b) is there a way to integrate them into the CREATE TABLE query, or c) are there plans to include this in the script?

Example ALTER TABLE grid_lines ADD PRIMARY KEY (lineID), ADD KEY cameraID (cameraID);

andyg2 avatar Apr 04 '22 18:04 andyg2