Re: How to omit adding foreign key

[norio oikawa]

Thank you Mr. Kojima,

Sorry, but which one?

I tried all the exporting options but it still shows CONSTRAINT line with foreign key.

here is all the options I checked:
Generate DROP Statements Before Each CREATE Statement
Omit Schema Qualifier in Object Names
Generate Separate CREATE INDEX Statements
Add SHOW WARNINGS After Every DDL Statement
Do Not Create Users. Only Export Privileges
Generate INSERT Statements for Tables


I don't see any options to disable foreign keys from above..

And as a result, my ddl is below:

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';



CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;

SHOW WARNINGS;

USE `mydb`;



-- -----------------------------------------------------

-- Table `mydb`.`a`

-- -----------------------------------------------------

DROP TABLE IF EXISTS `mydb`.`a` ;



SHOW WARNINGS;

CREATE TABLE IF NOT EXISTS `a` (

`a_id` INT NOT NULL AUTO_INCREMENT ,

PRIMARY KEY (`a_id`) )

ENGINE = InnoDB;



SHOW WARNINGS;



-- -----------------------------------------------------

-- Table `mydb`.`b`

-- -----------------------------------------------------

DROP TABLE IF EXISTS `mydb`.`b` ;



SHOW WARNINGS;

CREATE TABLE IF NOT EXISTS `b` (

`b_id` INT NOT NULL AUTO_INCREMENT ,

`a_id` INT NOT NULL ,

PRIMARY KEY (`b_id`) ,

CONSTRAINT ``

FOREIGN KEY (`a_id` )

REFERENCES `a` (`a_id` )

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;



SHOW WARNINGS;

CREATE INDEX ON `b` (`a_id` ASC) ;



SHOW WARNINGS;





SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Could you explain me more detail please?