CONCAT
Misol
Add several strings together:
SELECT CONCAT("SQL ", "Tutorial ", "is ", "fun!") AS ConcatenatedString;
O‘zingiz sinab ko‘ring »
Ta’rif va qo‘llanilishi
CONCAT() funksiyasi ikki yoki undan ortiq ifodani birlashtiradi.
Eslatma: CONCAT_WS() funksiyasini ham ko‘rib chiqing.
Sintaksis
CONCAT(expression1, expression2, expression3,...)
Parametr qiymatlari
| Parametr | Tavsif |
|---|---|
| expression1, expression2, expression3, etc. |
Required. The expressions to add together.
Eslatma: Agar ifodalardan birortasi NULL qiymat bo‘lsa, u NULLni qaytaradi |
Texnik tafsilotlar
| Qo‘llab-quvvatlaydigan tizimlar: | MySQL 4.0 versiyasidan boshlab |
|---|
Ko‘proq misollar
Misol
Uchta ustunni bitta "Address" ustuniga birlashtirish:
SELECT CONCAT(Address, " ", PostalCode, " ", City) AS Address
FROM
Customers;
O‘zingiz sinab ko‘ring »
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!