LLLLLLL Posted August 22, 2012 Share Posted August 22, 2012 Getting error 1064 on this. I don't really understand why: update ds set ds.status = 99 from status ds join orders_products op on ds.order_prod_id = op.id join orders o on op.order_id = o.id and o.guid = 'someGUID' Trying to update fields in the "status" table when I know the GUID of an order. Relationship: ORDERS table ORDERS_PRODUCTS table (fk to ORDERS) STATUS table (fk to ORDERS_PRODUCTS) What am I missing? Link to comment Share on other sites More sharing options...
Jessica Posted August 22, 2012 Share Posted August 22, 2012 what was the error? Link to comment Share on other sites More sharing options...
LLLLLLL Posted August 22, 2012 Author Share Posted August 22, 2012 1064. Anyway, the solution is: update status as ds join orders_products op on ds.order_prod_id = op.id join orders o on op.order_id = o.id and o.guid = 'someGUID' set ds.status = 99 Link to comment Share on other sites More sharing options...
Jessica Posted August 22, 2012 Share Posted August 22, 2012 That's an error number, not an error. If you refuse to let people help you don't be surprised when you don't get help. The errors usually contain all you need to figure out the problem. Link to comment Share on other sites More sharing options...
LLLLLLL Posted August 22, 2012 Author Share Posted August 22, 2012 I already provided the answer. Don't be surprised that I don't need help when I've already provided the solution. Please calm down. Link to comment Share on other sites More sharing options...
Jessica Posted August 22, 2012 Share Posted August 22, 2012 OP decided to PM me this: "mysql error numbers are always followed by the same message. Just google it." Look, you come here asking for us to help you. The error messages contain things like LINE NUMBERS which will depend on your actual code. It also tells you what part of the code is failing. The error number is USELESS, the actual error contains specific information. Furthermore, you want ME to google something in order to help YOU? That's not how it works. If you want help, you give all the info you can. Like I said. " If you refuse to let people help you don't be surprised when you don't get help." This time you figured it out. Good for you. Next time, don't be surprised when no one wants to help you. Link to comment Share on other sites More sharing options...
LLLLLLL Posted August 22, 2012 Author Share Posted August 22, 2012 I ALREADY PROVIDED THE SOLUTION. If you want to show me up, that's fine. I'm not following this post. Congrats on your arrogance. Please calm down. Link to comment Share on other sites More sharing options...
Jessica Posted August 22, 2012 Share Posted August 22, 2012 You can repeat it all you want, but you're missing the point. 1. I'll go ahead and let you know - I am calm. You are adding a tone to my posts that simply doesn't exist. Telling me to calm down multiple times makes it look like you are kind of freaking out however. 2. Yes, you found your solution. What you're missing out on is how to ask for help. You seem to think that saying "google the error number" is an appropriate way to ask for help. It's not. As I pointed out, the error number does not contain any actual information about your specific problem. Before you say it again - yes, I *know* that you solved this problem. When you run into another MySQL error, you should try to remember that the actual error message contains that specific information which will help people debug your problem. It would have been easy to let you know that the syntax was wrong - but the error message already does that. Part of what people do on this board is help people learn how to debug their own code, so they can learn and grow. PS: calm down. Link to comment Share on other sites More sharing options...
Philip Posted August 22, 2012 Share Posted August 22, 2012 Locking this before it gets more out of hand... Link to comment Share on other sites More sharing options...
Recommended Posts