Page 152 - iPro_trackGPT_V5_Class7
P. 152
Some of the data types in SQL are listed below:
Data Type Description
CHAR Specifies a fixed length string
VARCHAR Specifies a variable length string
INT or INTEGER Specifies an integer number
FLOAT Specifies a floating-point number
DOUBLE Specifies a normal-size floating point number
DATE Specifies a date value in YYYY-MM-DD format
TIME Specifies a time value in HH:MM:SS format
BOOL or BOOLEAN Specifies a Boolean valute
SQL OPERATORS
SQL statements consist of reserved symbols or characters used to perform arithmetical operations,
comparisons, etc. These reserved words or characters are called as ‘Operators’.
The three types of operators in SQL are:
✶ Arithmetic Operators: +, –, *, /, %
✶ Relational Operators: =, !=, <>, <, >, <=, >=
✶ Logical Operators: ALL, AND, ANY, BETWEEN, NOT, OR, LIKE, IN, EXISTS
CREATING A DATABASE
The CREATE DATABASE command is used to create a database in MySQL. The syntax to create
a database is:
CREATE DATABASE database_name;
For example,
CREATE DATABASE School;
After creating a database, you need to access the database by using the USE command in the
following way:
USE School;
CREATING A TABLE
As you know that a table is a collection of organised data in the form of rows and columns. It
is also known as a relation. The CREATE TABLE command is used to create a table in SQL. The
syntax to create a table is:
CREATE TABLE table_name
(
column_name1 data_type (size),
column_name2 data_type (size),
column_name3 data_type (size),
.....
.....
150 TrackGPT iPRO (V5.0)-VII

