Blog Archives


  • Many To Many Search in Table

    Many To Many Search in Table

    User Table Userid Username 1 Name1 2 Name2 3 Name3 Subscription Table SubId SubName 1 Subname1 2 Subname2 User_Subscription Table Userid SubId 1 1 1 2 2 2 3 1 Many To Many Search […]


  • MySQL Introduction and Features

    MySQL Introduction and Features

    What is MySQL MySql RDBMS MySql Open Source MySql Limits MySql Connectivity Languages MySql License MySql Features And Versions What is MySQL? A database is a structured collection of data. It may be text, […]


  • MYSQL Numeric Data Types

    MYSQL Numeric Data Types

    This tutorial will help you to understand about “MYSQL Numeric Data Types”. Storage Required For Numeic Types Integer Types Storage Required For Numeic Types Data Type Storage Required TINY INT 1 byte SMALL INT […]


  • MYSQL Date And Time Types

    MYSQL Date And Time Types

    This tutorial will help you to understand about “MYSQL Date and Time Data Types”. Storage Required For Date And Time Types YEAR Type TIME Type DATE, DATETIME AND TIMESTAMP Type Storage Requirements for Date […]


  • MYSQL String Data Types

    MYSQL String Data Types

    This tutorial will help you to understand about “MYSQL String Types”. It contains the storage required for string types, CHAR type, VARCHAR type, TEXT types, BLOB types, ENUM type and SET TYPE. Storage Required […]


  • MYSQL Server Connection

    MYSQL Server Connection

    MYSQL Connection To Server MYSQL Disconnect From Server MYSQL Connection To Server Host, user and password parameters are needed to connect the mysql server. We have to connect server like this shell>mysql -h host […]


  • Create Mysql Database

    Create Mysql Database

    Now we will learn how to create database. Database names are case sensitive. so we must have to refer our database in lower case “databasename” not “DataBaseName” in linux. This case sensitive concept is […]


  • Creating A Table In MYSQL

    Creating A Table In MYSQL

    TITLE : CREATING MYSQL TABLE DESCRIPTION: This tutorial about mysql table. It contains the mysql table creation, alteration, deletion, description funcatioalities. KEYWORDS : 4mysql table, mysql create table, show table, table syntax, mysql alter […]


  • What is SQL?

    What is SQL?

    Introduction Data Definition Language (DDL) Data Manipulation Language (DML) Data Control Language (DCL) Data Query Language (DQL) Introduction SQL = sequel As a database developer, we need to manage the database to store, access […]