RE: Full text search and & sign as a part of the keyword

en [mailto:shawn.l.gr...@oracle.com] >> Sent: Tuesday, July 02, 2013 10:21 AM >> To: mysql@lists.mysql.com >> Subject: Re: Full text search and & sign as a part of the keyword >> >> Hello, >> >> (my response is not top-posted) >> On 7/2/2013 12:50 PM, l

Re: Full text search and & sign as a part of the keyword

org_id, > > address_id > > > > FROM organization > > > > WHERE org_active='Y' AND MATCH(name) AGAINST('AB&C*' IN BOOLEAN > > MODE) > > and I'm not getting any results. And there IS a org AB&C, > > In

RE: Full text search and & sign as a part of the keyword

FULLTEXT (at least the MyISAM version) has 3 gotchas: ft_min_word_len=4, stopwords, and the 50% rule > -Original Message- > From: shawn green [mailto:shawn.l.gr...@oracle.com] > Sent: Tuesday, July 02, 2013 10:21 AM > To: mysql@lists.mysql.com > Subject: Re: Full text searc

Re: Full text search and & sign as a part of the keyword

this full text search query > >> > >> SELECT name, org_id, > >> > >> address_id > >> > >> > >> > >> FROM organization > >> > >> > >> > >> WHERE org_active='Y'

Re: Full text search and & sign as a part of the keyword

tive='Y' AND MATCH(name) AGAINST('AB&C*' IN BOOLEAN MODE) and I'm not getting any results. And there IS a org AB&C, Inc. My assumption is the ampersand sign as a part of the keyword. Any idea? Read this: http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.

Full text search and & sign as a part of the keyword

Hi to all, I have this full text search query SELECT name, org_id, address_id FROM organization WHERE org_active='Y' AND MATCH(name) AGAINST('AB&C*' IN BOOLEAN MODE) and I'm not getting any results. And there IS a org AB&C, Inc. My assumption i

Single Sign On

Does mysql support Kerberos/GSSAPI authentication? If not, is there plans for it to support it? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Any Penalty For $ Sign?

In my opinion ,I alway use underscore as "f_table" in my appication. It runs well all the time. On Jan 5, 2008 6:22 AM, mos <[EMAIL PROTECTED]> wrote: > At 12:36 PM 1/4/2008, you wrote: > >Thanks. It doesn't make the programming easier...it's just easier to read > >the tables! > >Victor > > > Vic

Re: Any Penalty For $ Sign?

At 12:36 PM 1/4/2008, you wrote: Thanks. It doesn't make the programming easier...it's just easier to read the tables! Victor Victor, Just use an underscore as in "My_Table" which is quite readable. Using a "$" is just asking for trouble. Unless you're the type of guy who likes going i

Re: Any Penalty For $ Sign?

