• PHP Training
    •  
  • Login/Register

    • Home >>MySQL Tutorial

    MySQL Tutorial

    « Previous Next »

    MySQL Introduction

    In this Mysql tutorial you will learn how to build connection of Database. There are a large number of database management systems currently available, some commercial and some free. Mysql tutorial Some of them : Oracle, Microsoft Access, Mysql and PostgreSQL. These database systems are powerful, feature-rich software, capable of organizing and searching millions of records at very high speeds.

    Understanding Databases, Records, and Primary Keys

    Every Database is composed of one or more tables. These Tables, which structure data into rows and columns, Impose organization on the data. The records in a table(below) are not arranged in any particular order. To make it easy to identify a specific record,therefore, it becomes necessary

    BookId BookName Price($)
    1 The Shining 250
    2 Shutter Island 300
    3 The Overlook 180
    4 Safe Harbour 200
    5 Trunk Music 300

    to add a unique identifying attribute to each record, such as a serial number or sequence code. In the preceding example, each record is identified by a unique "record ID" field; this field is referred to as the Primary key for the table.

    Understanding Relationships and Foreign Keys (RDBMS)

    You already know that a single database can hold multiple tables. In a Relational database management system(RDBMS), these tables can be linked to each other by one or more common fields, called foreign keys. These foreign keys make it possible to create one-to-one or one-to-many relationships between different tables, and combine data from multiple tables.

    GenreId GenreName
    1 Horror
    2 Crime
    3 Romance
    AuthorID AuthorName
    1 Stephen King
    2 Danielle Steele
    3 Dennies Lehane
    4 Michael Connelly
    5 Nora Roberts
       
    BookId BookName GenerID AuthorID
    1 The Shining 1 1
    2 Shutter Island 2 3
    3 The Overlook 1 1
    4 Safe Harbour 1 4
    5 Trunk Music 3 2
    6 Sisters 3 2
    7 Blodd Broters 1 4
    8 Pet Sematary 3 5

    What is Database administrator(DBA) ?

    Database administrator is the super user of database, he has unrestricted rights and privileges to access database, grant permission to other database users.

    What is Database user(DBU) ?

    Database user is the person who uses the database in a restricted privileges, provided by database administrator.

    Download MySQL Database

    If you have installed PHP's WAMP or XAMPP server, then mysql database already exists. if you don't have then download mysql database from here Mysql

    MySQL Tutorial Index

    Sr.No. Topics
    1 SQL Introduction
    2 MySQL Constraints
    3 MySQL Common Queries
    4 PHP MySQL Connectivity
    5 PHP Mysqli Database Connectivity
    6 PHP MySQL Create Database
    7 PHP Create MySQLi Database
    8 PHP MySQL Insert
    9 PHP MySQL Update
    10 PHP MySQL Delete
    11 PHP MySQL Select
    12 Mysqli Fetch Array
    13 Mysqli Fetch Assoc
    14 Mysqli fetch row
    15 Mysqli fetch object
    16 MySQL Where Clause
    17 MySQL Order By
    18 Select Insert Update Delete in Php
    19 How to create foreign key
    20 MySQL auto increment
    21 PHP MySQL Secure Registration Page
    22 PHP MySQL Secure Login Page
    23 MySQL Predefined Function
    24 MySQL Joins
    25 How to Export MySQL to CSV
    26 How to import csv into mysql
    27 How to edit radio button in PHP MySQL
    28 PHP MySQL Pagination
    29 Upload and Display Video in PHP
    30 Building a bar chart
    31 How to update Radio button, Checkbox and dropdown
    32 Create Registration form PHP MySQL
    33 How to insert data from textarea to database PHP
    34 PHP PDO
    « Previous Next »

    MySQL Tutorial SQL Introduction MySQL Constraints MySQL Common Queries PHP MySQL Connectivity PHP Mysqli Database Connectivity PHP MySQL Create Database PHP Create MySQLi Database PHP MySQL Insert PHP MySQL Update PHP MySQL Delete PHP MySQL Select Mysqli Fetch Array Mysqli Fetch Assoc Mysqli fetch row Mysqli fetch object MySQL Where Clause MySQL Order By Select Insert Update Delete in Php How to create foreign key MySQL auto increment PHP MySQL Secure Registration Page PHP MySQL Secure Login Page MySQL Predefined Function MySQL Joins How to Export MySQL to CSV How to import csv into mysql How to edit radio button in PHP MySQL PHP MySQL Pagination Upload and Display Video in PHP Building a bar chart How to update Radio button, Checkbox and dropdown Create Registration form PHP MySQL How to insert data from textarea to database PHP PHP PDO
    No Sidebar ads