fulltext phrase search

Hi, Using mysql 4.0.2 I get the following behaviour (phrase searching): match (field) against ('pack of' in boolean mode) gives me all results with 'pack of', not just 'pack'. So MySQL isn't ignoring 'of' even though the word is too short to normally be considered. However if I use:

innodb database schema dump

I had the same problem, and while I don't think there's a way around it, you can load the schema with the force option so that it will eventually make it to the table the must be created first, (even if a previous table creation gives an error). Running the script many times over and over will

Re: Foreign Keys with MySQL 3.23.49 and 3.23.50

This example is in InnoDB though, which should support foreign key constraints. Chris Book In other words data integrity between two tables is not ensured by MySQL. Your application code must solve this. - Before posting,

3.23 FullText 'AND' Search

Hello, I'm having problems getting the fulltext search to return useful results. I wan't to query all the results in my table that contain all of the search words entered. I don't have mysql 4.0 so I can't use the binary search. If I use ... where match field against ('word1') and match field

RE: FullText Search 3.23.49-nt

Try not using the word 'text' as your column name. Using reserved and key words causes problems. Chris sql CREATE TABLE tcl (id int(10) primary key not null, description varchar(254), date timestamp, value int(11), department tinyint(3), text text, fulltext(description,text))

RE: GRANT'ing for localhost and %

I would tend to think that granting access to user@'%' would also allow connections from localhost It depends...if you connect from the local machine specifying 'localhost', or without specifying a hostname, then mysql looks for the localhost permission. If you connect through the localhost,

Strange COUNT results

I'm using PHP with mySQL and I got very weird results when I ran a count. I used SELECT COUNT(*) FROM $TableName, with $TableName being my table's name, for the Query. When I printed the result I got Resource id #2, what does that even mean. And what did I do wrong? You tried to print your

opinion - voating

Any one have example Banking software written in PERL or PHP with MySql Database. if you have one mail me or provide me the URL of such software. I don't think there are many banks that don't pay insane amounts for Oracle or IBM to come in and design all their systems.

Fw: LOAD_FILE does not work

UPDATE Software SET Description = LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file) WHERE ID = 9 You have to make sure that not only can mysql read the file, but it also has permissions to the directories that the files are in. Typically your home directory on your

Removing all escape Characters?

2. a coldfusion function to make the sql statements safe. You only have to escape like 3 characters. ', , and \. You could just do 3 string replacements or create your own function to perform 3 string replacements. Chris

problems loading a datafile into a database table

I tried changing my file using chmod 777 datafile.ext and confirmed that I am the file's owner. Can anyone help me? Your user directory /home/usrename doesn't allow the mysql process to read files within it (it uses user 'nobody') Either change the access to your home directory, or put the

SUB-SELECT

You can'd use sub-selects... you have to do it with a join. Chris Can I make a query in mySQL like this? DELETE FROM table1 WHERE id NOT EXIST IN (SELECT id FROM table2) - Before posting, please check:

RE: SUB-SELECT

