/prog/ - string concatentation in sql

Name: Anonymous 2006-10-02 19:42

hey /prog/

is there any sort of function in sql like sum() but for concatentating strings instead of adding up numbers?

Name: Anonymous 2006-10-03 2:10

I know MySQL has CONCAT(), so try that.

Name: Anonymous 2006-10-03 6:09 (sage)

It's concatenation.

Name: Anonymous 2006-10-03 7:06

Depends on your DBMS. Oracle, for example:

http://www.williamrobertson.pwp.blueyonder.co.uk/documents/one_row.html

Name: Anonymous 2006-10-03 7:42

The trouble with string concatenation is that it's not a symmetric function, i.e. a+b isn't always b+a. This makes it unsuitable to apply to an unordered set, such that you would normally apply functions like SUM, MIN, MAX to.

So yeah some database systems have workarounds for this but pure SQL has no support.

Name: Anonymous 2006-10-05 19:13

none of these motherfuckers understand anything as complicated as proper relational databases

go back to fucking about with php + mysql you losers

Name: Anonymous 2006-10-06 3:13

>>6

　　　　◢▀▅　　　　　▃
　　　　▋ 　　 ▋　　◢▀　▀◣
　　　　▌　　　▌　▌ 　　 ▌
　　　 ▌　　　　▌ ▌　　　　▌
　　　▐ 　　　 ▌ ▌ 　　　▌
　　　 ▐ 　　 ▀■　　　▌
　　　◢◤　　　　　　　　　▀▃
　　◢◤　　　　　　　　　　　 ◥◣
　　▌　　　　　　　　　　　　　▌
　▐　　●　　　　　　● 　　▌ 　　　　　馬鹿にはコピペできない。
　　▌　　　　　　　　　　　　　 ▌ 　　　　　やってみそ。
　　◥◣ 　　　 ╳ 　　　　　　◢◤
　　 ◢▀▅▃▂　　　▂▂▃▅▀▅
　◢◤　　　　▀▀▀▀▀　　　　　◥◣
▐◣▃▌　　　　　　　　　　　▐▃◢▌

Name: Anonymous 2006-10-07 11:28

MySQL: CONCAT() for several strings; GROUP_CONCAT() to act as SUM() for grouped strings (will join them with commas).

Name: Anonymous 2009-01-14 14:45

Have you Read Your SICP today?

Name: Anonymous 2010-11-28 2:21

Name: Anonymous 2010-12-28 3:09

Name: Sgt.Kabuꞷkiman蒺幏 2012-05-28 20:20

Bringing /prog/ back to its people
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy
All work and no play makes Jack a dull boy

string concatentation in sql

1 Name: Anonymous 2006-10-02 19:42

2 Name: Anonymous 2006-10-03 2:10

3 Name: Anonymous 2006-10-03 6:09 (sage)

4 Name: Anonymous 2006-10-03 7:06

5 Name: Anonymous 2006-10-03 7:42

6 Name: Anonymous 2006-10-05 19:13

7 Name: Anonymous 2006-10-06 3:13

8 Name: Anonymous 2006-10-07 11:28

9 Name: Anonymous 2009-01-14 14:45

10 Name: Anonymous 2010-11-28 2:21

11 Name: Anonymous 2010-12-28 3:09

12 Name: Sgt.Kabuꞷkiman蒺幏 2012-05-28 20:20