SYNTAX MYSQL

Hi.. welcome in my site... let's read it...

In mysql to be found many syntax. This syntax very avail. This sytax too can using for making website, and other application website. 

I want giving you about the syntax. This syntax for making database in MYSQL and in form “table”. And with syntax we can editing database like as : add, remove, update fill the database or editing the database automatically.

Not much syntax in mysql, and this syntax :

• Create
• Show
• Use
• Drop
• Alter
• Select
• Insert
• Update
• Delete

Ok… now we learn syntax in MYSQL

CREATE

This syntax for making database in form table. This database having RDBMS system, RDBMS is database system to fill information in form tables interrelated. So if you will making database you must using this syntax.

Syntax : create namedatabase;

And if was making database you can making table.

Syntax :

Create table (field1 (size), field2 (size), …)

USE

This for using database. You must using this for enter to your database. If you not using this you can’t making the table or others do.

Syntax :

Use namedatabase;

DROP this syntax for deleting database or table in MYSQL.

This for deleting database

Syntax:

Drop database;

This for delering table

Syntax

Drop nametable;

ALTER

This syntax for modification table was we made. And we can modification like :  add field, change size, deleting field, and change name of field.

Thisfor change size from field in  table

Syntax :

Alter table wak change name name_wak varchar(39)

So, change name of fieldwith size 39.

SELECT

the syntax for show fill from table. We can choice what may appear ?. like just name, id or both is appear.

Syntax :
select * from name_table;

If you will only “name” and “id”  to appear

Select * from name_table where field = name, id

INSERT

The syntax for to fill record in table.

Syntax

Insert into name_table (field1, field2, field3, …) values (value1, value2, value3, …)

UPDATE

Thesyntax for updating record. Example you have a record and you will change name or id, you can use it.

Syntax :

Update name_table set field = new_value where field = criteria

DELETE

For use deleting just record in table.

Syntax :

Delete from nametable where field = criteria;

Ok just it the sytax in MYSQL. I hope you understanding with this all.

Thanks vor reader and visitors

See you leter.