they will be in mysql 4.1 -Original Message- From: Rosyna [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 2:11 PM To: Christopher Book; '[EMAIL PROTECTED]' Subject: Re: SUB-SELECT Anyone know if subselects will be available in the future? Ack, at 11/15/01, Christopher

RE: nonstandard meaning of KEY in MySQL?

I don't think that's entirely true. MSAccess doesn't refer to indexes, only keys... and keys in access can be unique or non-unique based on your key properties. This is identical to how MySQL treats the terms. Chris What are the *standard* meanings of these terms? The usage in the textbook

Joins with priority

If you use UNIONS (in MySQL 4.0) then you can simply union your different cases together. Chris I have two tables, and I want to join them based on some priority rules: - Before posting, please check:

RE: Re: Default forced on MySQL

I guess you'll have to wait till its implemented its on the TODO Is that too much to ask? database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual)

memory issues for large table query

When I run a query SELECT count(*) as count FROM tbl where col_1 like 'value1', the query can take up to 45 minutes to bring back a result if there are large number (sometimes 1 million plus) of records that match 'value 1'. Use EXPLAIN to make sure that you're using an index that you have on

Text qualifiers

I tried to wrap the text in double quotes to tell it not to terminate the line. However, my imports have still failed. This could be due to my lack of experience or wrong syntax. But I did everything as told in the documntations. What parameters are you using for your import? If you give us a

'too many connections'

Hi, My website database allows 300 connections, but every once and a while the database stops accepting new connections saying that there is too many. PHP *should* automatically close connections when my scripts end, but perhaps its not doing that. Anyhow, is there a way to have my connections

Re: 'too many connections'

No, I'm not using mysql_pconnect, and my apache configuration seems fine. I don't have very many users at the moment so there is no reason for the connections filling up. This can be due to your apache configuration. do you use mysql_pconnect function in php. Check you apache setting agains

RE: Unique and case-insensitivity with indexes

If you create your columns with the 'binary' parm (look in the manual), then all the comparisons will be case-sensitive. Can anyone either point out what I am doing wrong, or a workaround? database, mysql, table -

RE: 'too many connections'

- From: Arne K. Haaje [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 4:29 PM To: Christopher Book Cc: [EMAIL PROTECTED] Subject: Re: 'too many connections' Christopher Book wrote: No, I'm not using mysql_pconnect, and my apache configuration seems fine. I don't have very many

How does authentication works with MYSQL??????

Look at the 'grant' commands in the mysql manual. You have to setup permissions if you want other hosts (other than localhost) to work, by assigning permissions to all domains or a list of ips or something. Its pretty complicated, but if you just want to give one user access from anywhere its

Duplicate column names

How does MySQL handle duplicate column names? You can't create two columns with the same name in one table. If you have a query that combines multiple tables, you reference them with the table name: ie select a.id, b.id as otherid from a, b where Chris

Listing ignored words for fulltext searches

It would be nice if mysql had a function that would return a list of words that it's going to ignore when I do a full-text search. Its hard for me to explain to users of my site the difference between your words didn't match anything, and the database ignored your query because the words were

Multiple Join Headache

Is there anyway in SELECt statement to tell, if service name is DHCP look into service table , if service name is exchange look into software table. Can i use something like this service.DHCP , soft.Exchange. You could use a UNION and then specify both queries if you're using mysql 4.0 ie

Help on SQL Statement

You can't use brackets on left joins like that. If you want to do two left joins, you use: LEFT JOIN table1 ON conds LEFT JOIN table2 ON conds That's why you're getting the error that mysql displayed, it doesn't expect a bracket. Chris SELECT DISTINCT ItemMaster.ParentNum, ItemMaster.Desc1,

A space is contained in colum??

You use the ` char as a quote. (the backwards quote, right below the ESC key on your keyboard with ~) Chris When I create a table, one colum contains a space, how can I caeate it correctly? - Before posting, please check:

RE: Alternative for UNION

Can i somehow create a temporary table and add all the rows i need and do a select query from that temp table. Yeah, that's the easiest way to do it. Create temporary table A. insert into A select insert into A select select * from A If you want to mimic 'insersect' features

RE: Re: Load data infile

I didn't see any difference between using optionally or not. Any solutions to make the two that fails work? (see test case below) Using 3.23.41. That's a problem with your input data. You can't have the character that you're using to surround the fields within the field,

Problem with LIKE

Like doesn't distinguish between words, it just matches patterns. Your first query didn't match because work does not match Why this does not work and you didn't use wildcards. Your second query worked because you used a wildcard so Why this does not work matches /ANYTHING/ + 'work' If you

INSERT, UPDATE and Groundhogs

Basically for each vote you insert a new record, and then to determine the tally, you have to do a count(*) on the number of records for each vote. so have ID | NAME | TIMESTAMP columns. You log each vote by doing an insert (insert into whatever (name, timestamp) values ('answer', 'timestamp')

Connecting to a remote mySQL DB via telnet

You need a mysql client to connect to a mysql server. First you telnet to your provider, and from the command prompt connect ala: mysql -uusername -p database_name or If your provider is setup to allow mysql connections from outside their servers (not as likely) then you can install a mysql

Re: removing 4 character limit for full text searches

You just missed the right spot in the manual... try here: http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html Chris I didn't make myself really clear in my question. I would like to include words that are 3 characters in a FULLTEXT index.