February 27th, 2001, 03:08 AM
great article, simple, beginner oriented
thanks a lot
you really made my day
February 27th, 2001, 03:03 PM
I have to agree. Very good tutorial.
March 1st, 2001, 03:35 AM
I dont no
<p><pre><font color=#008000><xmp> whats there </xmp></font></pre><p>
March 1st, 2001, 09:55 AM
not a bad article at all... i've been using sql for two years but never had the occasion to use triggers or stored procedures so it was nice to see some code on those topics... it clariifed things for me... thanks...
March 1st, 2001, 12:13 PM
Thanks for a great article. I am just learning MySQL to develop a project I am working on. While reading the article, it helped me organize some thoughts specific to my project. (I wish MySQL supported subquiries.)
March 1st, 2001, 01:15 PM
Re: Good Information
mySQL may not directly support subqueries, but you can certainly use a variable to store the results of a query, then use that variable in another query.
At least, you can do it using ColdFusion. I assume that much the same thing can be done with ASP, Perl, or PHP.
A CF query returns a list, so you use the list functions to parse out the bits you want. It's a bit of a kludge, but it does work, at least for small databases. Not sure how well it would work in a large db, especially in a heavy transaction-processing setup where the tables might be updated in the time *between* sucessive queries.
March 2nd, 2001, 06:01 AM
Well written basic info
Very good article for people who are completly new to databases.
March 2nd, 2001, 03:44 PM
I really enjoyed it, & I want to keep it
March 4th, 2001, 02:43 PM
A Great Explanation
It was very Succinct and well written for the novice to intermediate. Good Job.
March 8th, 2001, 07:24 PM
....all after a bottle of good wine!
Sorry to be boring but this article was very, very well written - even after a bottle of good wine I find myself itching to start my project - - well done!!!!
March 13th, 2001, 12:18 PM
about the description of "foreign key"
I think the description of "foreign key" is somewhat incorrectly.
Foreign key exists in one-to-many relationships, and it is the key in table which is in the "many" side.
And, in a good database design, the tables in example of foreign key must be merged.
Sorry, I'm not good at English.
March 22nd, 2001, 09:22 AM
This is pretty good and clear - thanks
April 13th, 2001, 12:08 PM
Okay, if you say so - I'll give it a try...
Good luck to you too.
April 20th, 2001, 02:42 AM
This is an extremely well written summary of the basic concepts/terms of databases. Well done !!!!
April 27th, 2001, 11:44 PM
Good article, very informative for the newbie (Me)