suggest a book or url on SQL/mySQL
 

can you suggest a book or url on SQL/mySQL? (mySQL is already on my system, so it appears i'll be using that engine.)

also, should i use PHP or Perl to run my mySQL databases? (optimization of CPU and memory is the key here.)

a sample opinon of PHP vs. Perl:


"A Digression About PHP vs. Perl

I am recommending that you use PHP for your first project. It is a much more accessible, though less powerful, language than Perl. Sure, in the end you?ll probably need some Perl skills and to cut some Perl code but get your feet wet with PHP first.

There are also some great portal style products written in PHP that you can use as a base for your own site, but more on that later."

http://www.amazon.com/exec/obidos/tg...de.heading.003


if PHP = less powerful, then i'm going with Perl. (i only have experience in Perl as of yet.)

mysql = www.mysql.com

php = www.php.net

about as good as as it gets.

If you really need a book I fould recomend " New Riders mySQL by Paul Dubais" I thing that was his name. I have it here somwhere it's the best book on the subject in my opinion. :2 cents:

that's the exact book i was looking at:

http://www.amazon.com/exec/obidos/AS...479689-9985409

"SQL clearly explained", Jan L. Harrington, Morgan Kaufmann Publishers.
Good start...

I have tons of links on my Webmaster Links page regarding this including easy tutorials... check it out...

http://superbooger.com/sponsors.html

It has links to MySQL info for sure...

thx for your input
i'll check out the suggestions.

haha, your only mysql link points to http://www.mysql.com/ ! :)

Another vote for MySQL by Paul DuBois, excellent book.

Also check out www.devshed.com .

PHP and MySQL Web Development
Luke Welling and Laura Thomson
SAMS Publishing

Excellent book with quite a few walk thru projects, but if you want to know about MySQL only, then www.mysql.com is a clear winner.

i want perl and mysql. and i already know perl. that's why i want to stay away from the php books, which seem to be more popular than the perl/mysql books.

devshed is down:

http://www.devshed.com/Server_Side/MySQL

http://www.devshed.com/

<B>Does ANYONE know what this error means?
and how to fix it?

A FATAL MYSQL ERROR HAS OCCURRED
================================
Error Message : Unknown column 'confd' in 'where clause'
Caller : main::SQLCount <- main::displayMain

I am working on a script right now and going freaking nuts!</B>