Is it possible to change data in MySQL?
Posted: Mon Feb 18, 2008 9:26 am
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.