获取mysql表行内容并使用PHP将其插入到同一个表中?
问题描述:
Here i have situation in my mysql table,i want get the particular row value and the same value i want to insert into another row in the same table.
Here the example
qualification Name Age id(pk)
BE ragu 22 1
BE ravi 33 2
I want To insert 2nd row again,the result must b like the following:
qualification Name Age id(pk)
BE ragu 22 1
BE ravi 33 2
BE ravi 33 3
Suggest me some idea.... thanks in advance...
这里我的mysql表中有情况,我希望得到特定的行值和我要插入的相同值 在同一个表中的另一行。 p>
此处示例 p>
资格名称年龄id(pk)
BE ragu 22 1
BE ravi 33 2
code> pre>
我想再次插入第二行,结果必须如下所示: p>
资格名称年龄id(pk)
BE ragu 22 1
BE ravi 33 2
BE ravi 33 3
code> pre>
建议我一些想法....提前感谢 ...... p>
div>
答
Use INSERT ... SELECT
syntax for that
INSERT INTO Table1 (qualification, Name, Age, id)
SELECT qualification, Name, Age, 3
FROM Table1
WHERE id = 2
Here is SQLFiddle demo