Re: porting data from oracle to mysql
yeah i knew i had to get NULL somehow
i had some problems with the sql query that is creating the file ;-)
i fixed it
now the file contains lines like these
insert into mysql.table1 (2222, '2004-12-12', 23);
insert into mysql.table1 (2222, '2004-12-12', 23);
insert into mysql.table1 (2222, NULL , 23);
insert into mysql.table1 (2222, NULL , 23);
and this works
thanks a lot Josh
looking forward to talking to you again :-)
thanks again
Subject
Views
Written By
Posted
17115
October 25, 2004 12:26AM
13439
November 16, 2004 06:54PM
45069
November 16, 2004 09:47PM
14472
November 17, 2004 09:54PM
10628
November 17, 2004 11:36PM
8372
November 21, 2004 10:05PM
13984
November 22, 2004 04:18PM
6732
November 23, 2004 12:29AM
6241
November 23, 2004 01:07PM
5808
November 23, 2004 11:39PM
6186
November 24, 2004 12:06AM
5210
November 24, 2004 02:10AM
6416
November 24, 2004 03:36AM
4577
November 24, 2004 04:43AM
5022
November 24, 2004 03:49PM
Re: porting data from oracle to mysql
5073
November 25, 2004 01:52AM
5156
January 13, 2005 01:42AM
24249
April 17, 2005 05:35PM
11125
April 19, 2005 12:07AM
7715
September 05, 2007 10:18AM
8419
January 14, 2008 02:38PM
8720
January 22, 2008 06:23PM
6553
April 25, 2005 08:55AM
6871
February 09, 2005 01:22AM
6289
February 10, 2005 05:18PM
6352
September 07, 2005 11:45PM
6501
March 14, 2007 03:02AM
6105
February 06, 2009 02:07PM