Re: Query to find foo within (foo)

Thank you Michael for your answer. On 9/19/07, Michael Dykman [EMAIL PROTECTED] wrote: The whitespace counts... try LIKE '%johnie%' (or better '_johnie_' .. the underscorematches any single character). I want to match '(johnie)' and not 'johnies' or 'aljohnier', what it's the query does with

Re: Query to find foo within (foo)

Thank you Chris for your answer. On 9/19/07, Chris Sansom [EMAIL PROTECTED] wrote: Well I'm hardly the world's greatest expert, but I'm curious as to why you're always separating '%' from 'johnie' with a space, because that way it will only find Johnie if he has a space before or after him

Re: Query to find foo within (foo)

If you need something more complicated, such as only ignoring (, then you need to get more complicated. You might even need a regular expression. I'm to browse: http://dev.mysql.com/doc/refman/5.0/en/regexp.html http://www.wellho.net/regex/mysql.html Thank you very much! Regards, Jerry

Falcon and Foreign Key Constraints

Hi, I thought that Falcon supported FKs, but in my test, it doesn't? Can someone confirm this? Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/

Re: Falcon and Foreign Key Constraints

On Thu, Sep 20, 2007 at 11:20:19AM +0200, Martijn Tonies wrote: I thought that Falcon supported FKs, but in my test, it doesn't? Can someone confirm this? The Falcon storage engine does not currently support foreign keys. (The underlying engine does have support for them, but this

Re: Falcon and Foreign Key Constraints

On Thu, Sep 20, 2007 at 11:20:19AM +0200, Martijn Tonies wrote: I thought that Falcon supported FKs, but in my test, it doesn't? Can someone confirm this? The Falcon storage engine does not currently support foreign keys. (The underlying engine does have support for them, but this

log files and upgrading

Is it possible to log information to the general log file only for a specific database? We are currently running MySQL 4.0.15. We are planning on moving to a new server so and will upgrade MySQL. What is the latest most stable version that is recommended? Thanks for any information. --

Re: Query to find foo within (foo)

thomas Armstrong wrote: If you need something more complicated, such as only ignoring (, then you need to get more complicated. You might even need a regular expression. I'm to browse: http://dev.mysql.com/doc/refman/5.0/en/regexp.html http://www.wellho.net/regex/mysql.html You know, you

RE: Query to find foo within (foo)

If you want to match only (johnie) or johnie , then you could use a regular expression test. They can get as complicated as your brain will tolerate. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX:

Query to find less than 3 char string

Just wondering if anyone out there may have a workaround to being stuck on a shared server with the default string matching set to more than 3 chars. I know that Navicat searches for 3 and under chars on my catalog when it's connected and that offered me some form of hope. On top of that I'm

Trigger COMMENT question

Hey all, Is there any way to add a COMMENT to a trigger like for a stored proc. Ideally it would be the same mechanism like for the stored proc but other options are welcome too. I basically need this for a tool that I am writing that outputs everything about a database that is available

Re: log files and upgrading

I don't think there is any way to lock down the general log to a single database.. perhaps if you tell us what you are trying to accomplish, we might be able to propose something.. As of today, 5.0.45 is the recommended install version. http://dev.mysql.com/downloads/mysql/5.0.html -

RE: Query to find less than 3 char string

Pain in the neck when you can't find the word red in a catalog. I know the problem. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com

temporary tables on disk?

according to http://dev.mysql.com/doc/refman/4.1/en/internal-temporary-tables.html temporary tables can sometimes be written to disk as myisam. in replication are these myisam temp tables sent to the slaves as myisam tables or in memory tables? -- MySQL General Mailing List For list

Re: temporary tables on disk?

Temporary tables only exist for the length of time that the connection that created them remains connected and are only visible to that connection. There is no reason to replicate these to a slave at all, as no client connecting to that slave would ever be able to see them. - michael dykman

Re: temporary tables on disk?

Michael explained it well, but just to say it a different way, the temporary table is created as an intermediate step in the table, and is implicit, not explicit. So it's not sent to the slave -- the query is sent to the slave, and if the query optimizer makes the same decisions on the slave

MYCNF

Hi All, I am working on the mysql tuning (my.cnf). I would like to know that, if the parameters of mysql are too high or uneven. Then what is the impact on mysql. Whether mysql can crashed or what else. There is any tool or script which can show how much ram is being utilised. Thanks, Krishna