Tipu Dadus MySQL
MySQL nudar
aplikasaun baze dadus jeralmente iha ninia tipu hamtuk hat mak hanesan tuir mai
ne’e :
1.
Numeric
Data Type
Tipu dadus
numeriku (numeric data type) uja hodi
rai dadus numeriku (angka)
hanesan
10; 123 100.50; -10; 1.2E+17;2.7e-11 no seluk tan. Tipu dadus ne’e sei
fahe parte rua, integer
(bilangan bulat) no floating point
(bilangan pecahan).
Deskrisaun tipu dadus nuemeriku MySQL
tuir standarte ANSI SQL(American National Standards Institute Structure Query
Language), mak hanesan :Tinyint,
Smmalint, Mediumint, Int, Begint, Float, Double, Read, Decimal no Numeric.
2.
Date and
Time Data Type
Tipu dadus
ne’e hanesan rai dadus no oras. Tipu
data sempre iha
format
standarte ka default ho mekanismu hakerek hanesan “
tinan-fulan-data”,
exemplu loron 20 maiu 2015 hakerek hanesan “2015-05-20”. No
mekanisumu hakerek data ho format hanesan “oras-minutu-segundu”, ejemplu oras “14:45:59”. Nune
mos dadus oras no loron bele hakerek hamutuk hanesan
“2014-05-20 14:45:59”. Tipu dadus hirak ne’e mak hanesan : Data, Date, Time
no Year.
3.
String
Data Type
Tipu dadus string ka testu
hanesan tipu dadus ne’ebe hanesan letra ka liafuan ruma ne’ebe ninia karaktere
hakerek sempre iha simbolu (‘) ka (“). Bainhira numeru ka letra ruma hakerek ho
karaktere iha simbolu hirak ne’e nia laran indika hanesan tipu dadus srting. Tipu dadus hirak ne’e mak
hanesan : Char, Varchar, Blob/Text, TyniBlob, MediumBlob, LongBlob, Enum no Set.
4.
NULL
Null laos hanesan tipu dadus
ida maibe, nia reprejenta dadus ne’ebe mak null
ka mamuk ka seidauk iha valor, ne’e katak bainhira ita rekolia dadus ruma
maibe seidauk hatene katak dadus ne’ebe rekolia ne’e to’o ona kuantidade ka
lae, bainhira dadus ne’ebe iha seidauk priense criteria entaun dadus ne’ebe
konsidera hanesan null. Signifika
balun husi atributu balun iha MySQL mak
hanesan :
· M = luan karaktere ne’ebe masimu, ho valor
M = 255
· D = kuantidade numeru frasaun, valor
masimu D = 30 maibe labele liu (M-2)
· Atributu ho simbolu […], indikia
utilijasaun opsional
· Kundu atributu JERROFIL, MySQL automatikamente arma sai atributu UNSIGNED (numeru laiha simbolu pozitivu
ka negative).
16 July 2019 at 18:16
entaun mysql ne'e iha nia vantagem no desvantagem ga lae??? tanba wainhira ita kria projetu ida pasti iha problema ne'ebe akontese iha projetu ne'e!!!!!!!!!
17 April 2021 at 09:51
obrigado ba informasaun
klaru
1 February 2022 at 11:00
GOOD...