Need Serious Tutorial

[Z2nyc]

Help! I used to use MS Access for my company's database. Then the developer switched to MySQL saying it was industry standard and I'd be able to figure it out without a problem.

Well I logged in OK to SQLyog. I want to change the text that goes with one of the items we sell. But I don't know any codes, any commands, nothing! I thought it would be like a drag-and-drop situation or I would see where the text was residing and just type over it, etc.

Can anyone help? I'm computer savvy and with a brief tutorial using this problem as an example, I should be able to catch on quickly.

Please email me at [email protected] if you can help.

Thanks.

[CalEvans]

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=

[Ritesh]

I am not sure if I understood your problem. Can you explain a little more about what you want to achieve with MySQL and SQLyog?

Maybe a good place to start would be: MySQL ABs website.

[Author]

Posts