SQL HOME SQL Intro SQL Syntax SQL Select SQL Select Distinct SQL Where SQL An Or, Not SQL Order By SQL Insert Into SQL Null Values SQL Update SQL Delete SQL Select Top SQL Min and Max SQL Count, Avg, Sum SQL Like SQL Wildcards SQL In SQL Between SQL Aliases SQL Joins SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join SQL. There may be one or more arguments. Returns the string that from concatenating the arguments.
The function actually allows for one or more arguments, but its main use is to concatenate two or more strings. Bei älteren Verbindungsservern wird der CONCAT-Vorgang lokal ausgeführt, nachdem die nicht verketteten Werte vom Verbindungsserver zurückgegeben wurden. Dans le langage SQL la fonction CONCAT() permet de concaténer les valeur de plusieurs colonnes pour ne former qu’une seule chaîne de caractère.
Cette fonction SQL peut se révéler pratique pour mettre bout-à-bout les valeurs de plusieurs colonnes pour n’en afficher qu’une. This function allows you to return a result set as a comma-separated list, as opposed to listing each row as a separate row (as with a normal result set). String-valued functions return NULL if the length of the result would be greater than the value of the max_allowed_packet system variable.
