I want to combine the values ​​of the two fields are still in one table, with the command below :

update kabupaten set id_kabupaten = (
select concat(prop_id, id_kabupaten)
)
where prop_id = 11

but the above command if prop_id weakness is that I got there 50.000 values, it's not very efficient because I have to type them one by one. Please help so that commanded more efficient. Thanks b4

On Sat, 23 Jul 2011 23:58:32 -0700 (PDT), zaqi syah wrote:

No need for the WHERE clause, if you want all the rows so updated.
Since this query is potentially destructive could be repeated and cause
problems, you may wish to add another column to the table, concat() the
values into that, and (when you are satisfied with the results), replace
id_kabupaten via a single

UPDATE kabupaten SET id_kabupaten = your_new_column

and then drop your_new_column from the table.

--
It is odd, but on the infrequent occasions when I have been called upon
in a formal place to play the bongo drums, the introducer never seems
to find it necessary to mention that I also do theoretical physics.
--Feynman

On Jul 24, 1:55*pm, "Peter H. Coffin" <hell... (AT) ninehells (DOT) com> wrote:
except that he apparently only wants to perform this on something less
than the entire table.

update kabupaten set id_kabupaten = concat(prop_id, id_kabupaten)
where prop_id = 11;


mysql> create table abc (a integer, b integer);
Query OK, 0 rows affected (0.09 sec)

mysql> insert into abc values (1,1),(2,2),(3,3);
Query OK, 3 rows affected (0.05 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select concat(a,b) from abc;
+-------------+
3 rows in set (0.03 sec)

mysql> update abc set a=concat(a,b) where b=2;
Query OK, 1 row affected (0.06 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from abc;
+------+------+
3 rows in set (0.00 sec)

mysql>