RE: Fields seem to be mis-wired (for lack of a better term)

2007-04-24 Thread Chris W. Parker
On Tuesday, April 24, 2007 10:12 AM Jim Winstead said: >> AND `type` = 0 >> AND `manager_id` = 0 >> AND `modified` = NOW() >> WHERE `id` = 5 > > you can't use 'AND' to connect your updates, you need to use commas: > > UPDATE users SET name = 'First Las

Re: Fields seem to be mis-wired (for lack of a better term)

2007-04-24 Thread Jim Winstead
On Tue, Apr 24, 2007 at 10:03:58AM -0700, Chris W. Parker wrote: > UPDATE `users` > SET `name` = 'First Last' > AND `email` = '[EMAIL PROTECTED]' > AND `balance` = 0 > AND `accrual` = 14400 > AND `is_manager` = 1 > AND `is_superadmin` = 1 > AND `type` = 0 >

Re: fields separator

2006-09-28 Thread Paul DuBois
At 7:19 + 9/27/06, [EMAIL PROTECTED] wrote: hi, everyone! I have a text file like this: 10:10:00 0 0 1 99 10:20:00 0 0 1 99 10:40:00 11 3 4 83 11:00:00 1 1 2 97 11:05:00 2 1 1 96

Re: fields separator

2006-09-27 Thread Wagner, Chris (GEAE, CBTS)
sed -r "s/ +/\t/g" infile.txt or perl -e "s/\s+/\t/g and print $_.\"\n\" while <>" < infile.txt -- Chris Wagner CBTS GE Aircraft Engines [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: fields separator

2006-09-27 Thread Jerry Schwartz
I'm used to hammering all kinds of data into MySQL. Often I do it with a PHP (or Perl) script that handles this kind of thing well. However, often my data originates on a PC (don't ask), so I run it through MS Excel. Excel (and OpenOffice, I presume) has good tools for parsing text files, and can t

Re: Re: fields separators

2006-09-27 Thread Dan Buettner
Daniel, is it that the columns in the file are separated by a variable number of spaces? Or is it that the columns are fixed-width, therefore the number of spaces varies with length of data? If the file is fixed-width, the SQL below ought to work pretty well. Either way, your situation is not t

Re: fields separators

2006-09-27 Thread danieldinu
> >Did you try using a space (' ') as the separator? Did you get an error? And at 7:41 + 27/9/06, [EMAIL PROTECTED] wrote: >Yes, I did. ... >So, I need to specify somehow that the fields are delimited by any >number of spaces... One answer of course is grep. However, as far as I can determ

Re: fields separators

2006-09-27 Thread Chris Sansom
Pe 27 Sep 2006, la 10:29, Chris <[EMAIL PROTECTED]> a scris: >Did you try using a space (' ') as the separator? Did you get an error? And at 7:41 + 27/9/06, [EMAIL PROTECTED] wrote: Yes, I did. ... So, I need to specify somehow that the fields are delimited by any number of spaces...

Re: fields separators

2006-09-27 Thread danieldinu
Pe 27 Sep 2006, la 10:29, Chris <[EMAIL PROTECTED]> a scris: > >[EMAIL PROTECTED] wrote: >> hi, everyone! >> I have a text file like this: >> 10:10:00 0 0 1 99 >> 10:20:00 0 0 1 99 >> 10:40:00 11 3 4 83 >> 11:00:00 1

Re: fields separator

2006-09-27 Thread Chris
[EMAIL PROTECTED] wrote: hi, everyone! I have a text file like this: 10:10:00 0 0 1 99 10:20:00 0 0 1 99 10:40:00 11 3 4 83 11:00:00 1 1 2 97 11:05:00 2 1 1 96 I need to load this fi

Re: fields query

2001-09-06 Thread Adams, Bill TQO
Harald Fuchs wrote: > In article <[EMAIL PROTECTED]>, > "Adams, Bill TQO" <[EMAIL PROTECTED]> writes: > > >> I need to read the fields of a table dynamically using > >> DBI.pm > >> > >> The resulting cgi script should be a form that has a > >> checkbox for each field...the user will then create a

Re: fields query

2001-09-05 Thread Adams, Bill TQO
my $dbh = DBI->connect( ... ); my $sth = $dbh->prepare( "SHOW COLUMNS FROM $table" ) or die; $sth->execute( ) or die; my @columns; while( my( $column_name ) = $sth->fetchrow_array( )){ push @columns, $column_name; } $sth->finish( ); b. "Anthony E." wrote: > I need to read the fields of a ta

RE: Fields

2001-02-22 Thread William R. Mussatto
What about varchar binary? On Thu, 22 Feb 2001, Johnny Withers wrote: > Date: Thu, 22 Feb 2001 13:35:44 -0600 > From: Johnny Withers <[EMAIL PROTECTED]> > To: Chris <[EMAIL PROTECTED]>, mysql <[EMAIL PROTECTED]> > Subject: RE: Fields > > -BEGIN

Re: Fields

2001-02-22 Thread Chris
Thanks, But I have to import that field into an access DB, can I de-code base64 in access? I will have to try and find out. > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > base64 encode the encrypted text before storing it.. > > easily done in php > base64_encode(string); > > - --

RE: Fields

2001-02-22 Thread Johnny Withers
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 base64 encode the encrypted text before storing it.. easily done in php base64_encode(string); - - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 - -Original Message- From: Chris [mailto:[EMAIL PROTECT