› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
coderabbit
V2EX  ›  MySQL

mac workbench 同步数据库结构注释问题!

  •  
  •   coderabbit · Sep 6, 2018 · 3424 views
    This topic created in 2949 days ago, the information mentioned may be changed or developed.

    操作到 detected changes 的时候出来地堆 sql 语句 sql 语句的注释全是种注释 comment /xxxx/ 正常应该是 comment 'xxxx'

    CHANGE COLUMN `again_compulsory_insurance` `again_compulsory_insurance` TINYINT(1) NULL DEFAULT '0' COMMENT  /* comment truncated */ /*再次投保*/ AFTER `c_insured_expiration_date`,
    CHANGE COLUMN `status` `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT  /* comment truncated */ /*状态:-1 移除,0 正常,1 到期,2 异常 (弃用)*/ AFTER `mr_next_time`,
    CHANGE COLUMN `operation_time` `operation_time` INT(10) NOT NULL DEFAULT '0' COMMENT  /* comment truncated */ /*操作时间,如:投保,退保操作时间。*/ AFTER `rs_id`,
    CHANGE COLUMN `insured_status` `insured_status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT  /* comment truncated */ /*投保状态:0 待算价 1 待提交 2 待审核 3 待出单 4 已投保 5 已退保 6 商险审核*/ ,
    

    然后我得手工改成 '' 这样来同步,我之前使用 windows 就没有这个问题.有谁知道什么原因吗?

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   1019 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 23ms · UTC 17:28 · PVG 01:28 · LAX 10:28 · JFK 13:28
    ♥ Do have faith in what you're doing.