ds08541 2014-12-04 10:35
浏览 156
已采纳

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

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'
  • 写回答

2条回答 默认 最新

  • douyou8047 2014-12-04 10:44
    关注

    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

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?