CBSE Book Class 11 Informatics Practices MySQL

MySQL

Ms. Sujata is a Class teacher of Class XI. She wants to store data of her students i.e. Names and marks secured, in a database. A database is used to house data in the form of tables. She uses a CREATE DATABASE statement to create a new database named School.

mysql> CREATE DATABASE School;

Once the above mentioned statement gets executed, a database with the name School is created on her system. Now she has to open the database to work on it. For this USE statement is required. She opens the School database:

mysql> USE School;

Database Changed

Creating a table

After creating a database, the next step is creation of tables in the database. For this CREATE TABLE statement is used.

Syntax:

CREATE TABLE <TableName>(<ColumnName1> <Data Type1>,

<ColumnName2> <Data Type2>,… ,<ColumnNameN> <Data TypeN>);

Since Ms. Sujata is just learning, she initially creates a simple table named Learner with only two columns RollNo and Name in the School database.

Some Terminologies

Keyword: A keyword refers to a special word that has a special meaning to SQL. For example, SELECT and FROM are keywords.

Clause : A clause is a portion of an SQL statement. Each clause is identified by a keyword.

For example, consider the statement

SELECT name FROM Learner;

Here SELECT name is a clause. SELECT is a statement as well as a clause. SELECT clause is everything from keyword SELECT until keyword FROM. SELECT statement is the entire command.

FROM Learner is a FROM clause, which specifies the table from which data has to be selected.

Statement : A statement is a combination of two or more clauses. For example,

SELECT name FROM Learner; is a statement. 

Please refer to the link below - CBSE Class 11 Informatics Practices MySQL