At 07:15 PM 6/21/2006, Karl Larsen wrote:
I have the subject book and I want to learn SQL from this book. Alas
the bookbiz.sql file on the cd-rom was last updated in 1996 :-) 10
years ago. I tried to load it on my version 4 mysql and it would not get
far at all. It appears that the software has changed since 1996.
I did the testing and found first dates were now yyyy-mo-day and in
1996 it was mo/day/yy and so I had to change all those. Under all the
INSERT INTO titles VALUE entries the use of '' was not complete. And the
sentenses were too long.
It took about 6 hours to correct the file but it's done. It loads with
just a couple of warnings on my version 4.1.10.
73 Karl
Karl,
That's a good book, and converting those scripts was quite a job. You would
do a lot of people a favour if you could post the MySQL compliant version.
Please keep in mind the provided SQL was for Sybase SQLAnywhere (Ver 6?)
and data conventions are still not standard, and in this case I believe
it's MySQL, with its European roots, that goes against the grain.
Another great book is SQL for Smarties by Joe Celko. A number of his
articles and exercises can be found on the web -- v. instructional.
Cheers and have fun - Miles
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.9.1/369 - Release Date: 6/19/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
