RE: Fulltext Search help

2004-10-16 Thread Santino
Try to search in keyword table: select * from keywords WHERE MATCH(keyword_txt) AGAINST ('$radio_keyword' IN BOOLEAN MODE); If it works the problem is in the join. Santino $query = SELECT page.* FROM `page` LEFT JOIN `keywords` USING (`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST

Re: INSERT .. ON DUPLICATE KEY UPDATE behaviour

2004-10-16 Thread Sergei Golubchik
Hi! On Oct 15, Jason McManus wrote: Good afternoon, I have had reason to use the new (as of 4.1.1) INSERT .. ON DUPLICATE KEY UPDATE syntax in MySQL. However, I am a bit confused as to the return value. Issuing the INSERT .. ON DUP KEY UP statement, upon finding a duplicate key and

Transactions - working but unsure about steps

2004-10-16 Thread Stuart Felenstein
My statements are all working but I'm not sure if things are set up correctly. I say this because at one point the first $query failed, yet the rest of inserts wre committed. Now I believe I need to set autocommit to 0 , yet the query failed due to a syntax error. Hence the rule about 0 records

Show databases shows all even if no rights;

2004-10-16 Thread Michael J. Pawlowsky
I just noticed that a restricted user to only one database can still run show databases; and see all the names of the databases in MySQL. You would think that it would only return the databases that that user is allowed to connect to. Is there a way I can show only those databases that he has

RE: Transactions - working but unsure about steps

2004-10-16 Thread Osvaldo Sommer
You have a problem, what if the first insert give a error, then you don't know. You have to check each statement for error and if no error if found in all the statements then issue a commit if not a rollback Osvaldo Sommer -Original Message- From: Stuart Felenstein [mailto:[EMAIL

RE: Transactions - working but unsure about steps

2004-10-16 Thread Stuart Felenstein
Thank you Osvaldo, That is what I was thinking. Sometimes when you try to learn from example or manual it's a bit unclear because they generally show a simple transaction (1 insert into 1 table) Stuart --- Osvaldo Sommer [EMAIL PROTECTED] wrote: You have a problem, what if the first insert

RE: Fulltext Search help

2004-10-16 Thread leegold
On Fri, 15 Oct 2004 20:05:57 -0400, leegold [EMAIL PROTECTED] said: On Fri, 15 Oct 2004 15:00:10 -0700, Chris W. Parker ... But maybe there's a better way? I wish I could do *searchstring* in Fulltext even if the speed was slow as molasass it's the spec the user wants. Of course

Problems with mysqldump

2004-10-16 Thread C.F. Scheidecker Antunes
Hello all, I have a remote server that has a harddrive almost full. Therefore I need to dump a huge table to my other host. OK, I've set the permissions so that I can log in to the server as root from my host. I've try to connect to it and it works. I have to do the dump to the host because the

Re: Can MySQL do this?

2004-10-16 Thread Rhino
- Original Message - From: Skip Taylor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 16, 2004 5:08 PM Subject: Can MySQL do this? Hello, I'm new to MySQL, SQL in general and even PHP which may be needed to do this. My intention is to implement this on an Internet

Re: Can MySQL do this?

2004-10-16 Thread leegold
...snip Is there a database generation system that would be able to handle this task and generate a webpage as output? Try, AMP [Apache-MYSQL-PHP] See the tutorial, http://www.devarticles.com/c/a/Apache/Installing-PHP-under-Windows/ This tutorial is helpful. It's geared to MS Windows, so

Re: date time functions don't return not null rows

2004-10-16 Thread Eric Bergen
Your tables aren't setup very well. You should google for normalization and 'boyce codd normal form' -Eric On Sat, 16 Oct 2004 22:27:51 +0200, owca [EMAIL PROTECTED] wrote: I'm trying get current week, starting from monday to sunday: select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19, g20,

query cache derived table

2004-10-16 Thread Mike McMahon
Based on may observations, derived tables (subselect) are not cacheable: select column1, column2 from (select SQL_CACHE * from MyTable) as b The second part is not inserted to QueryCache nor is it retrieved if already in cache. Also the file comments in sql_cache.cpp - Make derived tables

Re: Show databases shows all even if no rights;

2004-10-16 Thread Paul DuBois
At 10:02 -0400 10/16/04, Michael J. Pawlowsky wrote: I just noticed that a restricted user to only one database can still run show databases; and see all the names of the databases in MySQL. You would think that it would only return the databases that that user is allowed to connect to. Is

Re: Problems with mysqldump

2004-10-16 Thread Paul DuBois
At 16:03 -0600 10/16/04, C.F. Scheidecker Antunes wrote: Hello all, I have a remote server that has a harddrive almost full. Therefore I need to dump a huge table to my other host. OK, I've set the permissions so that I can log in to the server as root from my host. I've try to connect to it and

ALTER table performance and bugs...

2004-10-16 Thread Kevin A. Burton
I just posted two detailed issues WRT the perfomance of ALTER table and what I think are pretty significant issues. For the last few days I've been using MySQLs ALTER and REPAIR table functionality and its caused tons of countless problems and a great deal of lost sleep. The first problem I

date time functions don't return not null rows

2004-10-16 Thread owca
I'm trying get current week, starting from monday to sunday: select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19, g20, g21, g22, id from tydzien where to_days(day) between to_days(now())- mod(to_days(now()),7)+2 /*some parameter setting a starting day*/ and (to_days(now())-