Hi.. welcome to my blog at “We Are Knowledge”.. In here you
will getting many IT knowledge… You will take it.. let’s do read my article…
Now.. I want giving you tutorial about “MYSQL”. And discuss
about “database design”.. and This tutorial for you : :
Table type in MYSQL
Field type in MYSQL
Designing the correct database
Ok.. direct to go !!!
1. Table Type In MYSQL
On MYSQL applications we can define the type for each table,
there are several major data types contained in MYSQL, namely :
A. MyISAM
the type of this table is a type of simple, and easy to use.
Study table is pretty easy, so if you have data that you want to keep better
use of this, there are three types of MyISAM tables:
i. MyISAM static
>> if you use it, the table has a definite size
ii. MyISAM dymanic
>> as the name suggests, this type of table is
suitable for the size of the dynamic column
iii. MyISAM compressed
>> to compress MyISAM static and MyISAM dymanic
B. InnoDB
>> For this table type to support the transaction
C. HEAP
>> Table of contents for this type of data can be
stored on your computer's hard disk, but the data stored in RAM (memory)
2. Field type in MYSQL
On mysql there are many types of data that we can use. Maybe
this is one of the advantages or disadvantages of MYSQL ... If we enter a
different data type then do not enter data. And this
Field type in MYSQL ::
A. TINYINT B. SMALLINT
C. MEDIUMINT D. INT
E. BIGINT F. FLOAT
G. DOUBLE H. REAL
I. DECIMAL J. NUMERIC
3. Designing the correct database
To design a good database, we need to know what data type
should we use, how long (size) data type, because the longer the size of the
data type is the greater amount of memory that we use. In the table we make we
must give "primary key" for the lock so that no record of the same.
Ok.. Just it from me..
I hope you understand…
See you later
No comments:
Post a Comment