I use Navicat for simple changes like that. You can use MySQL gui tools (free from MySQL site) or phpmyadmin. The console is not a really good way to do things when you are starting out, unless you want to do a LOT of trial and error and a LOT of reading.
I just open Navicat and click on the table, then click in the field for the modifier and type in what I want, then close Navicat. Easy stuff. After you make any changes, at the bottom of the program it shows you the query you would have used if you had typed it into the console, so it teaches you. If you want to use the console, you can also open a console from the Menu in Navicat and just type away with your commands. No more opening a cmd prompt and typeing Mysql -u etc...
|