importing data into sql phpadmin
sorry if this is considered a noob question, but i have only just started to learn about sql and php.
I am using phpmyadmin on a remote server to import a sql file which will make some table and import some information.
so far I have the following to make the tables
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_ccsubgroup` varchar(100) default '',
`est_ccsecret` varchar(100) default '',
PRIMARY KEY (`est_ccorder`)
) TYPE=MyISAM;
so I have 2 questions.
- can i get it to check if the fields exist and create them if they dont ?
- Can someone show me the code to include information in the fields, the original information is in an access database, but i export to txt csv etc.
Thanks.