Database Essentials

great article, simple, beginner oriented
thanks a lot
you really made my day

hassan

I have to agree. Very good tutorial.

<p><pre><font color=#008000><xmp> whats there </xmp></font></pre><p>

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...

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.)



Thanks!

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.

Very good article for people who are completly new to databases.

I really enjoyed it, & I want to keep it

It was very Succinct and well written for the novice to intermediate. Good Job.

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!!!!

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.

This is pretty good and clear - thanks

Okay, if you say so - I'll give it a try...
Good luck to you too.
Stefan

This is an extremely well written summary of the basic concepts/terms of databases. Well done !!!!

Good article, very informative for the newbie (Me)