Re: expire_logs_days

Paul DuBois wrote: At 8:46 PM -0400 5/2/07, Baron Schwartz wrote: Ofer Inbar wrote: That's a good point, though probably a minor one: At most you would end up with one binary logfile that's old and not deleted. As soon as you create a new one, that one would be deleted (if this feature

Enforcing Data Format

Hello, Is it possible to enforce data formatting in fields using something like a regular expression? varchar is great but does not stop someone putting in the wrong reference number. I suspect the answer is no, you have to do it at a higher level. What aprroach would people suggest? Perhaps

Re: Enforcing Data Format

Hi, Tim Milstead wrote: Hello, Is it possible to enforce data formatting in fields using something like a regular expression? varchar is great but does not stop someone putting in the wrong reference number. I suspect the answer is no, you have to do it at a higher level. What aprroach

Re: Enforcing Data Format

Baron Schwartz wrote: Hi, Tim Milstead wrote: Hello, Is it possible to enforce data formatting in fields using something like a regular expression? varchar is great but does not stop someone putting in the wrong reference number. I suspect the answer is no, you have to do it at a higher

Re: Enforcing Data Format

Is it possible to enforce data formatting in fields using something like a regular expression? varchar is great but does not stop someone putting in the wrong reference number. Dates should be in a DATE column, not a varchar. I suspect the answer is no, you have to do it at a higher

RE: Enforcing Data Format

Is it possible to enforce data formatting in fields using something like a regular expression? varchar is great but does not stop someone putting in the wrong reference number. Dates should be in a DATE column, not a varchar. The OP says 'data' not 'date' :) He is talking about a

Less | More

Is there a mysql command line equivalent to | less or | more to make it easier to scan rows one screen at a time? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Urgent: mysql_history on windows ?

Hi, I need to track the mysql commands executed on mine system , I am running windows with mysql 5.x I know there is a file .mysql_history and hopes there must be a similar file on windows too. Pl. help me urgently, Thanks, -- Regards, Abhishek Jain

Re: Enforcing Data Format

Is it possible to enforce data formatting in fields using something like a regular expression? varchar is great but does not stop someone putting in the wrong reference number. Dates should be in a DATE column, not a varchar. The OP says 'data' not 'date' :) He is talking

Re: Less | More

John Kebbel wrote: Is there a mysql command line equivalent to | less or | more to make it easier to scan rows one screen at a time? Type ? from within the command-line client to see help. One of the lines shows this: pager (\P) Set PAGER [to_pager]. Print the query results via

Re: Less | More

Thank you, gentlemen. From the little I had read about pager so far, I assumed it had something to do with outputting to a text file. First chance I get, I'll read up on pager in detail. On Thu, 2007-05-03 at 12:39 +, [EMAIL PROTECTED] wrote: at your friendly mysql command-line prompt enter

Re: Enforcing Data Format

I'd go the other way and use a trigger to validate the data, and roll back the transaction if it isn't in valid format (assuming you are using transactions). This way, ANY app that puts data in that field gets the validation. An error in an application or typing by someone who has direct table

Seeking a MySQL DB Guru for Project/Partner!!

Hi. We're creating a startup team for creating web based apps/services. The goal is to create business that's initially Sweat Equity based. For those of you not familiar with the term, this means that there will not be any initial compensation/salary, just the thrill of working with some really

Re: Enforcing Data Format

I'd go the other way and use a trigger to validate the data, and roll back the transaction if it isn't in valid format (assuming you are using transactions). This way, ANY app that puts data in that field gets the validation. An error in an application or typing by someone who has direct

RE: Less | More

There is no \P command in the Windows version of MySQL (as of 4.x). It would be a nice addition, since there is a more command in the Windows CLI, but I'm not sure how (or if) the piping can be set up in Windows. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave.

Bin logs...

Probably a silly question, but if I have my logs set to binary, how can I read them and check on a query that's failing? I don't necessarily want to switch to text logs because we'll want to do replication soon here, so I want to keep it as a binary log. My problem is I have a query

Re: Bin logs...

Ashley M. Kirchner wrote: Probably a silly question, but if I have my logs set to binary, how can I read them and check on a query that's failing? I don't necessarily want to switch to text logs because we'll want to do replication soon here, so I want to keep it as a binary log. My

RE: Less | More

-Original Message- From: John Kebbel [mailto:[EMAIL PROTECTED] Sent: Thursday, May 03, 2007 7:34 AM To: MySQL Subject: Less | More Is there a mysql command line equivalent to | less or | more to make it easier to scan rows one screen at a time? I have the command: pager=less

Order By and Ignore Punctuation

I would like to perform a query of a personnel database with an ORDER BY clause that ignores punctuation. For example, O'shea would sort after Osbourne, not to the beginning of the Os. Is this doable in the query? -= Bill =- -- You can tell a lot about a man by the way

Re: expire_logs_days

Mark Leith wrote: Paul DuBois wrote: At 8:46 PM -0400 5/2/07, Baron Schwartz wrote: Ofer Inbar wrote: That's a good point, though probably a minor one: At most you would end up with one binary logfile that's old and not deleted. As soon as you create a new one, that one would be deleted (if

Re: Order By and Ignore Punctuation

Hi, Bill Guion wrote: I would like to perform a query of a personnel database with an ORDER BY clause that ignores punctuation. For example, O'shea would sort after Osbourne, not to the beginning of the Os. Is this doable in the query? If you only have a limited number of punctuation

Can't find file: 'general_log'

Hi, I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the data directory of MySQL. I updated everything that SELinux complained about, etc., and have a functional install of MySQL. It's actually been up and running with no issues for months. However, every time I run a

Re: expire_logs_days

At 9:55 PM -0400 5/3/07, Baron Schwartz wrote: Mark Leith wrote: Paul DuBois wrote: At 8:46 PM -0400 5/2/07, Baron Schwartz wrote: Ofer Inbar wrote: That's a good point, though probably a minor one: At most you would end up with one binary logfile that's old and not deleted. As soon as you

RE: Order By and Ignore Punctuation

I would suggest you order by something that includes a fulltext index on the specific column. Maybe check out the documentation on the MATCH()AGAINST() systax as well as fulltext searches in general. For example: SELECT Col1, Col2, Score AS MATCH(TextCol) AGAINST () WHERE ... ORDER BY Score;