database in (at least) two > of > the most common languages? > > -Original Message- > From: Victor Subervi [mailto:[EMAIL PROTECTED] > Sent: Friday, January 04, 2008 1:08 PM > To: Wm Mussatto; mysql@lists.mysql.com > Subject: Re: Any Penalty For $ Sign? >

Re: Any Penalty For $ Sign?

> LOL! True. I'm a Python guy ;) >> > >> > On Jan 4, 2008 1:14 PM, Gerald L. Clark <[EMAIL PROTECTED]> >> > wrote: >> > >> >> Victor Subervi wrote: >> >> > Hi; >> >> > I discovered I can use a $ sign in tabl

Re: Any Penalty For $ Sign?

On Fri, January 4, 2008 09:15, Victor Subervi wrote: > > LOL! True. I'm a Python guy ;) > > > > On Jan 4, 2008 1:14 PM, Gerald L. Clark <[EMAIL PROTECTED]> > > wrote: > > > >> Victor Subervi wrote: > >> > Hi; > >> > I disc

Re: Any Penalty For $ Sign?

> On Jan 4, 2008 1:14 PM, Gerald L. Clark <[EMAIL PROTECTED]> > wrote: > >> Victor Subervi wrote: >> > Hi; >> > I discovered I can use a $ sign in table names: >> > my$table >> > Is this recommended against? It's kind of handy in my app

Re: Any Penalty For $ Sign?

LOL! True. I'm a Python guy ;) On Jan 4, 2008 1:14 PM, Gerald L. Clark <[EMAIL PROTECTED]> wrote: > Victor Subervi wrote: > > Hi; > > I discovered I can use a $ sign in table names: > > my$table > > Is this recommended against? It's kind of handy

Re: rounding digits after decimal sign

On 2007-01-31 [EMAIL PROTECTED] wrote: > Can anyone point me to a section of manual or link how to reduce digits Lookup the manual for "round()" but be sure that you understand it if you use round in financial applications as it might be unexpected for you: mysql> SELECT 25E-1 = 2.5, round(25

Re: rounding digits after decimal sign

ruary 01, 2007 1:40 AM Subject: rounding digits after decimal sign Hello, Can anyone point me to a section of manual or link how to reduce digits after a decimal sign? I have a table mysql> desc part; +-+--+--+-+-+---+ | Field | Type | Nul

Re: rounding digits after decimal sign

Dimitar Vassilev asks: Hello, Can anyone point me to a section of manual or link how to reduce digits after a decimal sign? I have a table mysql> desc part; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Ex

rounding digits after decimal sign

Hello, Can anyone point me to a section of manual or link how to reduce digits after a decimal sign? I have a table mysql> desc part; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Ex

Problems with importing the british pound (£) an d euro (€) sign

em | utf8 | | character_sets_dir | C:\MySQL\share\charsets\ | +--+--+ I have a column that stores currency symbols - two of which are the British pound (£) and euro (€) sign. I can I export via mysqldump no with problem - the "£&qu

Re: Assigment sign not work on Delphi

; will caused error "Parameter object is improperly > > defined. Inconsistent or > > incomplete information was provided." because Delphi > > look it as Parameter (a > > parameter of query in Delphi using ":" at the > > beginning). >

Re: Assigment sign not work on Delphi

":" at the beginning). Is it better for MySQL using "=" rather than ":=" ? Or is there any setting to set MySQL to accept the "=" sign? __ Yahoo! FareChase: Search multiple travel sites in one click. htt

Re: Assigment sign not work on Delphi

l caused error "Parameter object is improperly defined. Inconsistent or incomplete information was provided." because Delphi look it as Parameter (a parameter of query in Delphi using ":" at the beginning). Is it better for MySQL using "=" rather than &q

Assigment sign not work on Delphi

the beginning). Is it better for MySQL using "=" rather than ":=" ? Or is there any setting to set MySQL to accept the "=" sign? __ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.

Re: Does MySQL Support '=' Sign?

>Did you read the link? Yes. >The OP wanted to know if MySQL supported the = sign in a SELECT statement. The documentaion I referred the OP to clearly >differentiates the use of = and := within SELECT statements and SET statements for MySQL. If the MySQL behavior is not what >they

Re: Does MySQL Support '=' Sign?

this is the same. > > In MS SQL, using the above construct defines a column alias. > > With regards, > > Martijn Tonies > Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL > Server > Upscene Productions > http://www.upscene.com >

Re: Does MySQL Support '=' Sign?

2005/11/11, The Nice Spider <[EMAIL PROTECTED]>: > Does MySQL support: > > SELECT ID_TAG= ID > FROM TABLE > > rather than select ID TAG_ID from Table. I need this for MS SQL Compabilty. > Did you try the AS keyword ? Select ID As ID_TAG from TABLE -- Pooly Webzine Rock : http://www.w-fenec.org/

Re: Does MySQL Support '=' Sign?

> > Does MySQL support: > > > > SELECT ID_TAG= ID > > FROM TABLE > > > > rather than select ID TAG_ID from Table. I need this for MS SQL > Compabilty. > > > > > > > Within the SELECT statement you must use := If you were in a SET > statement, you could use = or := > > http://dev.mysql.com/doc/re

Re: Does MySQL Support '=' Sign?

The Nice Spider <[EMAIL PROTECTED]> wrote on 11/10/2005 09:40:31 PM: > Does MySQL support: > > SELECT ID_TAG= ID > FROM TABLE > > rather than select ID TAG_ID from Table. I need this for MS SQL Compabilty. > > Within the SELECT statement you must use := If you were in a SET statement, yo

Does MySQL Support '=' Sign?

Does MySQL support: SELECT ID_TAG= ID FROM TABLE rather than select ID TAG_ID from Table. I need this for MS SQL Compabilty. - Yahoo! FareChase - Search multiple travel sites in one click.

Re: Underline or minus sign ?

use: innodb-file-per-table no instead of innodb_file_per_table ? this one (at least for 4.1.11) [This is just an example] Can I use only minus sign in the whole CNF file instead of underline ? no, i think it depends the option configured (..a bit confusing, I know) Gabriel -- MySQL Gene

Re: Underline or minus sign ?

