RE: Full text score

IIRC, I think what you need may be in here somewhere: 12.7. Full-Text Search Functions 12.7.1. Boolean Full-Text Searches 12.7.2. Full-Text Searches with Query Expansion 12.7.3. Full-Text Stopwords 12.7.4. Full-Text Restrictions 12.7.5. Fine-Tuning MySQL Full-Text Search

RE: [SOLVED] Making result rows to one row

Yes, you are correct. I tried it but I got some errors. I simplified my query and tried it, and it worked. Then I added the more complicated parts after that, and it works VERY good. This is what makes life worth living :) -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED]

Re: mySQL Backups

On 4/12/06, Tim Lucia [EMAIL PROTECTED] wrote: Would you not lock tables on the slave? The idea of catching it up implies this is way it is done. Catching up means once replication can proceed once the tables are unlocked (on the slave). At least that is the way I read it... On the slave I

RE: counting keywords

At 1:55 PM +1000 4/12/06, Taco Fleur wrote: Hello Steve, Your suggestion works like a charm, I am now trying to get my head around your following statement, I can't seem to get a grip on what you mean. Is there anyway you could elaborate a little on the following? It would be really nice if I

RE: FW: New to TRIGGER and CALL. Example gives errors. (repost)

REMOVE the semicolon ; from END;// SQLyog has a problem with all of the procedures, functions and triggers RE the DELIMITER syntax. -Original Message- From: Daevid Vincent [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 10:00 PM To: mysql@lists.mysql.com Cc: 'Shawn Green'

Fulltext and reserved words

I am in need to search for sql reserved words with MATCH AGAINST it turns it doesn't return anything when I feed it a reserved word like 'sql' is there anything I can do about that? Thanks in advance Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox

FW: Mysql C API character set

From: He, Gang Sent: Wednesday, April 12, 2006 8:43 PM To: '[EMAIL PROTECTED]' Subject: Mysql C API character set Hi, I install MySQL server 4.1.12 in Redhat Linux in Japanese environment ( env LANG=ja_JP.UTF-8 ), I setup MySQL server utf8

RE: FW: New to TRIGGER and CALL. Example gives errors. (repost)

I don't have a 5.0+ server to test with right now but this should work --- Daevid Vincent [EMAIL PROTECTED] wrote: I was using SQLYog 5.03 RC1. vmware ~ # mysql --version mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using readline 5.1 But just to sanity check. I ssh'd in and

Can't search words of three letters?

Hi to all, I have to build a search of products on web catalog site. It has to search a whole words to avoid when somebody search for a pin and get *pin*k shirt. I was suggested to use MATCH() AGAINST() and it works perfect - until I dscovered that I'm getting alwayes 0 results if search for cap,

Re: Can't search words of three letters?

Why not try regex? http://dev.mysql.com/doc/refman/4.1/en/regexp.html On 4/12/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi to all, I have to build a search of products on web catalog site. It has to search a whole words to avoid when somebody search for a pin and get *pin*k shirt. I

Re: Can't search words of three letters?

On 4/12/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi to all, hi I have to build a search of products on web catalog site. It has to search a whole words to avoid when somebody search for a pin and get *pin*k shirt. I was suggested to use MATCH() AGAINST() and it works perfect - until

Re: Can't search words of three letters?

I ca try that one too. Since, I'm bad with reg expressions, what would be solution for something like match searched word and it's plural - if one word entred, or match all words - if more words entered? thanks -afan Why not try regex? http://dev.mysql.com/doc/refman/4.1/en/regexp.html On

Error on T_echo ?? what is this ?

i,m getting the following error on my MySQL Code inserting data into a database, .? *Parse error*: parse error, unexpected T_ECHO in c:\inetpub\wwwroot\projects\testsum\adddata.php on line 30 LINE 30 is echo Query Finished;

RE: Error on T_echo ?? what is this ?

[snip] i,m getting the following error on my MySQL Code inserting data into a database, .? *Parse error*: parse error, unexpected T_ECHO in c:\inetpub\wwwroot\projects\testsum\adddata.php on line 30 LINE 30 is echo Query

RE: Error on T_echo ?? what is this ?

I believe you are missing the trailing semicolon from the previous line of code, before the //confirm comment. It's a rather cryptic way of saying it found echo when it expected something else first. Gotta love those PHP error messages. -- Jason Teagle [EMAIL PROTECTED] -Original

Re: Error on T_echo ?? what is this ?

This is not a PHP list and that's a PHP error. But you are missing a semi-colon at the end of the line ...`BondRem`). Eric Brian E Boothe wrote: i,m getting the following error on my MySQL Code inserting data into a database, .? `OthrProjBill`, `OthrRem`, `BondAm`, `BondBill`, `BondRem`)

Re: Error on T_echo ?? what is this ?

Brian E Boothe wrote: i,m getting the following error on my MySQL Code inserting data into a database, .? *Parse error*: parse error, unexpected T_ECHO in c:\inetpub\wwwroot\projects\testsum\adddata.php on line 30 LINE 30 is echo

RE: Error on T_echo ?? what is this ?

`, `OthrProjCost`, `OthrProjBill`, `OthrRem`, `BondAm`, `BondBill`, `BondRem`) //confirm echo Query Finished; ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 1.1485 (20060412) Information

Re: Fulltext and reserved words

In the last episode (Apr 12), Taco Fleur said: I am in need to search for sql reserved words with MATCH AGAINST it turns it doesn't return anything when I feed it a reserved word like 'sql' is there anything I can do about that? By default the full-text indexer skips words less than four

RE: Error on T_echo ?? what is this ?

`) //confirm echo Query Finished; ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 1.1485 (20060412) Information __ This message was checked by NOD32 antivirus system. http

