{"id":24647,"date":"2024-06-23T18:48:37","date_gmt":"2024-06-23T11:48:37","guid":{"rendered":"https:\/\/dte.telkomuniversity.ac.id\/?p=24647"},"modified":"2024-06-23T18:48:39","modified_gmt":"2024-06-23T11:48:39","slug":"tipe-data-mariadb","status":"publish","type":"post","link":"https:\/\/dte.telkomuniversity.ac.id\/en\/tipe-data-mariadb\/","title":{"rendered":"Tipe Data MariaDB"},"content":{"rendered":"\n

Berikut adalah daftar tipe data dalam MariaDB:<\/p>\n\n\n\n

Tipe Data String<\/h3>\n\n\n\n
Tipe Data<\/th>Sintaks<\/th>Ukuran Maksimum<\/th>Penjelasan<\/th><\/tr><\/thead>
char(size)<\/td>char(255)<\/td>255 karakter<\/td>String dengan panjang tetap. Karakter diisi spasi di kanan untuk mencapai ukuran tetap.<\/td><\/tr>
varchar(size)<\/td>varchar(255)<\/td>255 karakter<\/td>String dengan panjang variabel.<\/td><\/tr>
tinytext(size)<\/td>tinytext(255)<\/td>255 karakter<\/td>String dengan panjang variabel.<\/td><\/tr>
text(size)<\/td>text(65535)<\/td>65.535 karakter<\/td>String dengan panjang variabel.<\/td><\/tr>
mediumtext(size)<\/td>mediumtext(16777215)<\/td>16.777.215 karakter<\/td>String dengan panjang variabel.<\/td><\/tr>
longtext(size)<\/td>longtext(4294967295)<\/td>4GB atau 4.294.967.295 karakter<\/td>String dengan panjang variabel.<\/td><\/tr>
binary(size)<\/td>binary(255)<\/td>255 karakter<\/td>String dengan panjang tetap. Karakter biner diisi spasi di kanan untuk mencapai ukuran tetap.<\/td><\/tr>
varbinary(size)<\/td>varbinary(255)<\/td>255 karakter<\/td>String biner dengan panjang variabel.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Tipe Data Tanggal\/Waktu<\/h3>\n\n\n\n
Tipe Data<\/th>Sintaks<\/th>Ukuran Maksimum<\/th>Penjelasan<\/th><\/tr><\/thead>
date<\/td>date<\/td>‘1000-01-01’ hingga ‘9999-12-31’<\/td>Ditampilkan sebagai ‘yyyy-mm-dd’.<\/td><\/tr>
datetime<\/td>datetime<\/td>‘1000-01-01 00:00:00’ hingga ‘9999-12-31 23:59:59’<\/td>Ditampilkan sebagai ‘yyyy-mm-dd hh:mm’.<\/td><\/tr>
timestamp(m)<\/td>timestamp<\/td>‘1970-01-01 00:00:01’ UTC hingga ‘2038-01-19 03:14:07’ UTC<\/td>Ditampilkan sebagai ‘yyyy-mm-dd hh:mm’.<\/td><\/tr>
time<\/td>time<\/td>‘-838:59:59’ hingga ‘838:59:59’<\/td>Ditampilkan sebagai ‘hh:mm’.<\/td><\/tr>
year[(2<\/td>4)]<\/td>year<\/td>Nilai tahun sebagai 2 digit atau 4 digit.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Tipe Data Numerik<\/h3>\n\n\n\n
Tipe Data<\/th>Sintaks<\/th>Ukuran Maksimum<\/th>Penjelasan<\/th><\/tr><\/thead>
bit<\/td>bit<\/td>Nilai integer sangat kecil yang setara dengan tinyint(1).<\/td><\/td><\/tr>
tinyint(m)<\/td>tinyint<\/td>Nilai integer sangat kecil.<\/td><\/td><\/tr>
smallint(m)<\/td>smallint<\/td>Nilai integer kecil.<\/td><\/td><\/tr>
mediumint(m)<\/td>mediumint<\/td>Nilai integer sedang.<\/td><\/td><\/tr>
int(m)<\/td>int<\/td>Nilai integer standar.<\/td><\/td><\/tr>
integer(m)<\/td>integer<\/td>Nilai integer standar.<\/td><\/td><\/tr>
bigint(m)<\/td>bigint<\/td>Nilai integer besar.<\/td><\/td><\/tr>
decimal(m,d)<\/td>decimal<\/td>Angka tetap tanpa dikemas.<\/td><\/td><\/tr>
dec(m,d)<\/td>dec<\/td>Angka tetap tanpa dikemas.<\/td><\/td><\/tr>
numeric(m,d)<\/td>numeric<\/td>Angka tetap tanpa dikemas.<\/td><\/td><\/tr>
fixed(m,d)<\/td>fixed<\/td>Angka tetap tanpa dikemas.<\/td><\/td><\/tr>
float(m,d)<\/td>float<\/td>Angka floating-point presisi tunggal.<\/td><\/td><\/tr>
double(m,d)<\/td>double<\/td>Angka floating-point presisi ganda.<\/td><\/td><\/tr>
double precision(m,d)<\/td>double precision<\/td>Angka floating-point presisi ganda.<\/td><\/td><\/tr>
real(m,d)<\/td>real<\/td>Angka floating-point presisi ganda.<\/td><\/td><\/tr>
float(p)<\/td>float<\/td>Angka floating-point.<\/td><\/td><\/tr>
bool<\/td>bool<\/td>Sinonim untuk tinyint(1).<\/td><\/td><\/tr>
boolean<\/td>boolean<\/td>Sinonim untuk tinyint(1).<\/td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Tipe Data Large Object (LOB)<\/h3>\n\n\n\n
Tipe Data<\/th>Sintaks<\/th>Ukuran Maksimum<\/th>Penjelasan<\/th><\/tr><\/thead>
tinyblob<\/td>tinyblob<\/td>255 byte<\/td>Blob ukuran kecil.<\/td><\/tr>
blob(size)<\/td>blob(65535)<\/td>65.535 byte<\/td>Blob ukuran sedang.<\/td><\/tr>
mediumblob<\/td>mediumblob(16777215)<\/td>16.777.215 byte<\/td>Blob ukuran besar.<\/td><\/tr>
longblob<\/td>longblob(4294967295)<\/td>4GB atau 4.294.967.295 byte<\/td>Blob ukuran sangat besar.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\/\/TC<\/p>\n\n\n\n

ref : [1]<\/a>[2]<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Berikut adalah daftar tipe data dalam MariaDB: Tipe Data String Tipe Data Sintaks Ukuran Maksimum Penjelasan char(size) char(255) 255 karakter String dengan panjang tetap. Karakter diisi spasi di kanan untuk mencapai ukuran tetap. varchar(size) varchar(255) 255 karakter String dengan panjang variabel. tinytext(size) tinytext(255) 255 karakter String dengan panjang variabel. text(size) text(65535) 65.535 karakter String dengan […]<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wds_primary_category":593,"footnotes":""},"categories":[593],"tags":[174],"class_list":["post-24647","post","type-post","status-publish","format-standard","hentry","category-mariadb","tag-mariadb"],"_links":{"self":[{"href":"https:\/\/dte.telkomuniversity.ac.id\/en\/wp-json\/wp\/v2\/posts\/24647","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dte.telkomuniversity.ac.id\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dte.telkomuniversity.ac.id\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dte.telkomuniversity.ac.id\/en\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/dte.telkomuniversity.ac.id\/en\/wp-json\/wp\/v2\/comments?post=24647"}],"version-history":[{"count":1,"href":"https:\/\/dte.telkomuniversity.ac.id\/en\/wp-json\/wp\/v2\/posts\/24647\/revisions"}],"predecessor-version":[{"id":24648,"href":"https:\/\/dte.telkomuniversity.ac.id\/en\/wp-json\/wp\/v2\/posts\/24647\/revisions\/24648"}],"wp:attachment":[{"href":"https:\/\/dte.telkomuniversity.ac.id\/en\/wp-json\/wp\/v2\/media?parent=24647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dte.telkomuniversity.ac.id\/en\/wp-json\/wp\/v2\/categories?post=24647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dte.telkomuniversity.ac.id\/en\/wp-json\/wp\/v2\/tags?post=24647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}