My first database

importing databases

[AvenueComputers]

I am new to database programing and this is my first project. I have a client who needs a secure database driven website. I am about to begin to learn mysql. Can I import msacess and excel files into mysql? and is it difficult? also any advice on learning mysql is greatly appreciated.

Thanks,
Gerard Ramos

[ukgimp]

AC

There are literally hundreds of online tutorials out there or buy a book that goes through the basics, again there are loads.

Here is one tutorial that looks ok:
ht*tp://www.freewebmasterhelp.com/tutorials/phpmysql/

Access runs slightly differently (referential integrity etc) So some of the features you get in access wont work in the same way in mySQL.

With a program called phpmyadmin it will be possible to export your files to a comma delimited format and then import them into mysql once yo have the database setup.

HTH a little

[jatar_k]

As far as your specific question goes, both excel and access can output comma delimited files and then those can be loaded inot mysql using either the LOAD DATA INFILE [mysql.com] command or by having a script read the file and then insert it into the db.

For learning, the mysql.com [mysql.com] site has a tutorial introduction to mysql [mysql.com]. I would also suggest purchasing a book about db design and structure from a generic approach.

[AvenueComputers]

Thanks,

I've downloaded some tutorials and am going to by a book. Any opinons on the MySQL refrence manual offered at mysql.com?

-Gerard

[jatar_k]

I looked at the 3 they recommend and am not familiar with them but I would say they should be good if mysql.com recommends them.

Just be careful that you get something that starts from a beginner level and isn't too much too fast.