Всички публикации
SQLCONCATstringtutorial

What is CONCAT in SQL? String concatenation for beginners

CONCAT means "join strings together". Plain words: three forms (||, CONCAT, CONCAT_WS), how each treats NULL differently, and why CONCAT_WS is the best choice for addresses and names. With tables and common pitfalls.

1 мин четенеSQL · CONCAT · string · tutorial

CONCAT is "join several strings together". Looks impossible to mess up, but SQL has three concatenation forms that handle NULL differently. Inattention leads to "a third of users have NULL full names" bugs.

This article is currently in Russian. The full English translation is on the way.

Упражнявай се на реални задачи

Решавай задачи в SQL тренажора с незабавно оценяване и подсказки.

Отвори тренажора