First,
SQLYog/MySQL are nothing like Access. Prepare yourself for the change. You won't be able to do most of the things you can do in Access…and that's on purpose.
Now, to change the text you want to change in the record you want you need 4 pieces of information. #1 the table name you want to change #2 the primary Key of the record you want to change, #3 the name of the primary key and the name of the field that holds the text you want to change.
Now, with that information you can craft a simple update statement to make the change.
It will look something like this:
UPDATE tableName set fieldToChange=”New Text” where primaryKeyName=primaryKeyValue;
That's all there is to it.
Pretty simple.
Or if you want a crutch, load the MySQL ODBC drivers and link to your MySQL table using Access. You will still get about 75% of the functionality you are used to.
(But if it were me, I'd toss that piece of crap and learn proper SQL syntax….but that's just me)
HTH,
=C=
