Java & MySQL

Newbie & Debugging Questions
#1

Hi all,

It has been a good while since i posted on here and got to work on my game while I got my degree out of the way. Anyway im happy to be back and pick up right where i left off!

I am working on a text based-ish rpg and have begun using phpAdmin to create my database which i quite like for its visual ease.

I have followed the steps on this youtube video which helped me attain a basic connection and data retrieval.
http://www.youtube.com/watch?v=E30_-pQGQXs

What I am now looking for is basic commands to ammend the database search etc.
I will only be using this for player info, login, monsters, items etc so will only need to know the basic commands to get me by. What i am finding when i search seems overtly complex.

If someone could direct me to a where i can read such basic commands I would be very greatful.

Thanks!

#2

You just have to learn SQL (Structured Query Language). This site came up on Google. Good luck! :slight_smile:

#3

Phmyadmin shows the generated sql, so you can get started by trying out stuff in there and copy the sql. It also links to the mysql reference documentation, so you can lookup stuff you dont understand right away.

#4

Thanks for the links guys!

I found this one myself and it has proven to provide the most plain English examples I have seen.
http://www.developer.com/java/data/jdbc-and-mysql-discussion-and-sample-code-for-jdbc-programs.html

I may have to add my own code examples to this post when I am done as they can still be somewhat hazy.