Sign in to follow this  
graveyard filla

how to set up a MySQL server ?

Recommended Posts

hi, i've been searching the forums and reading through some threads, but i still can't find any explanation of this.. google only turns up info on MySQL with web page related stuff.. anyway, does anyone know how to set up a MySQL server? i really just don't know where to begin or how it works exactly. do i need something like Apache ? how does it work? i've used Oracle and PL/SQL in the past, but the server was already set up (run by my school) and we just used the (crappy) SQL+ command line. thanks for any help.

Share this post


Link to post
Share on other sites
You don't need apache installed to set up a mysql server. The docs that come with the software are very thorough, and have an entire selection on beginning the server, setting it to run as a service etc.

I would really recommend reading them.

Share this post


Link to post
Share on other sites
I was thinking of moving this thread, as it's not networking or multiplayer related, but there's not a good forum. I guess if your server is Linux, you could move to Everything UNIX, but you're not saying.

Perhaps we should be the Networking, Multiplayer and Databases forum? (I can see the VB WinForms questions come flooding in already -- forget I suggested that :-)

Share this post


Link to post
Share on other sites
hi,

sorry for putting it in the wrong forum. thanks for the replies everyone. i downloaded the package and got a server and DB set up.

anyway, i have a MySQL question. im used to Oracle with sequences, and i know MySQL has an AUTO_INCREMENT thing. anyway, i have one of my fields labeled with AUTO_INCREMENT.. my question is, what do i put in the insert statement for this field? i tried leaving it blank, but i get an error about leaving the field blank..

thanks for any help.

Share this post


Link to post
Share on other sites
You should be able to do something like

INSERT INTO tableName (columName1, columnName2) VALUES ( value1, value2 );

( assuming the auto_increment field is not columnName1 or 2! )

That should then automatically update the field that is auto_increment.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this