Popular Articles

India is home to great literature and two of the greatest epics originated from the sub-continent. They are the Ramayana and the Mahabharata. The Mahabharata
Gift buying is something most people just swear by. Of all things it counts up to make a gift count, it can become a nightmare for some to zero in on the
As per science, the universe was born with the Big Bang. Religions argue that everything was created by an almighty God. Amidst the scientific theories

Latest Articles

Gift buying is something most people just swear by. Of all things it counts up to make a gift count, it can become a nightmare for some to zero in on the
India is home to great literature and two of the greatest epics originated from the sub-continent. They are the Ramayana and the Mahabharata. The Mahabharata
As per science, the universe was born with the Big Bang. Religions argue that everything was created by an almighty God. Amidst the scientific theories

Mysql is a database its is a open source Database software i will give some Basic Syntax in Mysql

Use

Its used to initialized user , Use as keyword

Syntax

USE DatabaseName

Example

MYSQL>USE Name

MYSQL>DATABSE Changed

Create Database

To create a new Database use Following Syntax

Syntax

Create Database  DatabaseName

Example

MYSQL> Create Database Data1

List out Database

Find out what are databases in particular user rights

Syntax

Show Databases

Example

MYSQL>Show Databases

Data1

Describe Database

Its used describe all fields in particular table

Syntax

Describe Tablename

Example

MYSQL>Describe TblValue

ID Int(11)

Name Varchar(50)

Source or .Filename

Execute Sql Script File.

Example

MYSQL>Source.sql  or MYSQL>/.Source.sql

 

To set Privileges

To privileges to control every user rights for read ,write ,modify and delete in data Manipulation languages and Data Definition languages

Syntax

Grant all privileges on *.* to Username

Example

MYSQL> Grant all privileges on Data1 to Name

Set Password

To set password for a particular user

Syntax

Set password for Username=password(‘new password’);

Example

MYSQL>Set password for Name=password(‘ABCD’);

Show Table

To show  all table in particular database use this

Example

MYSQL>Show Tables

Tbl_Mt_Value

Tbl_Mt_Temp

  • No comments found