MySQL recommendations for newbie

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hairyjim
Forum Contributor
Posts: 219
Joined: Wed Nov 13, 2002 9:04 am
Location: Warwickshire, UK

MySQL recommendations for newbie

Post by hairyjim »

Hi guys,

I have just downloaded mysql-3.23.55- for my NT box. I just wanted to know if there are any other things which are needed / recommended.

I have already installed PHP with no hassle whatsoever :D

I have noticed some GUIs which are available.

Cheers
Jim
User avatar
redcircle
Forum Commoner
Posts: 43
Joined: Fri Jan 31, 2003 8:47 pm
Location: michigan, usa

Post by redcircle »

phpMyAdmin is a must. http://phpmyadmin.net
hairyjim
Forum Contributor
Posts: 219
Joined: Wed Nov 13, 2002 9:04 am
Location: Warwickshire, UK

Post by hairyjim »

Whats the diff between the .php and .php3 download?

Is one an 'old' version?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

If you've got the latest version of PHP then you want to download the php version not the php3 version.

Mac
User avatar
dstefani
Forum Contributor
Posts: 140
Joined: Sat Jan 11, 2003 9:34 am
Location: Meridian Idaho, USA

Post by dstefani »

The MySQL book by Dubois. Mine stays on my desk at all times.
Also, the Php windows help file version of the manual.

As far as GUI's go, I agree, the phpMyAdmin is a must, but the MySQL control center from the MySQL site is really good as well.

Have fun!

Don
hairyjim
Forum Contributor
Posts: 219
Joined: Wed Nov 13, 2002 9:04 am
Location: Warwickshire, UK

Thx

Post by hairyjim »

Cheers chaps.

Most helpful.

Jim
User avatar
topher
Forum Newbie
Posts: 6
Joined: Sun Feb 09, 2003 2:02 pm
Location: Bakersfield, CA

Post by topher »

hey, im new to the entire php/mysql thing. i was just intrigued by what php could do, so ive been looking into it, tapping into any resources i could and i found a lot of great resources on php.net, phpdeveloper, evil walrus, etc. but ive also been looking into the entire database idea, but honestly, i have close to no clue about how to even use MySQL. i asked my friend, who hosts me, what client i should use to start off with, but he said he doesnt support external access to mysql. he told me that i could use notepad to make tables and input the data, but im honestly lost when it comes to all that, and i have no clue as to where to start off in. if anyone has any suggestions it would be much appreciated.

cheers.
User avatar
daven
Forum Contributor
Posts: 332
Joined: Tue Dec 17, 2002 1:29 pm
Location: Gaithersburg, MD
Contact:

Post by daven »

Check out http://www.mysql.com for info on MySQL.

If you do not know any SQL, read the MySQL manual for how to construct queries. It is quite useful.

I think what your friend means by using notepad to create tables is that he wants you to manually code your SQL, rather than use a client like phpMyAdmin (ie, write queries and then implement them).
User avatar
topher
Forum Newbie
Posts: 6
Joined: Sun Feb 09, 2003 2:02 pm
Location: Bakersfield, CA

Post by topher »

Thanks. I think I looked through it about a week ago, the manual, but being the thick skulled kid that I am, nothing really penetrated, but maybe since I understand a small bit more now, I can get something from it. I'll definitley check it out. As for writing out the tables in notepad, do you know of any tutorials that show that, do you think my best bet is to just roll with it, and see what I can figure out using something like phpmyadmin, just to kind of see how things work?

Thanks again, cheers.
User avatar
daven
Forum Contributor
Posts: 332
Joined: Tue Dec 17, 2002 1:29 pm
Location: Gaithersburg, MD
Contact:

Post by daven »

Depending upon your level of beginner-ness (yes, I know that is not a real word :) ), check out things like http://sqlcourse.com/ and http://www.firstsql.com/tutor.htm. Hunt around on google for "SQL query tutorial" or similar things and play around on the sites. Or just be silly and buy yourself a Big Book of SQL (ie--one of the really huge programming books).

And if you have any trouble writing queries, don't be shy about asking for help on the forum.
User avatar
topher
Forum Newbie
Posts: 6
Joined: Sun Feb 09, 2003 2:02 pm
Location: Bakersfield, CA

Post by topher »

awesome. thanks a lot, i really appreciate the help. ill be sure to save the links.

cheers.
fractalvibes
Forum Contributor
Posts: 335
Joined: Thu Sep 26, 2002 6:14 pm
Location: Waco, Texas

Post by fractalvibes »

Another good start would be:
PHP and MySQL Web Development by Luke Welling and Laura Thompson,
SAMS publishing. Some good info to introduce you to the database and using it via PHP.

Phil J.
User avatar
topher
Forum Newbie
Posts: 6
Joined: Sun Feb 09, 2003 2:02 pm
Location: Bakersfield, CA

Post by topher »

i think ill definitley buy a book on this for reference, perhaps that one once i find, or order, it. im going through mysqlcourse.com right now, im definitley loving it, it really breaks it down. i just hope to find something on how to implement it and use php in conjunction with it, that is this well written. thanks to all though for the help, its greatly appreciated.

cheers.
Post Reply