Page 1 of 1

difference between terminology

Posted: Tue Dec 02, 2008 12:15 am
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 :-)

Re: difference between terminology

Posted: Tue Dec 02, 2008 12:42 am
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.

Re: difference between terminology

Posted: Tue Dec 02, 2008 1:13 am
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.