Re: porting data from oracle to mysql
ok so now iam doing this
insert into mysql.table1 values (23232, '2004-12-12', 232);
and it works, isee the date in the mysql table.
but now another problem
if there is no data in the date field for a record i get an error
you have an error in the sql syntax near '1111,'',1221)'
query
insert into mysql.table1 values (1111,'',1221);
Subject
Views
Written By
Posted
17529
October 25, 2004 12:26AM
13627
November 16, 2004 06:54PM
45338
November 16, 2004 09:47PM
14660
November 17, 2004 09:54PM
10813
November 17, 2004 11:36PM
8527
November 21, 2004 10:05PM
14164
November 22, 2004 04:18PM
6916
November 23, 2004 12:29AM
6402
November 23, 2004 01:07PM
5954
November 23, 2004 11:39PM
6338
November 24, 2004 12:06AM
5384
November 24, 2004 02:10AM
6578
November 24, 2004 03:36AM
Re: porting data from oracle to mysql
4719
November 24, 2004 04:43AM
5162
November 24, 2004 03:49PM
5251
November 25, 2004 01:52AM
5323
January 13, 2005 01:42AM
24471
April 17, 2005 05:35PM
11302
April 19, 2005 12:07AM
7893
September 05, 2007 10:18AM
8592
January 14, 2008 02:38PM
8943
January 22, 2008 06:23PM
6730
April 25, 2005 08:55AM
7048
February 09, 2005 01:22AM
6439
February 10, 2005 05:18PM
6507
September 07, 2005 11:45PM
6680
March 14, 2007 03:02AM
6287
February 06, 2009 02:07PM