Errata

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