While Core PHP was my first book and the one that most people know, I also wrote a book in 2001 on MySQL called Core MySQL. It didn’t sell very well, probably because Paul Dubois already had a good book on the market about MySQL. Core PHP owed a good portion of its success to being first (well, Egon Schmidt’s book in German came out a couple weeks before mine, but the English-reading market is a lot bigger.)
Still, I am proud of Core MySQL because I had a better handle on the principles of organizing a book after doing two editions of Core PHP by that time. And I had to think through more things for that book because MySQL is more than just the SQL language. I liked learning relational database theory deeper than I did when I was in college and then figuring out how to explain it.
My contracts with Prentice Hall include a clause that returns the rights to the text to me if they cease publishing them. It’s taken a year for them to work through the process. Recently I got a letter confirmed that the rights are now returned to me. That will allow me to release the text under some sort of open license. Hopefully my spin on thing will help someone learn MySQL and relational databases.
Stay tuned for details and send me suggestions for licenses. I haven’t researched the options yet.
One reply on “Core MySQL Going Open”
Regarding Core MySQL,
I used the book as a key reference in a short
course I did in 2004 and recently as an added
reference for an SQL course I am just finishing.
I thought it was a solid and good book on MySQL.
It only needs to get up to date with the latest version
which is at 1.5.0.x.
I don’t know what the implications of having Sun
buy MySQL but I would think that Prentice or Sun
would be happy to publish a new and updated
version of your book to go with the new audiences
that MySQL will have.
PS I am at your site tracking down your samples
which I would like to reference for a final talk
on MySQL clients, C, Java, PHP etc..