difference between terminology

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
djcrisp
Forum Newbie
Posts: 6
Joined: Mon Dec 01, 2008 6:25 pm

difference between terminology

Post by djcrisp »

what is the difference between a database, catalog, table, and record in MySQL???

any help is appreciated. can't seem to find out.

thanks in advance :-)
Cirdan
Forum Contributor
Posts: 144
Joined: Sat Nov 01, 2008 3:20 pm

Re: difference between terminology

Post by Cirdan »

A database is the main container, which holds the tables. Tables hold the actual data, and describe the columns, just like a spreadsheet.
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: difference between terminology

Post by requinix »

...and a catalog (of a database) keeps track of the stuff it contains, and a record is an entry in a table.

See also Wikipedia. Srsly. A Database has a Database catalog containing things like Tables, which in turn have Records.
Post Reply