concat

How to concatenate strings of a string field in a PostgreSQL 'group by' query?

I am going to answer my own question because I just found the answer, but thought it still worth posting here. I am looking for a way to concatenate the strings of a field within a group by query. So for example, I have a table: ID COMPANY_ID EMPLOYEE 1 1 Anna 2 1 Bill 3 2 Carol 4 2 ...

Concatenating arbitrary number of rows of strings in mysql (hierarchical query)

I have a mysql table with albums. Each album can be a top level album, or a child album of another album. Each album has a foldername which is the name of the folder its pictures are in. Each album also has a field called parent which is the id of the parent album. So, if I have a path to an image like this: root/album1/album2/image1.jp...

SQL character field concatenation (without using CONCAT() or +)

Hey.. I'm trying to concatenate 3 [char(32)] fields:title1title2title3 into one field, but the catch is that I'm using an older version of SQL and it DOES NOT support the CONCAT() subroutine or the + operatorfor example:CONCAT(title1, title2, title3)(title1 + title2 + title3) DON'T WORK!!!!Is there another way? ...

Trouble with CONCAT and Longtext

The SQL... UPDATE Threads t SET t.Content = ( SELECT GROUP_CONCAT(a.Content ORDER BY a.PageID SEPARATOR '<!-- pagebreak -->') FROM MSarticlepages a WHERE a.ArticleID = t.MSthreadID GROUP BY a.ArticleID ) As you can see it takes all of an article's pages (which are each stored as longtext in separate rows) and GROUP_CONCA...

inserting records in a MySQL table depending on existing values in another table

Hi guys, I am using MySQL. I want to insert some records in a table provided that they do not exist in another table. So I want to perform something like this: INSERT INTO sales (name, id) SELECT name, id FROM sales_h WHERE name AND id NOT IN (SELECT name, id FROM T_sales); The problem is that MySQL does not allow this kind of synta...

Mysql Prepare Statement error while executing

Hi All, I am trying to create a table though prepare statement but it is giving me syntax error. well if o try to execute the same statement individually then it work fine. here's my statement - SET @Stmt1 = Concat('DROP TABLE IF EXISTS ',DB,'.`county`;\n' 'CREATE TABLE IF NOT EXISTS ',DB,'.`County` ( `CountyID` INT UNSIGNED NOT NULL...

mysql concat() to create column names?

I would like to concatenate column names in a way that the first part of the column name is a string and the second part is a number which is the result of another query. For example: SELECT CONCAT('column', mytable.mycolumn) FROM table ... Can this be done in some way. This way it doesn't give me errors but I don't get the expected ...

How to format file name of outfile (or dumpfile)

Hello, I'm trying to format the file name for outfile using row data. I've tried the following with no success: SELECT t1.field1 FROM table1 t1 LIMIT 1 INTO OUTFILE CONCAT( '/my_path/', t1.field2, '.txt' ); Can anyone recommend alternatives? Thanks ...

Which is faster: Union or Concat? (C# Linq)

I don't care about the order of the elements. http://msdn.microsoft.com/en-us/library/system.linq.enumerable.union.aspx http://msdn.microsoft.com/en-us/library/bb302894.aspx ...

C# : concatenate 2 MP3 files

I tried to concatenate 2 MP3 files using the code below. I got a new file which I can play the first half of (complete first file), but the second half is silent. The length of the new file was correct. What do I do wrong? List<Byte[]> files = new List<byte[]>(); var tempfile = File.ReadAllBytes(Path.Combine(path, "1.mp3")); files.Add(t...

mysql select concat(charfield, format(doublefield,8)) gives error 1267

which is ironic on two counts, 1) because concat(charfield, doublefield) works (it doesn't mind when one of the fields to be concatenated is numeric) and 2) because the mysql reference shows this: CONCAT(str1,str2,...) as the prototype for CONCAT and for FORMAT this: "FORMAT(X,D) Formats the number X to a format like '#,###,###.##', rou...

MySQL - Select Concat an entire row

How can I select and concat every field in a row? I want to do something similar to this: SELECT concat(SELECT GROUP_CONCAT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'tbl_name') as single FROM tbl_name ..but obviously the above doesn't work. Any suggestions? ...

Joining each item of an array with the items of another array

Consider this: [ ["a", "b"], ["c", "d"], ["e"] ] How can this be tranformed to: [ "a c e", "a d e", "b c e", "b d e" ] ...

Concat multiple rows into a comma-delimited value during Update

I have a temporary table with a field called Method, thus: DECLARE @CaseSites TABLE ( BriefID int, Method varchar(60) -- other fields ) Method will be filled from several rows in another table - CaseEventTypeList. Running SELECT * FROM CaseEventTypeList WHERE RefID = 1 Gives RefID TypeID 1 2 1 3 1 6 Turning this into a ...

Java - is there an Inbuilt function for concatenating the Strings in a String[]?

Or a better way than this? String concat(String[] strings) { StringBuilder out = new StringBuilder(); for(String next: strings) { out.append(next); } return out.toString(); } No worries if no, I just feel like there should be a built in? ...

Concat two column in a select statement sql server 2005

How to Concat two column in a select statement sql server 2005? Here is my statement Select FirstName,secondName from Table... Now i did try concating secondName with FirstName by using Select FirstName + ' ' + secondName from Table But some values are NULL in secondName column for some records.. My select statement returns NULL i...

How to compare the files returned from SVN diff with the concatenated files in ANT

I am trying to create an ANT build script which will detect which files were changed during the development (by diff SVN command) and output the list of files which are built from these changed files. I would like to check all the Concat tasks within the build file and compare the filelists within them with the diff changed files list c...

php string function concat

$contents = "<?xml version='1.0' ?> <authed>1</authed> <book>read</book>"; im having a xml string like this i want to add all the elements inside root tag like this $contents = "<?xml version='1.0' ?> <root> <authed>1</authed> <book>read</book> </root>"; ...

how to add many strings in c++

As I know that C++ only allows to add 2 strings together, i.e: s = s1 + s2 But I want to be able to add many strings together like: s = s1 + s2 + s3 + s4 + .... + sn How could I solve this problem? Can anybody help? Thanks. ...

Why is ValueList function returning an unexpected string after using concat on MySQL query?

Hello, I have the following query where I combine two fields from two tables: <cfquery name="SearchResult" datasource="MyDSN"> SELECT CONCAT(titles.TitleName, ', ', platforms.PlatformAbbreviation) AS Result FROM games Inner Join platforms ON games.PlatformID = platforms.PlatformID ...