A database is a structured collection of records or data stored in a computer system and organized in such a way that it can be quickly searched and information can be rapidly retrieved.
The SQL in MySQL stands for Structured Query Language. This language is loosely based on English and also used in other databases such as Oracle and Microsoft SQL Server. It is designed to allow simple requests from a database via commands such as
A MySQL database contains one or more tables, each of which contains records or rows. Within these rows are various columns or fields that contain the data itself. An example database of five students detailing the author, title, type, and year of publication.
Each row in the table is the same as a row in a MySQL table, and each element within a row is the same as a MySQL field.
To uniquely identify this database, I’ll refer to it as the publications database in the examples that follow. And, as you will have observed, all these students are considered to be classics of literature, so I’ll call the table within the database that holds the details classics.
The SQL in MySQL stands for Structured Query Language. This language is loosely based on English and also used in other databases such as Oracle and Microsoft SQL Server. It is designed to allow simple requests from a database via commands such as
SELECT title FROM students WHERE author = 'Chan Dara';
Each row in the table is the same as a row in a MySQL table, and each element within a row is the same as a MySQL field.
To uniquely identify this database, I’ll refer to it as the publications database in the examples that follow. And, as you will have observed, all these students are considered to be classics of literature, so I’ll call the table within the database that holds the details classics.
0 comments:
Post a Comment