music.sql with FK from Learning MySQL -- 1005 error?

2010-03-22 Thread Mitchell Maltenfort
I've been mucking with the O'Reilly book Learning MySQL for the obvious purpose of learning MySQL. The book offers two versions of a program: http://learningmysql.com/Downloads/Files/Data/SQL_files_with_foreign_key_references/music.sql sticks at creating the track table. However, its sibling

Re: music.sql with FK from Learning MySQL -- 1005 error?

2010-03-22 Thread Mitchell Maltenfort
. From: mmal...@gmail.com Date: Mon, 22 Mar 2010 18:00:27 -0400 Subject: music.sql with FK from Learning MySQL -- 1005 error? To: wi...@lists.mysql.com; mysql@lists.mysql.com I've been mucking with the O'Reilly book Learning MySQL for the obvious purpose of learning MySQL. The book offers two

Re: learning mysql

2009-03-25 Thread George Larson
I'm quite a distance from the best person to answer this question but MySQL has weekly webinars and there are a ton of good tutorials on the web. I started with WAMP (LAMP, MAMP and XAMP are suitable alternatives) and just started reading tutorials. Then I went to the local discount store and

Re: learning mysql

2009-03-25 Thread Olaf Stein
If you know in theory what you want to do then I recommend the certification study guide http://www.mysql.com/certification/studyguides/ olaf On 3/24/09 9:00 PM, solarflow99 solarflo...@gmail.com wrote: hi, I'm looking for some advice where to learn mysql. Not being a DBA, I have basic

Re: Re: learning mysql

2009-03-25 Thread claudio . nanni
Hi, I think in your case you should go for a traditional book approach to build a good background. In my opinion finding the right book is a matter of match between the kind of book and your background. My hint is to gather here 4/5 good book titles, go in a book shop take a while to run

Re: Re: learning mysql

2009-03-25 Thread Haidong Ji
I second Claudio's recommendation on Paul DuBois MySQL 4th edition. I've followed his book and enjoyed it. Depending on your background, especially if you work predominately in Windows, I think you will need to have easy access to a *nix machine, either a physical one or virtual machines,

learning mysql

2009-03-24 Thread solarflow99
hi, I'm looking for some advice where to learn mysql. Not being a DBA, I have basic knowledge of databases, and have administered them in the past. The docs on the mysql site aren't very good for this, just a few examples of commands, etc. Ideally, something that is suited for system

Re: looking for a good book for learning mysql

2007-08-03 Thread Richard
It's original title is core PHP programming Third Etition By Leon Atkinson It's in French (I bought it in a shop that did not sell english books) and although the translation isn't always excelent its not bad at all ! Robert Conner a écrit : What is the PHP book? Is it in English? Thanks,

looking for a good book for learning mysql

2007-08-02 Thread Richard
Hello, I've got a good book for learning php, very complete and goes through almost everything. However I'm now looking for a good mysql book. I don't want ebooks, only paper versions. I know how to connect and the real basics of mysql (I can connect, do a basic search, insert data etc ...

Re: looking for a good book for learning mysql

2007-08-02 Thread sol beach
MYSQL Third Edition by Paul DuBios (a frequent list contributor) On 8/2/07, Richard [EMAIL PROTECTED] wrote: Hello, I've got a good book for learning php, very complete and goes through almost everything. However I'm now looking for a good mysql book. I don't want ebooks, only paper versions.

Re: looking for a good book for learning mysql

2007-08-02 Thread Richard
Thank's I have already seen this book, says it's well transladed, but as I am also fluent in French and don't like translations ( I've had a few problemes with English books badly translated to French) I tried to find it in it's original language but could not. However if you say it's good in

Re: looking for a good book for learning mysql

2007-08-02 Thread Paul DuBois
At 3:31 PM -0700 8/2/07, sol beach wrote: MYSQL Third Edition by Paul DuBios (a frequent list contributor) I think that's slightly misspelled. Perhaps you meant dubious? :-) On 8/2/07, Richard [EMAIL PROTECTED] wrote: Hello, I've got a good book for learning php, very complete and goes

Best Method for Learning mysql

2004-01-05 Thread Marc Dver
Based on the collective experiences of the members of this group, what are the best methods for learning mysql, both from the perspective of certification and of learning enough to excel in the production environment? My interests include both the specifics of mysql and the general concepts

Re: Best Method for Learning mysql

2004-01-05 Thread Tobias Asplund
On Mon, 5 Jan 2004, Marc Dver wrote: Based on the collective experiences of the members of this group, what are the best methods for learning mysql, both from the perspective of certification and of learning enough to excel in the production environment? My interests include both

Re: Best Method for Learning mysql

2004-01-05 Thread Chuck Gadd
Marc Dver wrote: Based on the collective experiences of the members of this group, what are the best methods for learning mysql, both from the perspective of I attended the week-long Mysql training course, and it was excellent. -- MySQL General Mailing List For list archives: http