Helpful Information
 
 
Category: Development Articles
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)

Good article, very informative for the newbie (Me)

Database Essentials (http://www.devshed.com/c/a/Administration/Database-Essentials) I'm fairly new to the development side of databases, and hunting arounf for a good one...I came across mySQL a day or two back, and started scouring the web for more info...this little tutorial reminded me of a few questions I had when I was JUST starting out, and that reminder was enough to make some connections. Thanks.
You can read the article here (http://www.devshed.com/c/a/Administration/Database-Essentials).

This is the best article I have read on this topic so far. Obviously, it's not in-depth, but it really gives a good overview about the concept of databases.
Advanced techniques are explained very well, so that even though you may not really understand the scope of them, you can easily make further investigations.

Thanks!

What does it take as far as being a "database administator"? What courses and how do you break into the field. Example, what exactly do they do? How much do they get paid etc. Any information regarding this career would be greatly appreciatiated.

Hi all, i'm making an advertisepage with MySql, i want that the person who places it can add an image, how can i add images from the person's pc to my MySql database?
Hope that anyone can help me....
Regards....J.D










privacy (GDPR)