954,561 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Altering Specific Values/Columns

Hey guys,

I'm new to writing SQL and I need a bit of help.

What I'm trying to achieve is getting my Java application to successfully send the high score of a specific user to a database. I'm not sure how I would write the SQL code so it will see who the user is, and alter the high score column based on the username.

I have completed the registering process and checking to see if the user's credentials are valid.

Any help on this would be greatly appreciated!

Thanks.

FridgeFreezer
Newbie Poster
2 posts since Jan 2012
Reputation Points: 10
Solved Threads: 0
 

Look for an mysql primer which explains the uses of the INSERT, UPDATE and DELETE stamements to you. For specific help, post the relevant table structures you're using.

smantscheff
Nearly a Posting Virtuoso
1,233 posts since Oct 2010
Reputation Points: 300
Solved Threads: 254
 
Look for an mysql primer which explains the uses of the INSERT, UPDATE and DELETE stamements to you. For specific help, post the relevant table structures you're using.

Thank you very much, that's exactly what I needed! I just checked an example of the UPDATE query and I found my answer. I never thought about looking at the UPDATE function as I assumed I needed to use INSERT.

Thanks again, smantscheff.

FridgeFreezer
Newbie Poster
2 posts since Jan 2012
Reputation Points: 10
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You