Handling of NULL values when importing data from SQL Server BCP files

In the category of terrible, horrible, no good, very bad (but at least documented) software behavior, I bumped into this today: http://bugs.mysql.com/bug.php?id=14770 where the LOAD DATA INFILE command does not respect the default value of a column if no value is supplied in the file. Instead, it

Re: ~BCP for mysql~

Try Using " Select into outfile " More Info : http://dev.mysql.com/doc/refman/5.0/en/select.html --Praj On Wed, 22 Mar 2006 12:59:44 +0530 Mohammed Abdul Azeem <[EMAIL PROTECTED]> wrote: > Hi, > > Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If

Re: ~BCP for mysql~

Hi, You can try to use the command select into outfile. thanks, ehrwin At 03:29 PM 3/22/2006, Mohammed Abdul Azeem wrote: Hi, Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not, is there any other tool which can do the same operation. I need to perform a "bcp out&

Re: ~BCP for mysql~

Try "SELECT INTO OUTFILE..." Here's the MySQL documentation on that: http://dev.mysql.com/doc/ refman/5.0/en/select.html Good luck! On Mar 22, 2006, at 1:29 AM, Mohammed Abdul Azeem wrote: Hi, Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not, is

~BCP for mysql~

Hi, Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not, is there any other tool which can do the same operation. I need to perform a "bcp out" from Mysql and then "bcp in" to Sybase. Please help me out regarding the same. Than

Re: Import Sybase Ase bcp text file with date type format fields

The mysql datetime will have to be '1999-03-03 12:00:00' or 1999030312 Maurizio Danilo wrote: >Hi, > >I have to import some data in Mysql from a Sybase bulk >copy (bcp) text files, and I have some problems with >"date" type format fields. > >The

Import Sybase Ase bcp text file with date type format fields

Hi, I have to import some data in Mysql from a Sybase bulk copy (bcp) text files, and I have some problems with "date" type format fields. The sybase db has datetime fields and in the dump file the date format is like this: "Mar 3 1999 12:00:00:000AM" I have created a

Re: Mysql's equivalent of SQL Loader or BCP/DTS??

In the last episode (Jul 31), David Kramer said: > Im looking for info on Mysql's Bulk Data Loading Utility? Does it > even have one? Does it just use Perl's DBI? Any syntax would be > greatly appreciated... Check out http://www.mysql.com/doc/L/O/LOAD_DATA.html . It's a stripped-down version

Mysql's equivalent of SQL Loader or BCP/DTS??

Im looking for info on Mysql's Bulk Data Loading Utility? Does it even have one? Does it just use Perl's DBI? Any syntax would be greatly appreciated... Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 --

[OT] Re: BCP

On Tuesday 26 March 2002 2:56 pm, Harpreet Kaur wrote: > I am using > C:\> BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c > -t \t -r \n > > to create a text file from a sqlserver table . Th text file shows a tab > after every field except the last fi

BCP

I am using C:\> BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c -t \t -r \n to create a text file from a sqlserver table . Th text file shows a tab after every field except the last field. How can i get it to put a tab even after the last field. Help is apprecia

BCP

Hi, I am doing some development testing in PHP and MySQL. I have already bulk copied some data from a Sybase table into a comma sep file. My question.: How can I get this data into MySql so that I can test the speed. I am working on Win95 for now but intend porting everything to Sun Sol by the e