Page 146 - Code_GPT_Class_8
P. 146

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


              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.








                        CodeGPT (Ver. 4.0)-VIII
                144
   141   142   143   144   145   146   147   148   149   150   151