What is a Database Table?
Overview
A Relational Database Management System( RDBMS) organizes and stores information in the form to tables. The Relational model and store information about real world things in a database table.
Database Table
A table is an ordered collection of one or more columns and an unordered collection of zero or more
rows. Each column in the table has a name and a data type. Each table row has exactly one value
for each column. The values in the table are atomic. A particular row and a particular
column can contain only one piece of data.
MySQL Server can manage multiples databases or schemas. Each database can have multiple database tables.
For example, the database tables in MySQL world database can be listed using the following command:
mysql> SHOW TABLES;
Table Structure
To know the table structure i.e number of columns, column data types, table constraints, etc.
mysql> DESCRIBE City;
+————-+———-+——+—–+———+—————-+
| Field | Type | Null | Key | Default | Extra |
+————-+———-+——+—–+———+—————-+
| ID | int | NO | PRI | NULL | auto_increment |
| Name | char(35) | NO | | | |
| CountryCode | char(3) | NO | MUL | | |
| District | char(20) | NO | | | |
| Population | int | NO | | 0 | |
+————-+———-+——+—–+———+—————-+
5 rows in set (0.05 sec)
—
MySQL Tutorials
MySQL Tutorials on this website:
https://www.testingdocs.com/mysql-tutorials-for-beginners/
For more information on MySQL Database: