Re: mysqlimport csv file import problem

2006-08-28 Thread Jim Seymour
On Mon, 2006-08-28 at 13:47 +0200, Thomas Spahni wrote: > On Sun, 27 Aug 2006, Jim Seymour wrote: > > > Hi, > > > > I download a csv file from Yahoo in this format: > > > > ABIAX > >20.63 > >

mysqlimport csv file import problem

2006-08-26 Thread Jim Seymour
to find an easier way than typing all of the data into a text file for import. Thanks, -- Jim Seymour <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part

ALTER TABLE - how to fix truncated data?

2005-10-16 Thread Jim Seymour
running MySQL v5.0.13 on a Debian Etch(Testing) box. TIA, Jim Seymour -- I started using something better than the "standard" back when IBM advertised OS/2 Warp on TV. As Linux matured I made the transition from OS/2 v4 to Linux. You don't have to accept less than you deserve. "

Re: Financial return calculations help please

2005-10-06 Thread Jim Seymour
On Wed, Oct 05, 2005 at 11:23:00AM -0700, Mike Wexler wrote: > Jim Seymour wrote: > > >I have researched repeatedly and cannot find an answer to the following. I > >need to do something like the following (There is probably an easier > >way). > > > >end_d

Financial return calculations help please

2005-10-05 Thread Jim Seymour
I have researched repeatedly and cannot find an answer to the following. I need to do something like the following (There is probably an easier way). end_date - start_date = diff / start_date = return for period The table contains 401k investment values. Ideas, pointers, etc.? I am using mysql v5

Re: Stored procedures MS SQL Server to MySQL

2005-09-26 Thread Jim Seymour
D; > | > DELIMITER ; > CALL CountPhoneNumbers(@x); > SELECT @x; > Thanks Peter, Since she was teaching us about using a variable I am trying your second example. Thanks again, Jim Seymour -- I started using something better than the "standard" back when IBM advertise

Stored procedures MS SQL Server to MySQL

2005-09-25 Thread Jim Seymour
putting various parts of the query into the parentheses. The error messages always seem to occur around the @count variable. I am using MySQL v.5.0.12 on Debian Etch. TIA, Jim Seymour -- I started using something better than the "standard" back when IBM advertised OS/2 Warp on TV