Page 161 - TP_iPlus_V2.1_Class7
P. 161

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


                  i +  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

                  i +  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;


                  i +  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),



                                                                            Explore More (Introduction to MySQL)  159
   156   157   158   159   160   161   162   163   164   165   166