I am trying to run a query to combine fields from one table to another table in the same mysql database.
I tried to execute in phpmyadmin and only changes 1 record (but does it correctly)
After research i found that it should not be done in phpmyadmin. So the only other way i know how was in ssh. Im running putty on my windows 8 pc and i can login to my server then i can log into mysql database. When running the query it still only changes on row.
So then i started looking at php's but not sure that's what i need to do. I would assume i could just run this query to go through entire table but maybe im missing something.
Here is the query im running.
INSERT INTO appfilter2 SELECT userapps.name, GROUP_CONCAT(CONCAT(userapps.activity, '/',userapps.class)) AS activity FROM userapps
How can i simply run this query to fill my appfilter2 table with all concatenated entries from userapps?Answer1:
Your SELECT query is missing a GROUP BY clause. Probably you mean:
INSERT INTO appfilter2 SELECT userapps.name, GROUP_CONCAT(CONCAT(userapps.activity, '/',userapps.class)) AS activity FROM userapps GROUP BY userapps.name