Page 143 - TP_Play_V2.2_Class8
P. 143

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 double-precision 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 value

                 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’.
                 Some commonly used operators in SQL are:

                    Arithmetic Operators: +, –, *, /, %
                    Relational Operators: =,  !=, <>, <, >, <=, >=
                    Logical Operators: ALL, AND, ANY, BETWEEN, NOT, OR, LIKE, IN, EXISTS


                 CREATE DATABASE

                 A database is an organized collection of structured data, typically stored electronically in a computer
                 system.
                 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),



                                                                                    #Info Hub (Introduction to MySQL) 141
   138   139   140   141   142   143   144   145   146   147   148