Concat unter MySQL & PostgreSQL

Saturday, 14 June 2008

So kann man unter MySQL 2 Spalten in einer darstellen:

SELECT CONCAT(id," ", name) AS spalte FROM tabelle;

So geht es unter PostgreSQL:

SELECT id || ' ' || name AS spalte FROM tabelle;

Tags: ,

The entry 'Concat unter MySQL & PostgreSQL' was posted on June 14th, 2008 at 20:15 and last modified on June 26th, 2010 at 22:09, and is filed under Allgemein. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

One Response to “Concat unter MySQL & PostgreSQL”

  1. garyx7de writes:
    No. 1 — February 1st, 2009 at 21:56

    :) Hab ich neulich mal wieder gut gebrauchen können. unter mysql.de such ich da immer ewig

«
»