after upgrade to 4.1 - error in multi delete

r.ID = rp.recommendations_id AND r.user_recommending = '$user_id' ; Error: 1109 Unknown table 'the_table_name' in MULTI DELETE Has there something changed in the syntax? Thank you for any help, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Mysql takes server down

for it. Since I have disabled the webapp, but as soon as I start mysql the system starts going down. has anybody an idea what is going wrong? Thank you for any help, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Enabling loging on mysql 3.x

with some hints how to enable both of the log files? thank you for any help, merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Default root password not blank?

: NO)' Is there a special command for blank? As I noted using password NO for hitting return. Thank you for any hint, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query to slow after inserting another table

Well this is exactly the problem. The OR statement. Do you think there is another way around the tmp table. I did not make the best experiances with tmp tables. regards, merlin On Sat, 27 May 2006 00:26:09 -0500, mos [EMAIL PROTECTED] said: Merlin, Lose the OR part of the Where clause

Re: Query to slow after inserting another table

Hi, thank you for this hint. That worked excellent! Now the overall query time is about 0.1 s on average. Best regards, Merlin On Sat, 27 May 2006 02:14:34 -0700, Merlin [EMAIL PROTECTED] said: Well this is exactly the problem. The OR statement. Do you think there is another way around

Query to slow after inserting another table

PRIMARY 2 cl.area_id 1 ta ref ad_id ad_id 3 cl.ID 2 Using where I am completly lost here. I assume that there is a much better way to include the tags table into the search. Any ideas? Thank you for any help on that. Merlin -- Merlin [EMAIL PROTECTED] -- http://www.fastmail.fm - Faster than

Re: updates during database dump

PROTECTED] -- Merlin, the Mage http://www.sites-favoritos.com/user/merlin http://www.cultodavida.com http://www.code.online.pt Carpe Vitam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Adding stop words table in german language

help, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: DBDesigner4 under Linux

to force dirs path and nothing. Need help on this? Or perhaps if someone point me out in the direction off ODBC connect to MySQL? I've never did this so don't know where to start... Thanks, Bruno -- Merlin, the Mage http://www.sites-favoritos.com/user/merlin http://www.cultodavida.online.pt http

deleting rows in 2 tables

WHERE ID = '$data[table1_id]' LIMIT 1 # delete main entry DELETE FROM $DB.$T4 WHERE ID = '$data[id]' LIMIT 1 Is there a better solution as this? Thanx for any hint, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

fulltext search on words inside words

and for and similar from the search? Is there a MySQL setting for this. Like words_to_exclude = Thanx, Merlin Oh.. I am running MySQL 4.0.14 on Suse Linux 9. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: deleting unwanted rows

[EMAIL PROTECTED] wrote: Merlin [EMAIL PROTECTED] wrote on 10/04/2005 10:58:21 AM: [EMAIL PROTECTED] wrote: Merlin [EMAIL PROTECTED] wrote on 10/04/2005 10:21:00 AM: Hi there, I just discovered, that I do have some old rows I do not need anymore. A result from

Full text search

letter, I could not find a solution. Can anybody point me to the right way? Thank you for any help, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

deleting unwanted rows

of results. I also tryed to group by t1.ID, but it did not help Does anybody have a good idea how to get rid of those rows? Thanx, Merlin PS: Thanx for the answer for the question with full text search! That worked excellent! -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: ROW_SIZE or something alike

by the number of rows. http://dev.mysql.com/doc/mysql/en/show-table-status.html -- Keith Ivey [EMAIL PROTECTED] Smokefree DC http://www.smokefreedc.org Washington, DC -- Merlin, the Mage www.code.online.pt www.cultodavida.online.pt Carpe Vitam -- MySQL General Mailing List For list archives

Re: COUNT Problem

help -- Merlin, the Mage www.code.online.pt www.cultodavida.online.pt Que o(s) vosso(s) Deus(es) vos abençoe(m) E a vida vos ame e proteja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql eats all the CPU power

and troutles down, so I have reboot and then again everything is fine for weeks. Does anybody have an idea how to fix that, I am completly lost here :-( Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql eats all the cpu power

and then again everything is fine for weeks. Does anybody have an idea how to fix that, I am completly lost here :-( Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

stressing mysql - configuration advice

with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin -- MySQL General Mailing List For list

stressing mysql - configuration advice

with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin -- MySQL General Mailing List For list

Re: Connect Error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Jonh, You're probably forget the -p param for mysqladmin ask you your root password. merlin Escreveu John Wilkerson em Thursday 02 January 2003 04:11 am: Hi, I'm a newbie with MySQL and get the following error: bin/mysqladmin

Re: Decrypt MYSQL Password

password page and want to have the user enter their e-mail and have the password sent to them. Please help! - -- Merlin, the Mage themage.camelot.co.pt -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org

Re: cant store checkbox vale ..... ?????

news letter and updates/input And this way, the value you get if the field is checked is allways 1. MPNeves -- Merlin, the Mage themage.camelot.co.pt - Before posting, please check: http://www.mysql.com/manual.php

Re: Crash importing old data to new server

on the new host. -- Merlin, the Mage themage.camelot.co.pt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail