prompt perror 139
MySQL error code 139: Too big row
Seems you are exceeding some limit.
Where did you run the perror command from? I tried to run that in the
MySQL command line utility and got an error?
At any rate, the field in question is a Text field. My understanding is
that the
This is a known bug, Ive installed MySQL 4 client binaries as a work
around...
_
From: Andy Smith [mailto:[EMAIL PROTECTED]
Sent: 2008-10-30 18:26
To: 'mysql@lists.mysql.com'
Subject: mysql dump problems, no data dumped
Im having an issue using mysqldump to dump a DB from comercial
The next MySQL University session will take place this Thursday, 6th
November. Jay Pipes will take you on a guided tour
This session will start at 17:00 UTC / 9:00am PST / 12:00 EST / 17:00
BST / 18:00 CET.
MySQL University is an educational program run virtually on the 'net.
Sessions are open
Hello List,
I have a question about trying to calculate an average across columns. I am
trying to calculate the results of surveys where in the data I have
individuals that have marked questions on the survey as N/A. in my survey I
am using 1-6 as the evaluated answers and if the person marked
Eric,
I'd replace
(avg(IF(avgTest.Q17,avgTest.Q1,Null))
+avg(IF(avgTest.Q27,avgTest.Q2,Null))
+avg(IF(avgTest.Q37,avgTest.Q3,Null))
+avg(IF(avgTest.Q47,avgTest.Q4,Null))
+avg(IF(avgTest.Q57,avgTest.Q5,Null)))/5 as overallAvg from avgTest
group by course;
with ...
Hello Peter,
Thanks for your suggestion, I think I have found another way to get the
average that I need.
If the formula I have come up with does not work I will try your formula.
Thank you
Eric H. Lommatsch
Programmer
360 Business
2087 South Grant Street
Denver, CO 80210
Tel
Hi All,
I need advice for creating proper INDEX for a query.
The table is like:
mysql desc article;
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |