Skip navigation links

MySQL Forums :: Newbie :: using excel dummy data to populate Mysql database tables


Advanced Search

using excel dummy data to populate Mysql database tables
Posted by: Hilda Ochieng ()
Date: October 25, 2010 07:39AM

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;

Options: ReplyQuote


Subject Written By Posted
using excel dummy data to populate Mysql database tables Hilda Ochieng 10/25/2010 07:39AM
Re: using excel dummy data to populate Mysql database tables Phillip Ward 10/25/2010 07:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.