MySQLNdedzipi mhando dze data dzinotsigirwa?MySQLRuzivo rwemhando dze data mu
MySQL data mhando
Mhando dzenzvimbo dzedata dzakatsanangurwa muMySQL dzakakosha zvakanyanya pakugadzirisa kwe database yako.
MySQL inotsigira marudzi akasiyana-siyana, ayo anogona kukamurwa kuita zvikamu zvitatu: nhamba, zuva/nguva uye tambo (unhu) mhando.
Numeric type
MySQL databaseEse akajairwa SQL nhamba dzedhata mhando dzinotsigirwa.
Mhando idzi dzinosanganisira dzakasimba nhamba dze data mhando (INTEGER, SMALLINT, DECIMAL, uye NUMERIC), uye dzinenge dzemhando dzedhata dzenhamba (FLOAT, REAL, uye DOUBLE PRECISION).
Izwi rakakosha INT rinofanana nerokuti INTEGER uye izwi rakakosha DEC rinofanana nerekuti DECIMAL.
Iyo BIT data mhando inobata zvishoma minda kukosha uye inotsigira MyISAM, MEMORY, InnoDB, uye BDB matafura.
Sekuwedzera kune SQL standard, MySQL zvakare inotsigira iwo akakwana marudzi TINYINT, MEDIUMINT, uye BIGINT.Tafura iri pazasi inoratidza chengetedzo uye huwandu hunodiwa kune yega yega mhando.
| Type | saizi | mhando (yakasaina) | mhando (isina kusaina) | 用途 |
|---|---|---|---|---|
| TINYINT | 1 byte | (-128, 127) | (0, 255) | diki nhamba kukosha |
| SMALLINT | 2 byte | (-32 768, 32 767) | (0, 65 535) | hombe nhamba huru |
| MEDIUMINT | 3 byte | (-8 388 608, 8 388 607) | (0, 16 777 215) | hombe nhamba huru |
| INT kana INTEGER | 4 byte | (-2 147 483 648, 2 147 483 647) | (0, 4 294 967 295) | hombe nhamba huru |
| BIGINT | 8 byte | (-9 233 372 036 854 775 808, 9 223 372 036 854 775 807) | (0, 18 446 744 073 709 551 615) | yakakura kwazvo nhamba yakakwana |
| MAPFUPA | 4 byte | (-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) | kusarurama kumwe chete inoyangarara point value |
| DOUBLE | 8 byte | (-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, 693, 134, 862, 315, 7 308 XNUMX. | 0, (2.225 073 858 507 201 4 E-308, 1.797 693 134 862 315 7 E+308) | kunyatsoita kaviri inoyangarara point value |
| Sarudza | KuDECIMAL(M,D), kana M>D, iri M+2 zvimwe iri D+2 | zvinoenderana nehunhu hweM uye D | zvinoenderana nehunhu hweM uye D | decimal value |
zuva uye nguva mhando
Zuva uye nguva mhando dzinomiririra kukosha kwenguva DATETIME, DATE, TIMESTAMP, TIME, uye YEAR.
Imwe neimwe mhando yenguva ine huwandu hwehukoshi hunoshanda uye "zero" kukosha, iyo inoshandiswa pakutsanangura kukosha kusiri iyo iyo MySQL isingagoni kumiririra.
Iyo TIMESTAMP mhando ine proprietary auto-update chimiro chinozotsanangurwa gare gare.
| Type | saizi (bhayiti) | Range | fomati | 用途 |
|---|---|---|---|---|
| DATE | 3 | 1000-01-01/9999-12-31 | YYYY-MM-DD | date value |
| NGUVA | 3 | ‘-838:59:59'/'838:59:59' | HH: MM: SS | kukosha kwenguva kana nguva |
| GORE | 1 | 1901/2155 | YYYY | kukosha kwegore |
| DZIMWE NGUVA | 8 | 1000-01-01 00:00:00/9999-12-31 23:59:59 | YYYY-MM-DD HH: MM: SS | Yakasanganiswa zuva uye nguva kukosha |
| TIMESTAMP | 4 | 1970-01-01 00:00:00/2037 年某时 | YYYYMMDDHMMSS | yakasanganiswa zuva uye nguva kukosha, timestamp |
Rudzi rwetambo
Mhando dzetambo dzinoreva CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, uye SET.Ichi chikamu chinotsanangura kuti mhando idzi dzinoshanda sei uye mashandisirwo adzo mumibvunzo.
| Type | saizi | 用途 |
|---|---|---|
| TANK | 0-255 bytes | tambo-yakareba |
| VARCHAR | 0-65535 bytes | chinjika urefu tambo |
| TINYBLOB | 0-255 bytes | bhinari tambo inosvika 255 mavara |
| TINYTEXT | 0-255 bytes | short text string |
| blobs | 0-65 535 bytes | data refu yemavara mune binary fomu |
| TEXT | 0-65 535 bytes | data refu yemavara |
| ZVIRI MUKATI BLOB | 0-16 777 215 bytes | Data yemavara-epakati-refu mubhinari fomu |
| ZVIREVO ZVIRI PAKATI | 0-16 777 215 bytes | data yemavara epakati nepakati |
| LONGBLOB | 0-4 294 967 295 bytes | Yakakura kwazvo zvinyorwa zvinyorwa mubhinari fomu |
| LONGTEXT | 0-4 294 967 295 bytes | data huru kwazvo yemavara |
Mhando dzeCHAR neVARCHAR dzakafanana, asi dzinochengetwa nekudzoserwa zvakasiyana.Dzinosiyanawo maererano nehurefu hwadzo uye kana nzvimbo dzekutevera dzakachengetedzwa.Hapana kutendeuka kwemhosva kunoitwa panguva yekuchengetedza kana kutora.
Makirasi eBINARY neVARBINARY akafanana neCHAR neVARCHAR, kunze kwekuti ane tambo dzebhinari pachinzvimbo chetambo dzisiri dzebhinari.Kureva kuti ane tambo dzebyte pachinzvimbo chemavara emhando.Izvi zvinoreva kuti ivo havana hunhu seti, uye kuronga uye kuenzanisa kunoenderana nenhamba nhanho dzekoramu kukosha mabyte.
BLOB chinhu chikuru chebhinari chinogona kubata huwandu hwakasiyana hwe data.Kune marudzi mana eBLOB: TINYBLOB, BLOB, MEDIUMBLOB uye LONGBLOB.Vanongosiyana pakureba kwehurefu hwavanogona kubata.
Pane 4 TEKSTO mhando: TINYTEXT, TEXT, MEDIUMTEXT uye LONGTEXT.Aya anoenderana ne4 BLOB marudzi, ane hurefu hwakafanana hurefu uye kuchengetedza zvinodiwa.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) yakagovaniswa "Ndedzipi mhando dzedata dzinotsigirwa neMySQL? Tsanangudzo Yakadzama yeData Types muMySQL" kuti ikubatsire.
Welcome to share link yechinyorwa chino:https://www.chenweiliang.com/cwl-466.html
Tikugashirei kuTeregiramu chiteshi cheChen Weiliang's blog kuti uwane zvichangobva kuitika!
📚 Iri gwara rine kukosha kukuru, 🌟Uyu mukana usingawanzo, usapotsa! ⏰⌛💨
Govera uye like kana uchida!
Kugovera kwako uye kuda ndiko kukurudzira kwedu kunoramba kuripo!