"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.
精彩评论