Gabriel PREDA wrote: I'm going to start the InnoDB engine... and I want to know if the syntax for the CNF file unified at last ? Can I use: innodb-file-per-table no instead of innodb_file_per_table ? this one (at least for 4.1.11) [This is just an example] Can I use only minus sign i

Re: Underline or minus sign ?

No one ? Please help me with this. Gabriel - Original Message - From: "Gabriel PREDA" <[EMAIL PROTECTED]> Sent: Wednesday, May 04, 2005 4:36 PM Subject: Underline or minus sign ? > I'm going to start the InnoDB engine... and I want to know if the syntax for > t

Underline or minus sign ?

I'm going to start the InnoDB engine... and I want to know if the syntax for the CNF file unified at last ? Can I use: innodb-file-per-table instead of innodb_file_per_table ? [This is just an example] Can I use only minus sign in the whole CNF file instead of underline ? Ga

RE: Plus sign doesn't concatenate strings in MySQL?

At 20:32 -0500 1/15/05, Dave Merrill wrote: Let me ask a slightly different question: Is there a string concatenation operator in mysql when it's *not* running in ansi mode? Or is the only way to accomplish that to use CONCAT? I think I'm hearing that there is no operator, only CONCAT. Right? Right

RE: Plus sign doesn't concatenate strings in MySQL?

Let me ask a slightly different question: Is there a string concatenation operator in mysql when it's *not* running in ansi mode? Or is the only way to accomplish that to use CONCAT? I think I'm hearing that there is no operator, only CONCAT. Right? Dave Merrill -- MySQL General Mailing List

RE: Plus sign doesn't concatenate strings in MySQL?

Um, I know that probably seemed a bit random, but I got a msg from someone saying that was how it worked; it certainly wasn't something I thought, hence the '???'. Your reply leads me to believe that was a private email not sent to the list. Dave Merrill > >??? > > > >SELECT 'asdf' . 'qwer' > > >

Re: Plus sign doesn't concatenate strings in MySQL?

Starting with 4.0, MySQL can be made to respect the standard of || as the concatenation operator with the PIPES_AS_CONCAT sql-mode. You may want to read section 1.5, "MySQL Standards Compliance", in the manual . There are some options to m

RE: Plus sign doesn't concatenate strings in MySQL?

At 8:51 -0500 1/15/05, Dave Merrill wrote: ??? SELECT 'asdf' . 'qwer' ...gives "Error Code : 1064, You have an error in your SQL syntax..." I also can't find any reference to this use of periods in the docs. Mostly we document how MySQL works, not all the things that you could possibly try that won

Re: Plus sign doesn't concatenate strings in MySQL?

At 18:04 +0100 2005/01/15, Jochem van Dieten wrote: On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote: Each language is going to have its own personality. If they all did things the same way, we wouldn't have the wealth of different ones to choose from. DBMS's are not languages, they a

Re: Plus sign doesn't concatenate strings in MySQL?

On Sat, 15 Jan 2005 11:37:02 -0500, Dave Merrill wrote: > > This is my first foray into different flavors of sql, and I'm discovering > how incompatible they really are. I expected that core basics would be the > same, with each manufacturer adding some proprietary extensions, and failing > to sup

Re: Plus sign doesn't concatenate strings in MySQL?

Jochem van Dieten wrote: On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote: Each language is going to have its own personality. If they all did things the same way, we wouldn't have the wealth of different ones to choose from. DBMS's are not languages, they are implementations. Might no

Re: Plus sign doesn't concatenate strings in MySQL?

On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote: > > Each language is going to have its own personality. If they all did > things the same way, we wouldn't have the wealth of different ones to > choose from. DBMS's are not languages, they are implementations. > Might not be a good i

RE: Plus sign doesn't concatenate strings in MySQL?

As I said in my msg, I found out that I was wrong, '+' isn't ANSI, it's just microsoft. But mysql doesn't support the ANSI standard '||' either. Go figure... This is my first foray into different flavors of sql, and I'm discovering how incompatible they really are. I expected that core basics wou

Re: Plus sign doesn't concatenate strings in MySQL?

At 07:37 -0500 2005/01/15, Dave Merrill wrote: I thought string concatenation w '+' was totally standard SQL. Hmmm, this is the first I've heard of "+" being used for concatenation (in SQL). Then again, I've never used MS SQL Server. :-) Each language is going to have its own personality. If th

RE: Plus sign doesn't concatenate strings in MySQL?

