My Blog

Category: My SQL

  • MySQL ALTER TABLE

    —

    by

    admin
    in

    ALTER TABLE The ALTER TABLE command is used  to change the structure of an existing table. It helps to add or delete columns, create or destroy indexes, change the type of existing columns, rename columns or the table itself. It  can also be used to change the comment for the table and type of the…

  • MySQL CREATE INDEX

    —

    by

    admin
    in

    CREATE INDEX In MySQL, an index can be created on a table when the table is created with CREATE TABLE command. Otherwise, CREATE INDEX enables to add indexes to existing tables. A multiple-column index can be created using multiple columns. The indexes are formed by concatenating the values of the given columns. CREATE INDEX cannot…

  • MySQL CONSTRAINT

    —

    by

    admin
    in

    CONSTRAINT MySQL CONSTRAINT is used to define rules to allow or restrict what values can be stored in columns. The purpose of inducing constraints is to enforce the integrity of a database. MySQL CONSTRAINTS are used to limit the type of data that can be inserted into a table. MySQL CONSTRAINTS can be classified into…

  • MySQL Create Database

    —

    by

    admin
    in

    What is a database? When an amount of data is stored in an organized way, that is called a database.In computers, a database is managed by a software called Database Management System. What is a table? A table is a set of data values. These values are organized using vertical columns and horizontal rows. Columns…

  • MySQL Connection

    —

    by

    admin
    in

    Connecting to MySQL Before you perform any operations, you need to connect to MySQL server and select a MySQL database. Connecting to MySQL server from command line Command:MySQL -h HostName -u UserName -p Parameters: Name Description -h Keyword, followed by HOSTNAME. HostName MySQL server name -u Keyword, followed by USERNAME. UserName MySQL user name -p…

  • MySQL Create Database

    —

    by

    admin
    in

    What is a database? When an amount of data is stored in an organized way, that is called a database.In computers, a database is managed by a software called Database Management System. What is a table? A table is a set of data values. These values are organized using vertical columns and horizontal rows. Columns…

  • MySQL Create Database

    —

    by

    admin
    in

    What is a database? When an amount of data is stored in an organized way, that is called a database.In computers, a database is managed by a software called Database Management System. What is a table? A table is a set of data values. These values are organized using vertical columns and horizontal rows. Columns…

  • MySQL Connection

    —

    by

    admin
    in

    Connecting to MySQL Before you perform any operations, you need to connect to MySQL server and select a MySQL database. Connecting to MySQL server from command line Command:MySQL -h HostName -u UserName -p Parameters: Name Description -h Keyword, followed by HOSTNAME. HostName MySQL server name -u Keyword, followed by USERNAME. UserName MySQL user name -p…

  • MySQL Data Types

    —

    by

    admin
    in

    What is data type 1. A data type specifies a particular type of data, such as integer, floating-point, Boolean etc. 2. A data type also specifies the possible values for that type, the operations that can be performed on that type and the way the values of that type are stored. MySQL data types MySQL…

  • MySQL Language Structure

    —

    by

    admin
    in

    Language Structure This page discusses the syntactical and structural rules for writing the following elements of MySQL statements. Content: Literal values (string, numbers etc.) The terms literal refer to a fixed data value. MySQL evaluates seven types of literal values numeric, character string, date and time, hexadecimal, boolean, bit-field, and NULL Values Numeric Literals Numeric…