special char in full-text search

Hi All, I am using the MySQL full text search capability in the search workflow in my appplication. I found that MySQL treats special character like *./,* etc. as tokenizers if they are not specified within a phrase(inside double quotes). For ex. If the search string entered is M.B.A or 24/7

Re: binary select - case sensitive

> > http://dev.mysql.com/doc/refman/5.1/en/charset-binary-op.html > > It has some good examples. got it thanks... > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: binary select - case sensitive

kalin mintchev wrote: hi all... i found this on the mysql dev manual site: "MySQL 4 and later string comparisons, including DISTINCT, aren't case sensitive unless the field is declared as BINARY or you use BINARY in your comparison." so here i tried it but no good. any ideas?! the field is not

binary select - case sensitive

hi all... i found this on the mysql dev manual site: "MySQL 4 and later string comparisons, including DISTINCT, aren't case sensitive unless the field is declared as BINARY or you use BINARY in your comparison." so here i tried it but no good. any ideas?! the field is not declared binary but i do

Re: Dynamic link

z247 wrote: Is this the only option? I get Access denied. CREATE TRIGGER ins_sum BEFORE INSERT ON account FOR EACH ROW SET @sum = @sum + NEW.amount; MySQL said: Documentation #1227 - Access denied; you need the SUPER privilege for this operation Read the error message. You don't have "super"

Re: add users in mysql 5.0 ubuntu dapper drake

Dimitri Mallis wrote: hi list firstly am in the right place to ask this sort of question i installed mysql 5.0 from the repos on ubuntu dapper drake i could only go in to mysql when i was root, & then i guess i am suposed to add users there. You've got things confused. 'mysql' the service,

Re: mysqldump: Got errno 27 on write. file too large

On Wednesday, 5 July 2006 at 9:12:52 -0400, Duhaime Johanne wrote: > I have musql 4.1.7 on Solaris 9, 64 bits and I want to mysqldump a +-4 > gigas db. > > ... > > The full directory that contains the *.frm, *.MYD,*.MYI files has the > following size: >> du -ks /seqdata/mysql/autres_bds/regen >

space usage

Does anyone havea clue of how mysql optimizes empty fields and how query speed is affected? i have a db with around 3 million rows where i need to add 2 new fields - one smallint and one varchar(10) for alot of the rows they will be empty, but because of query speed i opt to put them ion t

Re: Question on mysqldump --single-transaction

Dominik Klein wrote: Hi everyone I'm wondering about the "--single-transaction" option on mysqldump. Documentation says --- This option issues a BEGIN SQL statement before dumping data from the server. ... --- So does this include the entire dump in one transaction? Or is it one transaction

Re: automatic timestamp