RE: Error on T_echo ?? what is this ?

`, `BondAm`, `BondBill`, `BondRem`) //confirm echo Query Finished; ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 1.1485 (20060412) Information __ This message was checked

RE: Return virtual records

Thanks for the response but neither one of the responses I've received does exactly what I need since they don't return multiple rows. Are there any other ideas out there? Thanks Jay Blanchard [EMAIL PROTECTED] 4/7/06 12:37:32 PM [snip] Anyone have an idea on this? Can anyone explain how

MySQL 5.0.20 has been released

Hi, MySQL 5.0.20, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all

Do foreign keys affect query speed?

That's the whole question. Do foreign keys (FKs) affect query speed? 'Course the answer could lead to sub-questions grin /, e.g., If so, how best to optimize a query for them? And I guess a corollary question would be whether implementing FKs slows down MySQL processing in general, but that

Do foreign keys affect query speed?

That's the whole question. Do foreign keys (FKs) affect query speed? 'Course the answer could lead to sub-questions grin /, e.g., If so, how best to optimize a query for them? And I guess a corollary question would be whether implementing FKs slows down MySQL processing in general, but that

RE: Return virtual records

--- Ed Reed [EMAIL PROTECTED] wrote: Thanks for the response but neither one of the responses I've received does exactly what I need since they don't return multiple rows. Are there any other ideas out there? Thanks Jay Blanchard [EMAIL PROTECTED] 4/7/06 12:37:32 PM [snip]

Re: Best practices

Answers intermingled below --- Bruno B B Magalh�es [EMAIL PROTECTED] wrote: Hi guys I need some help with two things... I have the following table: CREATE TABLE `telephones` ( `contact_id` int(20) unsigned NOT NULL default '0', `telephone_id` int(20) unsigned NOT NULL

Re: Looking for advice on how to store and query some data

--- Russell Horn [EMAIL PROTECTED] wrote: Hi, I'm storing data against a bunch of people and want to track how it changes. So, I have a person table where everyone has a person ID and a results table a bit like this: | personID | classification | date | | 1| 0

Fw: Select a value between dates.

I'm putting your question back on the mailing list where it belongs. That enables others to help and to learn from the discussion, either now or in the future via the archives. -- Rhino - Original Message - From: H L [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 12,

RE: Select a value between dates.

This brings up a question I was asked... Which is more efficient? Select . where date between '-mm-dd hh:mm:ss' and '-mm-dd hh:mm:ss' Or Select . where unix_timestamp(date) between unix_timestamp('-mm-dd hh:mm:ss') and unix_timestamp('-mm-dd hh:mm:ss')

Re: Select a value between dates.

George Law wrote: This brings up a question I was asked... Which is more efficient? Select . where date between '-mm-dd hh:mm:ss' and '-mm-dd hh:mm:ss' This one. Or Select . where unix_timestamp(date) between unix_timestamp('-mm-dd hh:mm:ss') and

MySql Error Number 1130

Hi all, I am setting up two additional instances of mysql on my mysql server, which is running version 5.0.18-standard-log. I've got the additional instances set up, and they are running. I can see that they are bound to the proper ports. I can connect to them locally like mysql -p

Re: MySql Error Number 1130

When you are trying to connect to port 3307, for example, are you specifying that port from your remote machine? Or are you connecting to the mysqld listening on port 3306? You could try shutting down the server listening on port 3306, and then connecting to port 3307. See if the error

RE: Fulltext and reserved words

Thanks for that, you saved the day. I am now trying to change that variable, I did a search through the ini files and changed the only file that had ft_min_word_len in it to ft_min_word_len = 2 restarted the server did SHOW VARIABLES and it still shows as 4, not sure what I am missing, going

comparing 2 dbs and generating 'upgrade sql'

hey guys, A while ago I remembered using SQLYog or some other tool that could look at two databases (say dev and test versions) and work out the differences in structure between the two, and generate some SQL to 'upgrade' one to the other (bunch of alter table commands basically). I'm

question

Is there any way to set many columns of the table in one line? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

customized variations on words with fulltext

Hi all, sorry for all the questions lately, just getting my feet wet in MySQL. Is there any way to create my own variations on words so that MySQL will include those in the fulltext search? What I am after is for example if someone enters VB, I'd like the search to also look for; - Visual

[NEWBIE] How To Trim Database To N Records

Hi, I'm a beginning MySQL user ... I have a table of log entries. Over time, the entries could grow to be numerous. I'm like to trim them to a reasonable number. Is there a query that will, say, trim a table down to a million rows (with some sort order, of course, as I'm interested in

Re: [NEWBIE] How To Trim Database To N Records

At 11:15 PM -0400 4/12/06, David T. Ashley wrote: Hi, I'm a beginning MySQL user ... I have a table of log entries. Over time, the entries could grow to be numerous. I'm like to trim them to a reasonable number. Is there a query that will, say, trim a table down to a million rows (with some

Re: question

--- Takanobu Kawabe [EMAIL PROTECTED] wrote: Is there any way to set many columns of the table in one line? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] The UPDATE command is not limited

Re: [NEWBIE] How To Trim Database To N Records

--- David T. Ashley [EMAIL PROTECTED] wrote: Hi, I'm a beginning MySQL user ... I have a table of log entries. Over time, the entries could grow to be numerous. I'm like to trim them to a reasonable number. Is there a query that will, say, trim a table down to a million rows

innodb vs myisam

Hi. I have the following myisam table: The table is only 32,000 rows, but over 60Megs in size. And mysql seems to be wanting to write to that file alot, so it may well be trying to seek all over the disk looking for the right spot all the time. Does innodb do a better job at keeping the file