开发者

"Invalid Default Value" mssql to MySql migration tool

hi i got "Invalid Default Value for "BarcodeAppID" " when convervting a MsSQL database to MySQL, im new to both so im wondering what MySQL Isn't Supporting syntax wise ? Thanks

DROP TABLE IF EXISTS `InfoCentre_dbo`.`BrowserBarcodes`;
CREATE TABLE `InfoCentre_dbo`.`BrowserBarcodes` (
  `BarcodeAppID` INT(1开发者_如何学JAVA0) NOT NULL DEFAULT null,
  `BrowserAppID` INT(10) NOT NULL DEFAULT null,
  `BarcodeReaderPort` INT(10) NOT NULL,
  `SilverLightServerListeningPort` INT(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`BarcodeAppID`)
)
ENGINE = INNODB;


Try using

 DEFAULT 0

instead of DEFAULT null.


Well, you try to create a field that can't be NULL and you try to set it as NULL :/ ! You have to change your default value or authorized the field to be NULL.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