Page 139 - Plus V4 with Adobe class 8
P. 139

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.








                                                                                #Info Hub (Introduction to MySQL) 137
   134   135   136   137   138   139   140   141   142   143   144