Search This Blog

Thursday, 29 September 2011

Basics of Tables in MYSQL


A relational database system contains one or more objects called tables. The data or information for the database are stored in these tables. Tables are uniquely identified by their names and are comprised of columns and rows. Columns contain the column name, data type, and any other attributes for the column. Rows contain the records or data for the columns.

Example:Suppose you want to store the details of your company employees.
Generally Employees will have name, employee id,address.these properties we will represent them as columns.And the data of each employee will be as one Row.