What could it mean if I get the following:
Query OK, 1 row affected, 1 warning (0.00 sec)
I couldn't imagine it to mean that it has to do with there being a syntax error, since it's returning "Query OK." Yet, it seems contradictory, if at the same time it giving the "warning." What does mySQL interpret to be a "warning." And, it's weird, because it's returning this, and I didn't write the statements in question. I could see where if it was something that I personally wrote, it'd have errors in it, since I'm a newbie at SQL. But, it's SQL file that was premade, and I'm just running it.
Should I care that it gave me several of these "warnings?" Or, is it something I can just ignore, since it says "Query OK?" Plus, when I do" SHOW_TABLES; ...it shows that my tables were, in fact created. Weird.
since you're using mysql 4.1, after you've run a query that has warnings, you can issue a command: SHOW WARNINGS;
That will show you any warning generated in the previous query.
Oh, awesome. thanks. I sure wish I had a book on mySQL 4.1. The two books I have about SQL, actually present the information as if you were using Oracle. Having a mySQL book would be very beneficial, instead of trying to determine every time, if something will work in mySQL, or if it's an Oracle thing.
well, all you really need is the searchable docs: http://www.mysql.com/doc/en/index.html