STRUCTURE MYSQL

Hi… welcome in My site in “We Are Knowledge”….

We was enter in area database. And now about MYSQL… Ok, you must read it… Let’s check it

STRUCTURE MYSQL

MYSQL is programming language who has structure data. Same likely programming language cobol, it having structure data. So This programming language more easily understood.

DATA TYPE OF STRING

Char, of length 255

Varchar, of length 255

Mediumtext, of length 1 miliion

Longtext, of length 4 Billion

Tinytext,  of length 255

Text, of length unlimited

DATA TYPE OF NUMERIC

Int, -2 M until 4 M

Tinyin, -128 until 255

Mediumint, -8 milion until 8 miliion

Bigint, -92 trillion until 92 trillion

Float, decimal positif number and real number.

Double, decimal positif number and decimal negatif number

DATA TYPE OF DATE AND TIME

Date, Only to fill of date. And format like This : Year – Mont - date

Time, Only to fill of time. And format like This :  HH : MM : SS

HH for Hour

MM for Minute

SS for Second

Datetime, And This statement for loading date and time. And format like This : Year – Mont – date HH : MM : SS

TYPE OF KEY

Primary key, The key for connect one table with other table. And You must using the “primary key” if you not using, exactly you want fail in making table in MYSQL. You must using it, and you only using one in record.

AUTO INCREMENT

Auto Increment is command for increase automatically. For easlly, if you input one record, 

it want have 1. And if you add one record again it want have 2. This increase automatically. Without you input of “auto increment”. Many people using this for “primary key”. Because in primary key should not be same each record.

Ok.. just it.. I hope you understand with my article… Because this only introduction abut structure of mysql….

Thanks visitors… And the readers….