Thread: importing data into sql with phpadmin

I am trying to import some data into a sql database.

I am using the following sql to make the table

eg the following script will make a new table.

Code:

CREATE TABLE IF NOT EXISTS `est_costcenters` (
  `est_ccorder` int(11) NOT NULL auto_increment,
  `est_cccode` varchar(100) NOT NULL default '',
  `est_ccname` varchar(100) default '',
  `est_ccgl` varchar(100) default '',
  `est_ccgroup` varchar(100) default '',
  `est_ccsecret` varchar(100) default '',
  PRIMARY KEY  (`est_ccorder`)
) TYPE=MyISAM;

but not sure how to fill it with required info. (of which there is a a lot)

Code:

"ccorder"	"cccode"	"ccname"	"ccgl"	"ccgroup"	"ccsecret"
1	1000	preliminaries	1.1	prelims	1
2	2000	site survey	1.1	prelims	1
3	3000	drafting		1.1	prelims	1
20	20000	excavation	1.1	slab stage	1
50	50000	roofing		1.1	enclosed	1

got an answer on another forum.
thanks for the responses here.

Code:

INSERT 
  INTO est_costcenters
     ( ccorder
     , cccode
     , ccname
     , ccgl
     , ccgroup
     , ccsecret )
VALUES
 (  1 ,  1000 , 'preliminaries' , '1.1' , 'prelims'    , 1 )
,(  2 ,  2000 , 'site survey'   , '1.1' , 'prelims'    , 1 )
,(  3 ,  3000 , 'drafting'      , '1.1' , 'prelims'    , 1 )
,( 20 , 20000 , 'excavation'    , '1.1' , 'slab stage' , 1 )
,( 50 , 50000 , 'roofing'       , '1.1' , 'enclosed'   , 1 )