Results 1 to 4 of 4
Thread: NEW MYSQL user
Enjoy an ad free experience by logging in. Not a member yet? Register.
- Join Date
- May 2008
NEW MYSQL user
I am having difficulty working out how to do certain complex operations. Is it OK to do the following. You set up a SELECT which loops through records . But within the loop you place specific UPDATES.
Also if I wanted to update a specific record going by the actual record number... eg the simple sequential number. How would I refer to that in mysql.
Well there's a couple of things to get you started. First off, the language is SQL and MySQL is a product which uses this language. That should help when searching for resources on it. You should check out RDBMS principles in general before you attempt to learn the language. Some of the functions won't make any sense until you understand how tables relate, primary/foreign keys etc.
With regards to your question about selecting and then updating...it's best not to think of things in such a linear way. SQL is quite advanced and isn't your usual shopping-list basic scripting. Why select and the update? Why not use the where condition to specify what you want updated?Code:
update address_table set post_code = 'AA11AA' where line_4 like '%dublin%'
As I said above it's really a subject you should get a good feeling for and understanding of relational databases before jumping in. The hello_world of SQL doesn't even scratch the surface
I also prefer phpmyadmin for my interface to mysql.