Tusitusiga Tusitusiga
MySQLO a ituaiga fa'amaumauga lagolago?MySQLFa'amatalaga o ituaiga fa'amaumauga i
ituaiga faʻamatalaga MySQL
O ituaiga o faʻamatalaga faʻamatalaga faʻamatalaina i MySQL e taua tele i le faʻamautuina o lau faʻamaumauga.
E lagolagoina e MySQL le tele o ituaiga, lea e mafai ona vaevaeina i ni vaega se tolu: numera, aso / taimi, ma manoa (uiga) ituaiga.
Ituaiga numera
MySQL databaseE lagolagoina uma fa'amaumauga numera numera SQL.
O nei ituaiga e aofia ai ituaiga faʻamaumauga faʻamaualuga (INTEGER, SMALLINT, DECIMAL, ma NUMERIC), ma faʻamatalaga numera faʻatatau (FLOAT, REAL, ma DOUBLE PRECISION).
O le upu INT o se uiga tutusa mo INTEGER ma le upu DEC o se uiga tutusa mo le DECIMAL.
O le BIT data type o loʻo i ai faʻatauga o fanua ma lagolagoina MyISAM, MEMORY, InnoDB, ma BDB laulau.
I le avea ai o se faʻaopoopoga i le SQL standard, e lagolagoina foʻi e MySQL ia ituaiga numera TINYINT, MEDIUMINT, ma BIGINT.O le laulau o lo'o i lalo o lo'o fa'aalia ai le teuina ma le tele e mana'omia mo ituaiga numera ta'itasi.
| Ituaiga | lapoʻa | va'aiga (saini) | va'aiga (e le'i sainia) | Faaaoga |
|---|---|---|---|---|
| TINYINT | 1 paita | (-128, 127) | (0, 255) | itiiti tau aofa'i |
| ITIITI | 2 paita | (-32 768, 32 767) | (0, 65 535) | tau aofa'i tele |
| MEDIUMINT | 3 paita | (-8 388 608, 8 388 607) | (0, 16 777 215) | tau aofa'i tele |
| INT poʻo INTEGER | 4 paita | (-2 147 483 648, 2 147 483 647) | (0, 4 294 967 295) | tau aofa'i tele |
| TELE | 8 paita | (-9 233 372 036 854 775 808, 9 223 372 036 854 775 807) | (0, 18 446 744 073 709 551 615) | tau aofa'i tele |
| LELE | 4 paita | (-3.402 823 466 E+38, -1.175 494 351 E-38), 0, (1.175 494 351 E-38, 3.402 823 466 351 E+38) | 0, (1.175 494 351 E-38, 3.402 823 466 E+38) | tasi sa'o tau opeopea |
| TUSI | 8 paita | (-1.797 693 134 862 315 7 E+308, -2.225 073 858 507 201 4 E-308), 0, (2.225 073 858 507 201 4 E-308 1.797) | 0, (2.225 073 858 507 201 4 E-308, 1.797 693 134 862 315 7 E+308) | sa'o fa'alua tau opeopea |
| FAAIUGA | Mo DECIMAL(M,D), afai M>D, o le M+2 a o le D+2 | faʻalagolago i tau o M ma D | faʻalagolago i tau o M ma D | tau tesimale |
ituaiga aso ma le taimi
Aso ma taimi ituaiga o loʻo faʻatusalia ai taimi taua o DATETIME, DATE, TIMESTAMP, TIME, ma le YEAR.
O taimi taʻitasi e iai le tele o tau aoga ma se "zero" tau, lea e faʻaaogaina pe a faʻamaonia se tau le aoga e le mafai e MySQL ona sui.
O le ituaiga TIMESTAMP o lo'o i ai se fa'afouga fa'afouga fa'apitoa e fa'amatala mulimuli ane.
| Ituaiga | lapoʻa (byte) | lautele | Fa'asologa | Faaaoga |
|---|---|---|---|---|
| ASO | 3 | 1000-01-01/9999-12-31 | YYYY-MM-DD | aso taua |
| TAIMI | 3 | ‘-838:59:59'/'838:59:59' | HH: MM: SS | taimi taua poʻo le umi |
| TAUSAGA | 1 | 1901/2155 | IYYY | tau tausaga |
| ASO E FAIA AI | 8 | 1000-01-01 00:00:00/9999-12-31 23:59:59 | YYYY-MM-DD HH: MM: SS | Fa'afefiloiga aso ma taimi |
| TIMESTAMP | 4 | 1970-01-01 00:00:00/2037 年某时 | YYYYMMDDHHMMSS | fefiloi aso ma taimi tau, faailoga taimi |
Ituaiga manoa
O ituaiga manoa e faasino ile CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, ma le SET.O lenei vaega o loʻo faʻamatalaina pe faʻafefea ona galue nei ituaiga ma faʻaogaina i fesili.
| Ituaiga | lapoʻa | Faaaoga |
|---|---|---|
| LAVA | 0-255 paita | manoa tumau-umi |
| VARCHAR | 0-65535 paita | manoa fesuisuiai umi |
| TINYBLOB | 0-255 paita | manoa binary e oo atu i le 255 mataitusi |
| TINYTEXT | 0-255 paita | manoa tusitusi puupuu |
| BLOB | 0-65 535 paita | fa'amaumauga umi o tusitusiga ile faiga fa'alua |
| TEXT | 0-65 535 paita | fa'amaumauga umi o tusitusiga |
| PULEGA MEDIUM | 0-16 777 215 paita | Fa'amaumauga o tusitusiga e feololo le umi ile faiga fa'alua |
| MEDIUM TEXT | 0-16 777 215 paita | fa'amaumauga o tusitusiga umi feololo |
| LONGBLOB | 0-4 294 967 295 paita | Tele tele fa'amaumauga o tusitusiga ile faiga binary |
| LONGTEXT | 0-4 294 967 295 paita | tele tele fa'amaumauga o tusitusiga |
O ituaiga CHAR ma VARCHAR e tutusa, ae e ese le teuina ma toe aumai.E 'ese'ese fo'i i le maualuga o le umi ma pe fa'asaoina avanoa fa'ata'amilo.E leai se fa'aliliuga mataupu e faia i le taimi o le teuina po'o le toe fa'afo'i mai.
O vasega BINARY ma VARBINARY e tutusa ma le CHAR ma le VARCHAR, se'i vagana ai o lo'o i ai ni manoa binary nai lo manoa e le fa'atasi.O lona uiga, o lo'o i ai ni manoa byte nai lo manoa fa'apitoa.O lona uiga e leai ni a latou amio, ma o le faʻavasegaina ma le faʻatusatusaga e faʻavae i luga o numera numera o paita tau koluma.
O le BLOB o se mea lapo'a tele e mafai ona fa'amauina se aofa'iga fesuisuia'i o fa'amaumauga.E 4 ituaiga BLOB: TINYBLOB, BLOB, MEDIUMBLOB ma LONGBLOB.E na'o le 'ese'ese i le maualuga o le umi o le tau e mafai ona latou uuina.
E 4 ituaiga TEXT: TINYTEXT, TEXT, MEDIUMTEXT ma LONGTEXT.O nei mea e fetaui ma ituaiga 4 BLOB, faʻatasi ai ma le maualuga maualuga ma mea e manaʻomia e teu ai.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) fa'asoa "O a ituaiga fa'amaumauga e lagolagoina e MySQL? Faʻamatalaga Faʻamatalaga o Faʻamatalaga Faʻamatalaga i MySQL" e fesoasoani ia te oe.
Fa'afeiloa'i e fa'asoa le so'otaga o lenei tusitusiga:https://www.chenweiliang.com/cwl-466.html