Page 1 of 1

Is it possible to change data in MySQL?

Posted: Mon Feb 18, 2008 9:26 am
by Rozzy85
I have a MySQL database running that contains lots of information on employees such as name, job title etc. I can add new employees to the database anytime but what if I want to edit information on an employee already entered into the database. For example, say if I wanted to change an employees name because it was spelt wrong. Is there a MySQL command that will let you change data in a certain field cell leaving the rest intact? I found there was a command called "UPDATE" but I think it just changed user privileges.

Re: Is it possible to change data in MySQL?

Posted: Mon Feb 18, 2008 9:53 am
by Rozzy85
It seems update was it, just that the example I found originally was vague. Guess this thread is useless now. :/