Page 160 - iPrime_V2.2_class7
P. 160

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),
                      .....

                      .....


                 158     Touchpad iPRIME (Ver. 2.2)–VII
   155   156   157   158   159   160   161   162   163   164   165