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
   147   148   149   150   151   152   153   154   155   156   157