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条)

报告相同问题?

悬赏问题

  • ¥15 谁知道这个咋搞的吗,有偿
  • ¥20 基于spring boot、的scorm
  • ¥15 往复密封问题的两个问题
  • ¥15 DAC函数和STM32
  • ¥15 任务是接收数据并把数据写入DAC7311,这些代码能实现此功能吗
  • ¥15 分析FP -Growth代码运行内存太大而无法运行的原因
  • ¥20 qtcreat 使用msvc编译器开发软件运行时字体锯齿感严重
  • ¥15 为何显示keyerror fruit
  • ¥15 imageware粗糙度表面
  • ¥15 为什么我的uibot导入py模块出错呀。py文件放在了uibot里对应的python文件夹了,卸了重安也不行