??? SELECT 'asdf' . 'qwer' ...gives "Error Code : 1064, You have an error in your SQL syntax..." I also can't find any reference to this use of periods in the docs. Have you tried it? Can you point me to something that says it ought to work? BTW, I'm trying this w mysql 4.1.7-nt-max on win2k, i

Plus sign doesn't concatenate strings in MySQL?

I'm just starting to look at MySQL, been working w SQL Server. I just noticed that in MySQL, you can't concatenate strings with '+', like you can in SQL Server. In other words, in SQL Server SELECT 'asdf' + 'qwer' gives 'asdfqwer', but in MySQL, it gives 0. For MySQL, you seem to have to u

Sign

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

MySQL garbles some UTF-character such as capital swedish oe or cyrillic soft sign

>Description: The UTF-8 encoding for capital swedish characters ae aa and oe doesn't work. Some cyrillic characters doesn't work either. A lot of other utf-encoded characters work so the settings are not wrong. It seems like mysql looses some information when it stores these characters. At first

63 LSB ok but bit 64 is sign bit

mysql> select -> 0x+0 AS '18446744073423220462', -> 0x7fff+0 AS '9223372036568444654 ', -> 0x8fff+0 AS '10376293541175291630' ; +--+--+--+ | 18446744073423220462 | 9223372036568

Re: Euro sign & mysql

The html symbol for euro sign is: "€" (without quots) if that helps. Is it neccecery to insert it in the database? --- Derk van der Harst <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hello everyone, > > how can I insert records with

RE: Euro sign & mysql

Using the mysql client. thx Derk > On Monday 02 September 2002 09:27 am, Derk van der Harst wrote: > > Hello everyone, > > > > how can I insert records with the Euro sign into the mysql database? > > When i try to insert the euro sign i get the err message '

Re: Euro sign & mysql

On Monday 02 September 2002 09:27 am, Derk van der Harst wrote: > Hello everyone, > > how can I insert records with the Euro sign into the mysql database? > When i try to insert the euro sign i get the err message 'query is empty'. > Can somebody help? > > tha

Euro sign & mysql

Hello everyone, how can I insert records with the Euro sign into the mysql database? When i try to insert the euro sign i get the err message 'query is empty'. Can somebody help? thanks Derk - Before posting, pl

Re: Mysql SQL behaviour with a plus sign

In the last episode (Jun 07), [EMAIL PROTECTED] said: > It looks like mySQL is funny about a + next to a - in a string. > > > If I do select count(*) from Table where Column like '%+---%' > I get 0 records. > If I do select count(*) from Table where Column like '%---%' > I get 70652 records. >

Mysql SQL behaviour with a plus sign

It looks like mySQL is funny about a + next to a - in a string. If I do select count(*) from Table where Column like '%+---%' I get 0 records. If I do select count(*) from Table where Column like '%---%' I get 70652 records. How can I make it insensitive to a +- Thanks in advance. Piyush.

Re: User Sign-up/Log-in

On Wed, May 30, 2001 at 11:20:02PM -0400, Randall Fitzgerald wrote: > I am just wondering about the code to do a query for a string and > then see if that string exists or not. like finding the string for > $user in a DB when $user would be inserted into a table named users > as username to see

User Sign-up/Log-in

Hi, I am just wondering about the code to do a query for a string and then see if that string exists or not. like finding the string for $user in a DB when $user would be inserted into a table named users as username to see fi it is used or not.

[philb@gnu.org: Bug#88186: mysql: Fails to build on ARM: char sign issue?]

Hi Hope this helps you to make mysql working on ARM architecture, too. bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner -

[hazelsct@mit.edu: Bug#88186: mysql: Fails to build on ARM: char sign issue?]

stent **, int *)' make[4]: *** [mini_client.o] Error 1 make[4]: Leaving directory `/redhat/packages/mysql-3.23.33/sql' Looks like it might be a char sign issue. ARM defaults to unsigned char (as does PPC). Does a "signed" or "unsigned" need to go in front of "ch

VIRUS FOUND Re: escape character for # sign?

Attention, the original message of Funky Gao and following replies contain the virus W32.Navidad.16896 Antonio

escape character for # sign?

How can I escape the mysql comment # character in sql statements? Thanks, Doug Sherman Emanuel.exe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Re: escape character for # sign?

IL PROTECTED]] > Sent: Thursday, October 12, 2000 2:43 PM > To: [EMAIL PROTECTED] > Subject: escape character for # sign? > > How can I escape the mysql comment # character in sql statements? > > Thanks, > > Doug Sherman > > -- > ---