MySQL Forums
Forum List  »  MySQL Workbench

If your question concerns a query, please read this first.
Posted by: Peter Brawley
Date: April 07, 2014 02:47PM

If a reader can easily replicate your problem without a lot of head-scratching and typing, you're more likely to get useful help, so to save everybody's time, please post a small, representative dataset as:

(1) the results of SHOW CREATE TABLE for all tables involved in the query

(2) enough INSERT statements for each table to reproduce the problem

(3) if applicable, the desired query result for the dataset defined in #1 and #2

(4) the result of SELECT Version()

If you are posting a query or other code which you want us to read and understand, please format it for human readability and enclose it in BBCode code tags, ie [ code ] and [ /code ] without the spaces.

If the problem involves performance, include the results of running EXPLAIN EXTENDED on the query, also within BBCode code tags as above.

Finally, please make your title descriptive--titles like "please help" aren't useful to readers.

Options: ReplyQuote

Written By
If your question concerns a query, please read this first.
April 07, 2014 02:47PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.