issues Search Results · repo:ww9/mysql2sqlite language:HTML
Filter by
8 results
(82 ms)8 results
inww9/mysql2sqlite (press backspace or delete to remove)mysql ddl CREATE TABLE muse_model_sync_record ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 主键 , gmt_create
datetime NOT NULL COMMENT 创建时间 , gmt_modified datetime NOT NULL COMMENT 修改时间 , source_url ...
sir1st
- 1
- Opened on Nov 14, 2024
- #9
Your tool is very good, but I think to make it even more complete, it could have the option to save the file directly.
I have some little troubles in my convertion, like maintain the create schema if ...
enhancement
ghost
- 1
- Opened on Oct 21, 2023
- #7
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 ...
enhancement
andyg2
- 2
- Opened on Apr 4, 2022
- #6
MySQL dump file has LOCK and UNLOCK TABLES in between inserting values to table.
Result from converter does not remove this and when executing the file it causes error.
bug
emaccheese
- 1
- Opened on Feb 4, 2022
- #5
row with a timestamp from MySQL dump file, : dateCreated timestamp NULL DEFAULT current_timestamp(),
These cause syntax errors when trying to read the sqlite result. I believe correct way should be Timestamp ...
bug
emaccheese
- 1
- Opened on Feb 4, 2022
- #4
If a field name includes the word Number , it gets converted to the wrong field name.
-- MySQL
DROP TABLE IF EXISTS `employees`;
CREATE TABLE `employees` (
`employeeNumber` int(11) NOT NULL,
`lastName` ...
bug
crysanthus
- 1
- Opened on Jul 19, 2021
- #3
CURRENT_TIMESTAMP() is not converted:
date_created timestamp NOT NULL DEFAULT current_timestamp(),
Found this in Stackoverflow: (datetime( now , localtime ))
https://stackoverflow.com/questions/381371/sqlite-current-timestamp-is-in-gmt-not-the-timezone-of-the-machine ...
bug
timint
- 1
- Opened on May 1, 2021
- #2
A problem with AUTO INCREMENT:
This
CREATE TABLE IF NOT EXISTS `table_name` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
...
PRIMARY KEY (`id`)
);
Should become
CREATE TABLE IF NOT EXISTS ...
bug
timint
- 1
- Opened on May 1, 2021
- #1

Learn how you can use GitHub Issues to plan and track your work.
Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub IssuesProTip!
Press the /
key to activate the search input again and adjust your query.
Learn how you can use GitHub Issues to plan and track your work.
Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub IssuesProTip!
Restrict your search to the title by using the in:title qualifier.