Description:
ALTER TABLE `school`.`sc`,
CHANGE COLUMN `sno` `sno` CHAR(10) NULL DEFAULT '',
CHANGE COLUMN `cno` `cno` CHAR(6) NULL DEFAULT '',
CHANGE COLUMN `grade` `grade` TINYINT(3) unsigned NULL,
ADD COLUMN `FKstudentsno` NULL AFTER `grade`,
ADD CONSTRAINT `FKstudent` FOREIGN KEY (`FKstudentsno`)
REFERENCES `school`.`student` (`sno`)
ON DELETE NO ACTION
ON UPDATE NO ACTION;
ALTER TABLE `school`.`student`,
CHANGE COLUMN `sno` `sno` CHAR(10) NULL DEFAULT '',
CHANGE COLUMN `sname` `sname` VARCHAR(45) NULL DEFAULT '',
CHANGE COLUMN `sex` `sex` TINYINT(1) NULL,
CHANGE COLUMN `sage` `sage` TINYINT(3) unsigned NULL,
ADD COLUMN `FKcoursecno` NULL AFTER `sage`,
ADD CONSTRAINT `FKcourse` FOREIGN KEY (`FKcoursecno`)
REFERENCES `school`.`course` (`cno`)
ON DELETE NO ACTION
ON UPDATE NO ACTION;
CREATE TABLE `school`.`course` (
`cno` CHAR(6) CHARACTER SET COLLATE UNSIGNED UNSIGNED NULL,
PRIMARY KEY (`cno`)
)
ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;
errors in Finalize reverse engineering:
file source\myx_grt_value.c: line 3307: assertion `dict != NULL' failed
file source\myx_grt_value.c: line 3307: assertion `dict != NULL' failed
file source\myx_grt_value.c: line 3307: assertion `dict != NULL' failed
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
CHANGE COLUMN `sno` `sno` CHAR(10) NULL DEFAULT '',
CHANGE COLUMN `cno` `' at line 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
CHANGE COLUMN `sno` `sno` CHAR(10) NULL DEFAULT '',
CHANGE COLUMN `sname` ' at line 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE UNSIGNED UNSIGNED NULL,
PRIMARY KEY (`cno`)
)
ENGINE = InnoDB
CHA' at line 2
How to repeat:
create tables in workbench, when do database synchronisation, above error occurs.
