Home » Database

Database

                                                                                        DATABASE 

Database Introduction 

1.Introduction

2.Installation

3.How to Enter into the database

4.create the database and show the databases present in the mysql

5.Create the tables in the database by using particular database

6.Insert the values into the tables

7.Update the values in the tables

8.Delete the values in the tables

9.Using the Select command

10.Select Distinct command 10.Dropping the table (Deleting the table)

11.Dropping the database(Deleting the database)

12.Using the Where ,orderby command plus AND &OR operator

ADVANCED COMMANDS

1.Setting the constraints into the table

  •      NOT NULL
  •      UNIQUE
  •      PRIMARY KEY
  •      FOREIGN KEY
  •      CHECK
  •      DEFAULT

2.Using the Join in the SQL query

  • LEFT JOIN
  • RIGHT JOIN
  • FULL  JOIN
  • INNER JOIN
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: