Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 161 - 2620_Birla Open Mind C-8
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 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) 159

| 156 157 158 159 160 161 162 163 164 165 166 |