问题描述:
想复制一条数据作为测试数据,这样就不用担心破坏原来数据的完整性。
方法:
参考文章:https://blog.csdn.net/New_Yao/article/details/80831120
/* Formatted on 2018/11/6 1:08:22 (QP5 v5.256.13226.35538) */
INSERT INTO STUDENT (STUDENT_ID,
FIRST_NAME,
LAST_NAME,
STREET_ADDRESS,
ZIP,
PHONE,
EMPLOYER,
REGISTRATION_DATE,
CREATED_BY,
CREATED_DATE,
MODIFIED_BY,
MODIFIED_DATE)
SELECT '101',
FIRST_NAME,
LAST_NAME,
STREET_ADDRESS,
ZIP,
PHONE,
EMPLOYER,
REGISTRATION_DATE,
CREATED_BY,
CREATED_DATE,
MODIFIED_BY,
MODIFIED_DATE
FROM STUDENT
WHERE STUDENT_ID = 102