简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

求教个mysql基础有关问题.(PHP中)复制一条id为a的记录到同一张表里,生成一条新的记录,在此过程中修改一些字段的值,该怎么写

WBOY
Release： 2016-06-13 12:53:30
Original
1093 people have browsed it

求教个mysql基础问题.:(PHP中)复制一条id为a的记录到同一张表里,生成一条新的记录,在此过程中修改一些字段的值,该如何写?
情况是这样的:
用户复制一个已经发布的东西将其修改一部分再发布出去

发布时只提交有可能会被修改的内容,其他内容直接根据被复制的记录的id从数据库中获取

求教sql语句应该怎么写  网上不知道这个问题怎么搜....

mysql php 查询 复制
------解决方案--------------------
格式如下
INSERT INTO user_list(username,`password`,`status`) SELECT 'asfasfasf',`password`,`status`  FROM user_list WHERE id=2


红色部分本来是username的，如果不想要id=2的username，修改为asfasfasf即可
------解决方案--------------------
引用:
格式如下
INSERT INTO user_list(username,`password`,`status`) SELECT 'asfasfasf',`password`,`status`  FROM user_list WHERE id=2


红色部分本来是username的，如果不想要id=2的username，修改为asfasfasf即可
       ……

++
把sql语句中你想修改的改成你需要的内容
------解决方案--------------------
用sql语句
insert into table（字段）select 字段 from table 条件
Related labels：
nbsp
source：php.cn
Previous article： YIIframe 上excel文件的下传，读取数据保存进数据库？如何做啊求。 Next article： 数组插入MYSQL数据库，只能插入最后一行数据，是咋回事
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Preserve font spacing for a line of text split into separate HTML elements I'm trying to recreate a common technique of splitting words into separate HTML elements s...
From 2023-09-10 18:37:01
0
1
301
How to make this automatically multiline How to make this automatically multiline I'm using HTML and CSS Here is my code (I modifie...
From 2023-08-18 00:10:50
0
1
329
Why is mine wrong in the console? if (time<8) { x="zao";}else{ x="good";}Which problem
From 2023-08-03 14:42:30
0
0
99
Is this the code for conn.php? 下面<?php     $name = $_POST['username'];    $pwd  = md5($_POST['password']);    $sql = &...
From 2023-06-08 18:46:23
0
1
143
After downloading COMPOSER and installing TP6, it always fails to install, as shown in the picture. What do you want? After downloading COMPOSER and installing TP6, it always fails to install, as shown in the...
From 2023-04-01 22:49:35
0
0
632
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！