Read before posting in this forum: questions about tables and data
You're much more likely to get useful help if your post lets your readers copy and paste your SQL directly into a MySQL client. So please post a small, representative dataset as:
(1) the results of SHOW CREATE TABLE for all tables involved in the problem
(2) enough INSERT statements for each table so a reader can 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.
Finally, please make your title descriptive--titles like "please help" aren't useful to readers.
(Originally posted by Peter Brawley)
Subject
Views
Written By
Posted
Read before posting in this forum: questions about tables and data
8130
November 04, 2011 07:14AM
1626
November 05, 2011 06:36PM
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.