using excel dummy data to populate Mysql database tables
Please help me with ideas how I can populate a database with dummy data in Excel. Let's say for instance I have the following table. How can I populate the table with use of dummy data in an excel file. Thanks in advance
DROP TABLE IF EXISTS `viterra`.`vertrag` ;
CREATE TABLE IF NOT EXISTS `viterra`.`vertrag` (
`vgultig_ab` DATETIME NOT NULL,
`vertragsnummer_intern` BIGINT(9) UNSIGNED NOT NULL ,
`aenderungsbenutzer` VARCHAR(16) NOT NULL,
`begindatum` DATETIME NULL ,
`deb_kre_kennzeichnen` VARCHAR(1) NULL ,
`einheitswert` BIGINT(255) UNSIGNED NULL ,
`endedatum` DATETIME NULL ,
`vertraginfo` VARCHAR(2000) NULL ,
`kreditorennummer` BIGINT(16) UNSIGNED NOT NULL ,
`kuendigunds_grund` VARCHAR(255) NULL ,
`kuendigungs_frist` BIGINT(6) UNSIGNED NULL ,
`laufzeit` BIGINT(6) UNSIGNED NULL ,
`is_sonderkuendigung` BOOLEAN NULL ,
`verlaengerungsoption` BIGINT(6) UNSIGNED NULL ,
`is_vertrag_aktiv` BOOLEAN NOT NULL ,
`vertragsart` VARCHAR(16) NULL ,
`extern_vertrag_nr` BIGINT(9) UNSIGNED NULL ,
`v_timestamp` DATETIME NULL ,
PRIMARY KEY (`vgultig_ab`,`vertragsnummer_intern`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;