Why is my query is not able to select form one table then insert into another table?

Question

I have two different tables, users and complaint. I want to select values from tables users and insert it into tables complaint.

Table users:

username | name | password|

Table complaint:

complaint_ID| name | date|

This what I have tried:

$query_search = "INSERT INTO complaint (name) SELECT (name) FROM users";

http://stackoverflow.com/questions/576441/insert-all-values-of-a-table-into-another-table-in-sql check this question this is the same you have asked — Abdul Muheet, Mar 29 '15 at 04:55

score 0 · Accepted Answer · edited Mar 29 '15 at 06:29

0

First use your primary key for fetching data, for retrieving the value from your table users, write a query like:

SELECT name FROM users WHERE password=(...);

And then add this data in your second table complain write a query:

UPDATE complain SET name=(.....) WHERE complaint_ID=(....);

edited Mar 29 '15 at 06:29

Luke Peterson

answered Mar 29 '15 at 05:14

Rajveer shing

1 Answers1