Skip to content

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
Issue origami icon

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 Issues
ProTip! 
Press the
/
key to activate the search input again and adjust your query.
Issue origami icon

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 Issues
ProTip! 
Restrict your search to the title by using the in:title qualifier.
Issue search results · GitHub