Finding and Replacing DML statements - complex case

[heleng]

Recently, we were updating our own database used for dbForge Data Compare for MySQL testing. I wanted to add several tables with data, using a dump file of one of the tables.

Problem
But how to drop a millisecond part in every pasted string, I mean a date like ‘2006-12-24 15:35:19.658′ should be replaced with ‘2006-12-24 15:35:19′ one? Any simple Find and Replace functionality won’t help, as I don’t know what to find and with what to replace.

Find the solution in our new article "Regular expressions to help in Finding and Replacing DML statements".