Bug #4029 Agree with "Name Withheld"
Submitted: 6 Jun 2004 23:32 Modified: 16 Jun 2004 20:53
Reporter: Don Roark Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Websites: bugs.mysql.com Severity:S3 (Non-critical)
Version:4.0.18 OS:Linux (linux)
Assigned to: Paul DuBois CPU Architecture:Any

[6 Jun 2004 23:32] Don Roark
Description:
I agree with "Name Withheld" that the error codes should be explained. Also, examples of "correct syntax" should be given for each error.

How to repeat:
$mysql_query="CREATE TABLE MessageBoard (
name varchar(50),
email varchar(30),
message text)";
if (!$mysql_query) {
			echo "<br />$DBT was <b>NOT</b> created.";
		} else 
			{
			echo "<br />Success in <b>creating</b> table <b>$DBT</b>.";
		}

Suggested fix:
Is this the correct syntax?
[6 Jun 2004 23:34] Don Roark
no further comments...
[8 Jun 2004 0:39] Dean Ellis
If you are agreeing with some other bug report, you should add your comments to that.  Otherwise, I am not sure what bug you are actually reporting, here.
[15 Jun 2004 6:42] Paul DuBois
He's agreeing with some of the user comments in this
section of the manual:

http://dev.mysql.com/doc/mysql/en/Error-returns.html

The comments say that the error codes should be explained.
Actually, they are explained in the next section. I'm not sure
why there are two separate section. I'm assigning this to
myself. I'll discuss it with the other members of the docs team
to see about improving this part of the manual by combining
the sections.

However, one thing that won't happen is that the error chapter
in the manual won't give examples of correct syntax. The place
to look for the correct syntax for a particular statement is
in the SQL chapter, in the section that describes that statement's
syntax.
[16 Jun 2004 20:53] Paul DuBois
Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

The messages corresponding to the codes now are listed
with the codes.

http://dev.mysql.com/doc/mysql/en/Error-handling.html