MySQL...

[RainMaQer]

Whats the best way to work with MySQL databases?

[XWRed1]

Hmm... this is another very vague and nebulous question.

Its like saying "whats the best way to work with a web server?"

[RainMaQer]

Sorry... I guess I want to know what the best program for creating, editing, working with MySQL in general would be. I'm kinda getting the hang of it... but It just takes SO long to do it in a dos prompt... I then found a program that lets me do this stuff in windows... but it's more confusing then MySQL itself :(

[VotTak]

Look at TOAD ... it might support it...

[XWRed1]

The best interface for me has always been a command line type interface - I've got a prompt, and I just run sql queries straight from there.

[Ploaf]

You could try phpMyAdmin (http://phpmyadmin.sourceforge.net/)

You should upload it to a password protected directory if you use it.

[ezlor]

I've always liked using mysqlgui (http://mysql.com/downloads/gui-mysqlgui.html) when I'm on my win2k box.

Otherwise on linux I just use a homegrown perl command line script.

[brodo]

i am partial to php myself. it depends what you are using the db for though. web? desktop apps? client/server/db (3-tier?)

[RainMaQer]

Originally posted by brodo
i am partial to php myself. it depends what you are using the db for though. web? desktop apps? client/server/db (3-tier?)

This database will hold the submissions for the 3dmark2k1 team. I'm still working on my system... but as soon as I'm done (hopefully before next week) the site will be back up. And I'll take off where I left it.

Thanks for the help so far guys... good links guys... thank you. Keep em coming if you know more :D

[brodo]

well as far as links go, you might already know about this one, but www.programmingtutorials.com can be of some assistance either as reference or guide when you get stuck with an unknown api or function set.

brodo