MySQL Forums
Forum List  »  Newbie

Re: Membership Directory
Posted by: Russell Dyer
Date: July 09, 2005 05:12PM

I started with MS Access development before getting into MySQL. While Access is GUI driven, I found MySQL to be easier and more straightforward. A skilled MySQL developer could set up a basic database with a web interface in just a few days. If you really want to do this and learn it, and if you work diligently at it, you could probably come up with something functional and clean looking by August 1.

MySQL AB now provides some GUI interfaces like the MySQL Query Browser and MySQL Administrator which might help you create your database and tables quickly. They recently released MySQL Migration Toolkit that you can use to migrate your Access data to MySQL. All three of these products are free and can be found on this web page: http://www.mysql.com/products/ You can also migrate your data using various methods and SQL statements in MySQL designed for this.

As for learning MySQL quickly, you could get a copy of "MySQL Tutorial" (MySQL Press). It's an easy read for someone with Access background. http://www.pearsonptg.com/book_detail/0,2461,0672325845,00.html

As for using developing a web interface, you can use PHP (which is very popular), Perl (which I prefer), Java, C, C++, Visual Basic, or Python. There are many books and articles written on interfacing MySQL with one of these API languages.

We can't tell you exactly what to do in this one posting. However, you can take some of these ideas here and start plodding ahead and ask questions on this forum as you go along and get confused or when just looking for advice or explanations of concepts.

The first step would be to go to MySQL's site and download a copy of MySQL and install it on your home computer or server. Get a "standard" version 4.1 for your operating system: http://dev.mysql.com/downloads/mysql/4.1.html After you install it and get it running, log on with the mysql client and try to create a database and tables within it. Then insert some data and retrieve the data in various ways. Don't be afraid to ask simple questions here at any point. Just do a separate posting for each situation.

Good luck and have fun, and welcome to the MySQL community.

Russell Dyer

Author of "MySQL in a Nutshell" (O'Reilly 2005).

Options: ReplyQuote


Subject
Written By
Posted
July 09, 2005 04:48PM
Re: Membership Directory
July 09, 2005 05:12PM
July 09, 2005 05:47PM
July 09, 2005 06:00PM
July 09, 2005 06:47PM


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.