I am asking before I post so I don't anger everyone...
Is this list okay to post a specific question regarding multiple row
inserts..
I am doing this in perl, and I need some help with the perl part...
Thanks,
Taylor
Can I perform an update on a table using load data infile..?
If I have the following table...
Name Score Rank
John NULL NULL
Susan NULL NULL
And I have a data file that has...
John,95,1
Susan,89,2
Any idea if this can be done?
Thanks,
--
MySQL General Mailing List
For list
I need help on the best way to handle a field that could have many
different ways of naming something.
For instance, school name
Let's take Saint Joseph's University
This could be Saint Joseph's Univeristy, U. of St. Joe, SJU, Univ. St.
Joe, etc...
In this case, I don't think I can always get
I have a mysql database/tables of information about netbackup jobs. I
would like to see a count of which clients are failing more than 5 times
(any status code other than 1 or 0) with the same error codes.
That was easy enough.
The query...
select count(*) as 'attempts', client, status from
Kind of klugy, but it works... Using perl or php, do a fetchrow on a
table. With any query, i.e. select * from table. Now assign @row to a
scalar variable. This will give you the length of the array. The
length is the number of columns.
-Original Message-
From: [EMAIL PROTECTED]
Thank you much, both you and Rhino responded quickly with same answer.
Doh!, That was simple. It usually is.
Thanks again.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 16, 2004 3:57 PM
To: Lewick, Taylor
Cc: [EMAIL PROTECTED
Hi all, I am having a little trouble deciding how to relate some of my
tables together.
I was wondering about creating one big lookup table to relate 3 or 4
tables together, but wasn't sure if that was a good id, or should I have
a look up table
For each pair of tables.
Here is a simple