Finding and Replacing DML statements - complex case
Posted: Mon 06 Jul 2009 10:40
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".
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".