MySQL and mSQL

Errata for MySQL and mSQL

Submit your own errata for this product.


The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
Printed
Page Index
Many index entries were incorrect. The corrected index can be

found at http://www.ora.com/catalog/9781565924345/inx.html.

Anonymous    Sep 01, 1999
Printed
Page 8

Did read: In other words, SQL exposed Minerva to a much wider audience that PostQUEL, which was limited to Postgres. It now reads: In other words, SQL exposed Minerva to a much wider audience than PostQUEL, which was limited to Postgres.

Anonymous    Mar 01, 2000
Printed
Page 25
In Figure 2-12, the Record Label entity, looked like this

+--------------------+ | Record Label | +--------------------+ | Record Label ID | | --------------- | | Record Label Name | | Address | | City | | State Name | | State Abbreviation | | Zip | +--------------------+ It now looks like this +--------------------+ | Record Label | +--------------------+ | Record Label ID | | --------------- | | Record Label Name | | Address | | City | | Zip | +--------------------+

Anonymous    Sep 01, 1999
Printed
Page 37

Used read: http://www.hughes.com.avl Now reads: http://www.Hughes.com.au

Anonymous    Jan 01, 2000
Printed
Page 51
In Table 4-1

Insert_riv now reads: Insert_priv

Anonymous    Sep 01, 1999
Printed
Page 54
In Table 4-2

Insert_riv now reads: Insert_priv

Anonymous    Sep 01, 1999
Printed
Page 55
In Table 4-3

Insert_riv now reads: Insert_priv

Anonymous    Sep 01, 1999
Printed
Page 59
In the first paragraph after the 'Third Party Tools' heading

Linux Torvalds now reads: Linus Torvalds

Anonymous    Sep 01, 1999
Printed
Page 61

Second paragraph used to read: Inrpise Now reads: Inprise

Anonymous    Jan 01, 2000
Printed
Page 118
The last sentence of the third paragraph did read:

Free Postgres has continued on and ranks up their in popularity with MySQL and mSQL for mid-range database servers. It now reads: Free Postgres has continued on and ranks up there in popularity with MySQL and mSQL for mid-range database servers.

Anonymous    Mar 01, 2000
Printed
Page 162
In the code after the line $dbh = DBI->connect (´DBI:mysql:teach´)

The add action istself ... function, add, prints, ... test. Now reads: $dbh = DBI->connect (´DBI:mysql:teach´); # The add action istself ... # function, add, prints, ... # test.

Anonymous    Jan 01, 2000
Printed
Page 196
In the code,

$query = "select * from sharks where "; if ($species or $age or $location) { $query .= "where "; Now reads: $query = "select * from sharks"; if ($species or $age or $location) { $query .= " where ";

Anonymous    Jan 01, 2000
Printed
Page 234

VARCHAR(100) should read: VARCHAR(200) (colophon) George Reese has taken an unusual path into business software development. After earning a B.A. in philosophy from Bates College in Lewiston, Maine, George went off to Hollywood where he worked on television shows such as The People's Court and ESPN's Up Close. The L.A. riots convinced him to return to Maine where he finally became involved with software development and the Internet. George has since specialized in the development of Internet-oriented Java enterprise systems. He is the author of <I>Database Programming with JDBC and Java</I> and the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently lives in Minneapolis, Minnesota with his wife Monique and three cats, Misty, Gypsy, and Tia. He makes his living as a senior architect for Imaginet, LLC.

Anonymous   
Printed
Page 241
The second line of the note, the word "fild" now reads "field"

Anonymous    Jan 01, 2000
Printed
Page 254

Under "value1 LIKE value2," the sentence that did read: The is probably the single most used comparison in SQL. now reads: This is probably the single most used comparison in SQL.

Anonymous    Mar 01, 2000
Printed
Page 375
Changed

http://www.perl.com/CPAN/authors/id/TIMB/DBI/DBI-106.tar.gz to: http://www.perl.com/CPAN/modules/by-authors/Tim_Bunce/

Anonymous    Jan 01, 2000
Printed
Page 388

read: my @tables = $db->func->('_ListTables'); it now reads: my @tables = $db->func('_ListTables');

Anonymous    Sep 01, 1999
Printed
Page 412

read: my $output = $db->query('SLECT * from mydata'); it now reads: my $output = $db->query('SELECT * from mydata');

Anonymous    Sep 01, 1999