Talk:String concatenation: Difference between revisions
Content added Content deleted
(response to select into question and a general compatibility comment) |
m (use wiki markup, not bbcode) |
||
Line 5: | Line 5: | ||
select 'greeting is ' ||a ,a ||' '|| b from foo;</lang> |
select 'greeting is ' ||a ,a ||' '|| b from foo;</lang> |
||
:What about select into? I was never sure how SQL-fu like that worked, though. --[[User:Mwn3d|Mwn3d]] 04:58, 16 November 2010 (UTC) |
:What about select into? I was never sure how SQL-fu like that worked, though. --[[User:Mwn3d|Mwn3d]] 04:58, 16 November 2010 (UTC) |
||
::<code>select into</code> seems to be a non-standard extension to sql which is mostly used for creating backups of data in existing tables. Here, though, we have three lines -- the first two lines are analogous to variable declaration and variable assignment, and the last line illustrates the task requirement. That said, note that this || mechanism is the ansi standard way to concatenate string (introduced in sql-92) and some implementations of sql (such as mysql) are [ |
::<code>select into</code> seems to be a non-standard extension to sql which is mostly used for creating backups of data in existing tables. Here, though, we have three lines -- the first two lines are analogous to variable declaration and variable assignment, and the last line illustrates the task requirement. That said, note that this || mechanism is the ansi standard way to concatenate string (introduced in sql-92) and some implementations of sql (such as mysql) are [http://troels.arvin.dk/db/rdbms/#functions-concat do not support this syntax]. --[[User:Rdm|Rdm]] 19:28, 16 November 2010 (UTC) |
Revision as of 19:29, 16 November 2010
SQL has string concatentation using infix || in the style of PL/1 but does not have variables as such.
<lang sql>create table foo ( a varchar(10),b varchar(10)); insert into foo values ('hello','dolly'),('l8r','g8r'); select 'greeting is ' ||a ,a ||' '|| b from foo;</lang>
- What about select into? I was never sure how SQL-fu like that worked, though. --Mwn3d 04:58, 16 November 2010 (UTC)
select into
seems to be a non-standard extension to sql which is mostly used for creating backups of data in existing tables. Here, though, we have three lines -- the first two lines are analogous to variable declaration and variable assignment, and the last line illustrates the task requirement. That said, note that this || mechanism is the ansi standard way to concatenate string (introduced in sql-92) and some implementations of sql (such as mysql) are do not support this syntax. --Rdm 19:28, 16 November 2010 (UTC)