browsing in search-results

I make a fulltext-search and store the results in a temporary table so the user can browser the temporary table (5 results per page...). I think this is of better performance instead of setting LIMIT $start,$elements. correct? what would happen if several visitors of the website make a search:

CONCAT() returns not correct character set

Dear MySQL fans, I tested CONCAT() with binary strings and I got strange result. Manual says: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html If the arguments include any binary strings, the result is a binary string. But the following test says: bianry + latin1

Re: It's party time!

On 2/25/06, Martijn Tonies [EMAIL PROTECTED] wrote: I'm sorry to say, there won't be any version for Linux. Not this year, at least. You can, however, connect to MySQL running on a Linux host. Martijn Tonies Too bad. Do you provide the winbox so that I can connect? 'Cause I've

problem with transfer databases from different Mysql versions

Hi, all I have installed a portal server and which has Mysql 4.0.15-nt with it. Before I installed this server, I have Mysql 4.1 in my PC. But thing is that they will conflict and I have to delete the old Mysql service. So I used mysqldump to export the databases from the 4.1 version to the sql

Why do these transactions show table locks?

My understanding is that innodb should not be using table locks for insert, update, or delete. However, the following transactions are showing table locks. What's up? R. ---TRANSACTION 0 4573, ACTIVE 1 sec, OS thread id 3112 setting table lock mysql tables in use 1, locked 0 LOCK WAIT 2 lock

RE: Why do these transactions show table locks?

It might be important to note that I have a delete trigger on the ELEMS table, also, this INSERT call is being made from a stored procedure. The stored procedure only has one line, this INSERT statement. Could this have anything to do with bug# 16229? http://bugs.mysql.com/bug.php?id=16229

Not getting list email?

I subscribed to this list about four days ago and am not getting any mail. I see on the web page that there have been new posts. What is wrong. What can I do to fix it? -- Barton L. Phillips Applied Technology Resources, Inc. Tel: (818)652-9850 Web: http://www.applitec.com

MySQL query

Please does anybody knows the content of the CD that comes with MySQL 5 Certification Study Guide and how relevant it's to passing the exams? Can someone out there provide me with a link to his copy for download? __ Do You Yahoo!? Tired of spam?

getting COUNT() TO return 0 for null matches in a query, how?

I have the following query which counts the records from a table called registration that have an schedule_id that matches a record in another table called schedules. The below query works fine but how can I get it to return a COUNT() of 0 each instance where there is no record in the

Re: getting COUNT() TO return 0 for null matches in a query, how?

Ferindo Middleton Jr wrote: I have the following query which counts the records from a table called registration that have an schedule_id that matches a record in another table called schedules. The below query works fine but how can I get it to return a COUNT() of 0 each instance where there

RE: error 1016 : cant open ibd file even though it exists

Heikki. I found the ibdata1 and ib_log files located in only '/var/lib/mysql' which is defined as the mysql home folder. The last time my.cnf was editied was on the 9th of Dec, and the database was created somewhere in the month of January. So the database would have been created with the same