X Builder Framework version 2.0 (Chkcrc32.exe) free download, latest version 2.0.0.74.
Free Download and information on X Builder Framework - X Builder Framework is used to provide common features for most Electronic Catalog and E20 II .
Reviews
The program comes with 20 databases with more than 50,000 different products. The database developer is Carrier Corporation. It also supports support and versioning. X Builder Framework also provides a database search window for you to find the product you need faster.
References
External links
Category:Electronic catalogsQ:
How to combine values from one row and make another row?
I have two different table both have the same format.
One of the columns contains a list of words. I want to have each word that occurs as a column with a unique number for the words.
So for example:
(1) 'foo' - 101
(2) 'bar' - 201
(3) 'baz' - 301
I would like to have (3) included in the table.
I've tried using the JOIN function but have had no luck with this.
SELECT a.words, b.words
FROM table a
JOIN table b
ON a.words= b.words;
Thanks in advance!
A:
you can use group_concat to get concatenated values
select group_concat(words) from t1
for eg :
mysql> select group_concat(a.words) from (select 1 as id,1 as a,2 as b,3 as c,4 as d,5 as e) as a
-> group by a.words;
+--------------------------------------------------------------------------------------------------+
| group_concat(a.words) |
+--------------------------------------------------------------------------------------------------+
| 1,2,3,4,5 be359ba680
Related links:
Comments