zaqi syah
2011-07-23 03:18:08 UTC
I try to create a database with the command below:
CREATE TABLE `dagang`.`kecamatan` (
`no_kecamatan` INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`prop_id` INT( 2 ) NOT NULL ,
`kab_no` VARCHAR( 2 ) NOT NULL ,
`kec_no` VARCHAR( 3 ) NOT NULL ,
`nama_kecamatan` VARCHAR( 50 ) NOT NULL ,
INDEX ( `kec_no` )
) ENGINE = INNODB;
CREATE TABLE `dagang`.`desa` (
`no_desa` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`prop_id` INT( 2 ) NOT NULL ,
`kab_no` VARCHAR( 2 ) NOT NULL ,
`kec_no` VARCHAR( 3 ) NOT NULL ,
`desa_no` VARCHAR( 3 ) NOT NULL ,
`desa_id` VARCHAR( 10 ) NOT NULL ,
`nama_desa` VARCHAR( 50 ) NOT NULL ,
INDEX ( `kec_no`)
) ENGINE = INNODB;
Then I add foreign key :
ALTER TABLE `desa` ADD FOREIGN KEY ( `kec_no` ) REFERENCES `umkm`.`kecamatan` (`kec_no`)
Error message & fails to add foreign key :
#1452 - Cannot add or update a child row: a foreign key constraint fails (`umkm`.<result 2 when explaining filename '#sql-bf4_10f'>, CONSTRAINT `#sql-bf4_10f_ibfk_1` FOREIGN KEY (`kec_no`) REFERENCES `kecamatan` (`kec_no`))
What causes the above error?
I've tried to fill the data first and then add the index & foreign keys but still error
Please Help me, thanks b4
CREATE TABLE `dagang`.`kecamatan` (
`no_kecamatan` INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`prop_id` INT( 2 ) NOT NULL ,
`kab_no` VARCHAR( 2 ) NOT NULL ,
`kec_no` VARCHAR( 3 ) NOT NULL ,
`nama_kecamatan` VARCHAR( 50 ) NOT NULL ,
INDEX ( `kec_no` )
) ENGINE = INNODB;
CREATE TABLE `dagang`.`desa` (
`no_desa` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`prop_id` INT( 2 ) NOT NULL ,
`kab_no` VARCHAR( 2 ) NOT NULL ,
`kec_no` VARCHAR( 3 ) NOT NULL ,
`desa_no` VARCHAR( 3 ) NOT NULL ,
`desa_id` VARCHAR( 10 ) NOT NULL ,
`nama_desa` VARCHAR( 50 ) NOT NULL ,
INDEX ( `kec_no`)
) ENGINE = INNODB;
Then I add foreign key :
ALTER TABLE `desa` ADD FOREIGN KEY ( `kec_no` ) REFERENCES `umkm`.`kecamatan` (`kec_no`)
Error message & fails to add foreign key :
#1452 - Cannot add or update a child row: a foreign key constraint fails (`umkm`.<result 2 when explaining filename '#sql-bf4_10f'>, CONSTRAINT `#sql-bf4_10f_ibfk_1` FOREIGN KEY (`kec_no`) REFERENCES `kecamatan` (`kec_no`))
What causes the above error?
I've tried to fill the data first and then add the index & foreign keys but still error
Please Help me, thanks b4