The kind of processing you desired is easily accomplisches
with the following perl program:
#!/usr/bin/perl
while (<STDIN>) {
if (/TO_DATE/) {
s/TO_DATE/STR_TO_DATE/;
s/(..)\/(..)\/(....)/$1-$2-$3/;
s/MM\/dd\/YYYY/%m-%d-%Y/;
}
print $_;
}
[EMAIL PROTECTED] cat Landon.odat
insert into log_book values
(TO_DATE('08/12/1973','MM/dd/YYYY'),'C150','N5787G',1,1.8);
[EMAIL PROTECTED] ./Landon.pl <Landon.odat
insert into log_book values
(STR_TO_DATE('08-12-1973','%m-%d-%Y'),'C150','N5787G',1,1.8);
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
