assigning variable without printing result?

2006-01-21 Thread Jacek Becla
Hi, Can someone tell me how to assign result to a variable inside SELECT without printing the result? Thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

upgrade advice

2006-01-21 Thread Jon Miller
I'm currently running MySQL on RedHat 7.2 and now I'm in the processing of finishing testing a new server which has SUSE Linux Enterprise Server 9. My question is my database currently resides on RH7.2 and MySQL-server-4.0.13-0. I want to install the latest version on the SUSE system but I beli

mysql-4.1.14 + linux kernel 2.6.15.1 = compile error

2006-01-21 Thread renito73
Hello list I have just upgraded my system and was reinstalling all the programs, but got problems with a few ones, including mysql 4.1.14. When compiling I get the following error, I think it may be possible because changes in the kernel headers but am not sure because it was compiling fine in

Fw: Error from mysqldump - problem solved

2006-01-21 Thread Rhino
I've resolved my problem with mysqldump. I read the error message yet again and it suddenly dawned on me what the problem might be. I made a slight modification in my table name and, sure enough, the problem went away. The problem lay in the fact that my table name was References. That's right,

Re: union/collation problem, error 1267: feature or bug?

2006-01-21 Thread Gleb Paharenko
Hello. Some times the cause of these problems is that some fields have different character sets or it is a bug. I suggest you the following steps: check if the problem still exists in 4.1.16. Then provide the create statements of your tables to the list (they include the character set information)

Re: convert help

2006-01-21 Thread Gleb Paharenko
Hello. > ERROR 1314 (0A000): PREPARE is not allowed in stored procedures PREPARE in the stored procedures should work in the latest release (5.0.18). David Godsey wrote: > Thank you. I tried this outside of the procedure and it works. However In > MYSQL 5 I get: > ERROR 1314 (0A000): PREPARE