PHP MySQL将数据从一个表插入另一个表

Question

I want to fetch data from one table to another, i have took references from many sites and Stackoverflow but I wasn't able to solve error. The last field is the applicant field where I would like to send Default value 'No'. I want to do this whole thing in single query

insert into user_identity (login_no, customer_id, prename, 
fullname, mobile, dob, age, applicant) values
select login_id, customer_id, c_prename, CONCAT_WS(' ',`c_firstname`,`c_lastname`),
 c_mobile, dob, age, 'No' from customer where id = '1'

Answer 1

the keyword VALUES is not needed,try this..

insert into user_identity (login_no, customer_id, prename, 
fullname, mobile, dob, age, applicant) 
select login_id, customer_id, c_prename, CONCAT_WS(' ',c_firstname,c_lastname),
 c_mobile, dob, age, 'No' from customer where id = '1'

refer this.. http://dev.mysql.com/doc/refman/5.1/en/insert-select.html