{"id":40596,"date":"2025-11-05T06:59:35","date_gmt":"2025-11-05T06:59:35","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=40596"},"modified":"2025-11-05T07:13:41","modified_gmt":"2025-11-05T07:13:41","slug":"convert-sql-insert-statement-to-sql-update-statement","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/datafileconverter\/convert-sql-insert-statement-to-sql-update-statement.html","title":{"rendered":"Convert SQL Insert Statement To SQL Update Statement"},"content":{"rendered":"

Sometimes, you need to convert SQL insert statement to SQL update statement, you can use Withdata DataFileConverter<\/a>, easy and fast.<\/p>\n

For example, you have a file employees_insert.sql, contains 2 SQL insert statements for SQL Server:<\/p>\n

insert into employees (department_id,last_name,first_name,job_id,salary,email,manager_id,commission_pct,phone_number,employee_id,hire_date) \r\n  values (90,'King','Steven','AD_PRES',24000,'SKING',null,null,'515.123.4567',100,'6\/17\/1987') ;\r\ninsert into employees (department_id,last_name,first_name,job_id,salary,email,manager_id,commission_pct,phone_number,employee_id,hire_date) \r\n  values (90,'Kochhar','Neena','AD_VP',17000,'NKOCHHAR',100,null,'515.123.4568',101,'9\/21\/1989') ;\r\n<\/pre>\n
Use DataFileConverter, start a new task, and choose “From” “File” “SQL”, “To” “File” “SQL”.
\n\"New<\/p>\n
1. Choose source SQL insert statement file.
\n\"SQL<\/p>\n
2. Choose “SQL Server” in “DBType”; Choose “Update” in “Convert Mode”; Set “By Key” to primary key, or unique index (include\u00a0Multiple-Column index).
\n\"SQL\"<\/p>\n
3. See summary, click “Next”, then click “OK” to confirm.
\n\"SQL<\/p>\n
4. See converting, and then click “View” to see output “Update” SQL.
\n\"SQL<\/p>\n
The output “Update” SQL:
\n\"SQL<\/p>\n
The output “Update” SQL is for SQL Server:<\/p>\n
update employees set department_id=90,last_name='King',first_name='Steven',job_id='AD_PRES',salary=24000,email='SKING',manager_id=null,commission_pct=null,phone_number='515.123.4567',hire_date='6\/17\/1987'\r\nwhere employee_id=100;\r\nupdate employees set department_id=90,last_name='Kochhar',first_name='Neena',job_id='AD_VP',salary=17000,email='NKOCHHAR',manager_id=100,commission_pct=null,phone_number='515.123.4568',hire_date='9\/21\/1989'\r\nwhere employee_id=101;\r\n<\/pre>\n
You can convert for other database also, just choose other “DBType”:<\/p>\n
\"SQL<\/p>\n
And it will create “Update” SQL for the “DBType”, like DB2:<\/p>\n
update EMPLOYEES set DEPARTMENT_ID=90,LAST_NAME='King',FIRST_NAME='Steven',JOB_ID='AD_PRES',SALARY=24000,EMAIL='SKING',MANAGER_ID=null,COMMISSION_PCT=null,PHONE_NUMBER='515.123.4567',HIRE_DATE=TIMESTAMP_FORMAT('6\/17\/1987','MM\/DD\/YYYY')\r\nwhere EMPLOYEE_ID=100;\r\nupdate EMPLOYEES set DEPARTMENT_ID=90,LAST_NAME='Kochhar',FIRST_NAME='Neena',JOB_ID='AD_VP',SALARY=17000,EMAIL='NKOCHHAR',MANAGER_ID=100,COMMISSION_PCT=null,PHONE_NUMBER='515.123.4568',HIRE_DATE=TIMESTAMP_FORMAT('9\/21\/1989','MM\/DD\/YYYY')\r\nwhere EMPLOYEE_ID=101;\r\n<\/pre>\n
MySQL:<\/p>\n
update `employees` set `department_id`=90,`last_name`='King',`first_name`='Steven',`job_id`='AD_PRES',`salary`=24000,`email`='SKING',`manager_id`=null,`commission_pct`=null,`phone_number`='515.123.4567',`hire_date`=str_to_date('6\/17\/1987','%m\/%d\/%Y')\r\nwhere `employee_id`=100;\r\nupdate `employees` set `department_id`=90,`last_name`='Kochhar',`first_name`='Neena',`job_id`='AD_VP',`salary`=17000,`email`='NKOCHHAR',`manager_id`=100,`commission_pct`=null,`phone_number`='515.123.4568',`hire_date`=str_to_date('9\/21\/1989','%m\/%d\/%Y')\r\nwhere `employee_id`=101;\r\n<\/pre>\n
Oracle:<\/p>\n
update EMPLOYEES set DEPARTMENT_ID=90,LAST_NAME='King',FIRST_NAME='Steven',JOB_ID='AD_PRES',SALARY=24000,EMAIL='SKING',MANAGER_ID=null,COMMISSION_PCT=null,PHONE_NUMBER='515.123.4567',HIRE_DATE=to_date('6\/17\/1987','MM\/DD\/YYYY')\r\nwhere EMPLOYEE_ID=100;\r\nupdate EMPLOYEES set DEPARTMENT_ID=90,LAST_NAME='Kochhar',FIRST_NAME='Neena',JOB_ID='AD_VP',SALARY=17000,EMAIL='NKOCHHAR',MANAGER_ID=100,COMMISSION_PCT=null,PHONE_NUMBER='515.123.4568',HIRE_DATE=to_date('9\/21\/1989','MM\/DD\/YYYY')\r\nwhere EMPLOYEE_ID=101;\r\n<\/pre>\n
PostgreSQL:<\/p>\n
update employees set department_id=90,last_name='King',first_name='Steven',job_id='AD_PRES',salary=24000,email='SKING',manager_id=null,commission_pct=null,phone_number='515.123.4567',hire_date=to_timestamp('6\/17\/1987','MM\/DD\/YYYY')\r\nwhere employee_id=100;\r\nupdate employees set department_id=90,last_name='Kochhar',first_name='Neena',job_id='AD_VP',salary=17000,email='NKOCHHAR',manager_id=100,commission_pct=null,phone_number='515.123.4568',hire_date=to_timestamp('9\/21\/1989','MM\/DD\/YYYY')\r\nwhere employee_id=101;\r\n<\/pre>\n
SQLite:<\/p>\n
update [employees] set [department_id]=90,[last_name]='King',[first_name]='Steven',[job_id]='AD_PRES',[salary]=24000,[email]='SKING',[manager_id]=null,[commission_pct]=null,[phone_number]='515.123.4567',[hire_date]='1987-06-17'\r\nwhere [employee_id]=100;\r\nupdate [employees] set [department_id]=90,[last_name]='Kochhar',[first_name]='Neena',[job_id]='AD_VP',[salary]=17000,[email]='NKOCHHAR',[manager_id]=100,[commission_pct]=null,[phone_number]='515.123.4568',[hire_date]='1989-09-21'\r\nwhere [employee_id]=101;\r\n<\/pre>\n
See also:
\nExport databases data to SQL files<\/a>
\nConvert data between SQL and other file types<\/a>
\nImport data from SQL files to databases<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes, you need to convert SQL insert statement to SQL update statement, you can use Withdata DataFileConverter, easy and fast. For example, you have a file employees_insert.sql, contains 2 SQL insert statements for SQL Server: insert into employees (department_id,last_name,first_name,job_id,salary,email,manager_id,commission_pct,phone_number,employee_id,hire_date) values (90,’King’,’Steven’,’AD_PRES’,24000,’SKING’,null,null,’515.123.4567′,100,’6\/17\/1987′) ; insert into employees (department_id,last_name,first_name,job_id,salary,email,manager_id,commission_pct,phone_number,employee_id,hire_date) values (90,’Kochhar’,’Neena’,’AD_VP’,17000,’NKOCHHAR’,100,null,’515.123.4568′,101,’9\/21\/1989′) ; Use DataFileConverter, start a new task, […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1477],"tags":[13288,67,13289,2561],"class_list":["post-40596","post","type-post","status-publish","format-standard","hentry","category-datafileconverter","tag-insert","tag-sql","tag-sql-convert","tag-update"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/40596","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=40596"}],"version-history":[{"count":4,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/40596\/revisions"}],"predecessor-version":[{"id":40600,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/40596\/revisions\/40600"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=40596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=40596"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=40596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}