Nestor wrote: People, I have the following table: DROP TABLE IF EXISTS bid; CREATE TABLE bid ( bid_id int(11) NOT NULL auto_increment, bid_proj_name varchar(100) NOT NULL default '', bid_prop_name varchar(100) NOT NULL default '', bid_amount varchar(20) NULL default '', bid_sub_name varchar

Re: automatic timestamp

> People, > > I have the following table: > DROP TABLE IF EXISTS bid; > CREATE TABLE bid ( > bid_id int(11) NOT NULL auto_increment, > bid_proj_name varchar(100) NOT NULL default '', > bid_prop_name varchar(100) NOT NULL default '', > bid_amount varchar(20) NULL default '', > bid_sub_nam

automatic timestamp

People, I have the following table: DROP TABLE IF EXISTS bid; CREATE TABLE bid ( bid_id int(11) NOT NULL auto_increment, bid_proj_name varchar(100) NOT NULL default '', bid_prop_name varchar(100) NOT NULL default '', bid_amount varchar(20) NULL default '', bid_sub_name varchar(100) NOT NULL

Re: Show tables replacement

Anyone have an idea on this? Thanks >>> "Ed Reed" <[EMAIL PROTECTED]> 6/30/06 2:51:44 PM >>> Opps! Thanks for the quick reply, Dan. But I forgot to mention I'm running MySQL 4.1.11 Any other suggestions? Thanks again. >>> Dan Nelson < [EMAIL PROTECTED] > 6/30/06 2:48:57 PM >>> In the last e

Re: Dynamic link

On Wednesday 05 July 2006 12:26 pm, z247 wrote: > How would a foreign key constraint work in this case? An example of a foreign key constraint would be something like: CREATE TABLE users ( id BIGINT UNSIGNED NOT NULL UNIQUE, username VARCHAR NOT NULL, password VARCHAR NOT NULL, status INT

RE: MS Access gives error no. -7776.

> -Original Message- > From: Daniel Kasak [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 04, 2006 5:45 PM > To: C K; mysql@lists.mysql.com > Subject: Re: MS Access gives error no. -7776. > > C K wrote: > > > Thanks for your sugesstions. I tried to search this issue on > > microsoft's web

Re: Dynamic link

How would a foreign key constraint work in this case? Thank you -- View this message in context: http://www.nabble.com/Dynamic-link-tf1896489.html#a5188192 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

RE: Dynamic link

Is this the only option? I get Access denied. CREATE TRIGGER ins_sum BEFORE INSERT ON account FOR EACH ROW SET @sum = @sum + NEW.amount; MySQL said: Documentation #1227 - Access denied; you need the SUPER privilege for this operation This is sample code from mysql site, http://dev.mysql.com/doc

RE: Temporary table ERROR 1109 (42S02) where are temporary tables kept?

Thanks again, raymond -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 05, 2006 14:54 To: Jacob, Raymond A Jr Cc: mysql@lists.mysql.com Subject: Re: Temporary table ERROR 1109 (42S02) where are temporary tables kept? Jacob, Raymond A Jr wrote: >

Re: Temporary table ERROR 1109 (42S02) where are temporary tables kept?

Jacob, Raymond A Jr wrote: Thank you, I was definitely on the wrong track on this one. I annotated your commands to make sure that I understood what they were doing. Are my comments correct? --- You have the wrong syntax. You can't mention a table in the WHERE clause that wasn't in t

RE: MySQL service startup time

Considering there are a number of pieces that are involved in the connection being ready why not create a small program that tries to connect and checks the return value. If it fails sleep for 500ms to 1 sec and try again for up to X-times before aborting altogether? Bob -Original Message-

Re: Dynamic link

On Wednesday 05 July 2006 11:40 am, Jay Blanchard wrote: > [snip] > Say I have two regular tables (table1, table2) and what a column > (status) in > the second table to update when it changes in table1. For example, if I > set > the status for a user in table1 to "0", the status for all that user's

RE: Dynamic link

[snip] Say I have two regular tables (table1, table2) and what a column (status) in the second table to update when it changes in table1. For example, if I set the status for a user in table1 to "0", the status for all that user's records in table2 dynamically changes to "0". Can this be done? Wh

Re: MySQL service startup time

Hi Rob, I have an application self-installer program which also installs MySQL and sets it up. This is all on Windows. I have a problem in that when the installer runs 'net start MySQL', it returns immediately but the MySQL daemon is not ready for connections immediately. As the next step in th

Dynamic link

Say I have two regular tables (table1, table2) and what a column (status) in the second table to update when it changes in table1. For example, if I set the status for a user in table1 to "0", the status for all that user's records in table2 dynamically changes to "0". Can this be done? What met

RE: Temporary table ERROR 1109 (42S02) where are temporary tables kept?

Thank you, I was definitely on the wrong track on this one. I annotated your commands to make sure that I understood what they were doing. Are my comments correct? --- You have the wrong syntax. You can't mention a table in the WHERE clause that wasn't in the FROM clause. Try DELE

Re: Temporary table ERROR 1109 (42S02) where are temporary tables kept?

Jacob, Raymond A Jr wrote: I ran the following commands: USE snort; CREATE TEMPORARY TABLE sidtemp SELECT cid FROM event WHERE timestamp < '2006-05-01'; ... SELECT count(*) from sidtemp; count(*) 7501376 DELETE FROM data WHERE data.cid = sidtemp.cid; ERROR 1109 (42S02): Unkown table 'sidtem

Re: Scheduled Backups Issue...

> I am attempting to set and and schedule automated MySQL backups > using the MySQL Administrator Tool downloaded from mysql.com. All > of my back ups work fien when I perform them manually. However > none of the scheduled backups ever get done. I am not sure where > the glicth is but here i

Temporary table ERROR 1109 (42S02) where are temporary tables kept?

I ran the following commands: USE snort; CREATE TEMPORARY TABLE sidtemp SELECT cid FROM event WHERE timestamp < '2006-05-01'; ... SELECT count(*) from sidtemp; count(*) 7501376 DELETE FROM data WHERE data.cid = sidtemp.cid; ERROR 1109 (42S02): Unkown table 'sidtemp' in where clause SHOW ta

add users in mysql 5.0 ubuntu dapper drake

hi list firstly am in the right place to ask this sort of question i installed mysql 5.0 from the repos on ubuntu dapper drake i could only go in to mysql when i was root, & then i guess i am suposed to add users there. i have tried "man mysql" i might have missed the part on how you add norma

Re: mysqldump: Got errno 27 on write. file too large

Dominik Klein wrote: > This might be a filesystem problem. Some filesystems (in certain > configurations) cannot hold files larger than a particular size. > > Do you have any files larger than that cut dumpfile on that partition? > Duhaime Johanne wrote: > Thank you for your answer. > > Yes I hav

MySQL service startup time

Hi, I have an application self-installer program which also installs MySQL and sets it up. This is all on Windows. I have a problem in that when the installer runs 'net start MySQL', it returns immediately but the MySQL daemon is not ready for connections immediately. As the next step in the ins

Re: NDB API Guide

Stefan Hinz schrieb: Here's some information that's probably interesting for you if you're interested in MySQL Cluster ... As part of the effort of making MySQL Cluster a more mainstream product, it's been on our agenda for a very long time to rewrite the NDB API documentation so that it become

Re: Newbie - CREATE VIEW Question

Rob Desbois schrieb: I agree that it's often better to point someone in the right direction rather than just writing the query for them, but in this case it was a newbie question. And therefore it's most important that he tries to learn how to look at the doc. Remembering my own troubles learn

RE: mysqldump: Got errno 27 on write. file too large

Thank you for your answer. Yes I have file larger than what mysqldump could manager. Here is an example of this. Both files are on the same partition. mercure{root}54: du -k mercure.log.jui2006 11948544mercure.log.jui2006 mercure{root}68: du -k myregendump 2098184 myregendump Which st

re[2]: Newbie - CREATE VIEW Question

>> I agree that it's often better to point someone in the right direction >> rather than just writing the query for them, but in this case it was a >> newbie question. >And therefore it's most important that he tries to learn how to look at >the doc. Remembering my own troubles learning MySQL, i

PBXT version 0.9.5 has been released

Hi All, PBXT version 0.9.5 has been released and can be downloaded from http://www.primebase.com/xt. This version includes a number of major structural changes to the implementation in order to improve performance. In addition, all bugs reported so far have been fixed. For further informatio

Re: mysqldump: Got errno 27 on write. file too large

How can I solve this problem? This might be a filesystem problem. Some filesystem (in certain configurations) cannot hold files larger than a particular size. Do you have any files larger than that cut dumpfile on that partition? -- MySQL General Mailing List For list archives: http://lists.

mysqldump: Got errno 27 on write. file too large

I have musql 4.1.7 on Solaris 9, 64 bits and I want to mysqldump a +-4 gigas db. The dump I want to do is from a myISAM tables databank. I used to do that dump wihtout any problem until recently while the size of the Db double (+-2 to +-4) The full directory that contains the *.frm, *.MYD,*.MYI

NDB API Guide

Here's some information that's probably interesting for you if you're interested in MySQL Cluster ... As part of the effort of making MySQL Cluster a more mainstream product, it's been on our agenda for a very long time to rewrite the NDB API documentation so that it becomes usable by mere morta

Re: UPDATE Based on Relation

I'm using version 5.?. Excellent. That seemed to do the trick. Thanks, Jesse - Original Message - From: "Remo Tex" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 05, 2006 2:31 AM Subject: Re: UPDATE Based on Relation Jesse wrote: I need to be able to do an UPDATE based on a relati

Re: Newbie - CREATE VIEW Question

Rob Desbois schrieb: Sorry but you want me to write the whole SQL query? He has to use his brain. Grouping and joining the tables. I'm not here for doing your or his work! Barry, I agree that it's often better to point someone in the right direction rather than just writing the query for them,

Question on mysqldump --single-transaction

Hi everyone I'm wondering about the "--single-transaction" option on mysqldump. Documentation says --- This option issues a BEGIN SQL statement before dumping data from the server. ... --- So does this include the entire dump in one transaction? Or is it one transaction per database (or even

re[2]: Newbie - CREATE VIEW Question

> Sorry but you want me to write the whole SQL query? > He has to use his brain. > Grouping and joining the tables. > I'm not here for doing your or his work! Barry, I agree that it's often better to point someone in the right direction rather than just writing the query for them, but in this cas

Re: Newbie - CREATE VIEW Question

Rob Desbois schrieb: To those who responded - read the question. He wants to combine the values from the data column of *2* rows into one, not just a straightforward string concatenation. Sorry but you want me to write the whole SQL query? He has to use his brain. Grouping and joining the

Re: Money

On Tuesday 04 July 2006 21:33, Karl Larsen wrote: >     I have not yet found how I can put a $ in front of all the money > columns :-) Either use concat() or do it in your program that retrieves the data from MySQL. Currency symbols are not something the database should have to store for you. -