Re: REGEXP help Finding phone numbers (nnn) nnn-nnnn format SOLVED

This seems to do it: SELECT phone_work FROM leads WHERE phone_work REGEXP '[(]{1}([0-9]){3}[)]{1}[ ]?([^0-1]){1}([0-9]){2}[ ]?[-]?[ ]?([0-9]){4}' - Original Message From: Paul Nowosielski [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, December 3, 2008 2:39:54 PM

mysql5.1.30 not have the correct english/errmsg.sys？

when I start mysql 5.1.30 up it fails to startup,the error info is: *[ERROR] Error message file '/usr/local/mysql/share/english/errmsg.sys' had only 617 error messages, but it should contain at least 619 error messages. Check that the above file is the right version for this program!* I setup

JOIN - Which and how?

Hi all, I'm having trouble figuring out how to construct a query and am hoping someone can help... I have three tables: Raw_materials +++---+ | raw_mat_id | name | count | +++---+ | 1 |

Re: JOIN - Which and how?

did u try this select * from raw_materials where raw_mat_id not in (select raw_mat_id from raw_materials__Products); On 12/3/08, Nigel Peck [EMAIL PROTECTED] wrote: Hi all, I'm having trouble figuring out how to construct a query and am hoping someone can help... I have three tables:

Re: JOIN - Which and how?

Ananda Kumar wrote: did u try this select * from raw_materials where raw_mat_id not in (select raw_mat_id from raw_materials__Products); Hi Ananda, Thanks for this, I'm really looking to do this in a single SELECT, for efficiency. I'm sure it's possible with a join but just not sure how.

Re: JOIN - Which and how?

Nigel Peck wrote: Ananda Kumar wrote: did u try this select * from raw_materials where raw_mat_id not in (select raw_mat_id from raw_materials__Products); Hi Ananda, Thanks for this, I'm really looking to do this in a single SELECT, for efficiency. I'm sure it's possible with a join but

Re: JOIN - Which and how?

Nigel Peck wrote: Sorry, make that: SELECT `Raw_materials`.`raw_mat_id`, `Raw_materials`.`name` FROM `Raw_materials` LEFT JOIN `Raw_materials__Products` ON `Raw_materials`.`raw_mat_id` = `Raw_materials__Products`.`raw_mat_id` WHERE

Solaris 10 bug with mysql_install_db

Description: running mysql_install_db does not correctly fill grant tables How-To-Repeat: run mysql_install_db; attempt to connect, fail. Fix: Edit #!/bin/sh to use **ANY OTHER SOLARIS SHELL** Submitter-Id: [EMAIL PROTECTED] Originator:Adam Thompson Organization:

Re: JOIN - Which and how?

The reason ur getting empty result set is becuase both tables have raw_mat_id (1,2). Insert a new record into raw_materials and not into raw_materials_product, then you would get the missing record. On 12/3/08, Nigel Peck [EMAIL PROTECTED] wrote: Nigel Peck wrote: Ananda Kumar wrote: did u

Re: REGEXP help Finding phone numbers (nnn) nnn-nnnn format

On Wednesday 03 December 2008 08:39:54 Paul Nowosielski wrote: Hi, Please, can anyone lend a hand in helping pullout phone numbers from the DB that only match the format (nnn) nnn- ? ([0-9]{3}) [0-9]{3}-[0-9]{4} I think HTH W SELECT phone_work FROM leads WHERE phone_work REGEXP

stored procedures embedded server

For embedded server do I need to configure --with-embedded-privilege-control? It looks like stored procedure is looking for mysql.proc table. Thanks.

OO base - jdbc - mysql timeout problem

I am trying to develop an db app w/ OO base as the front end to mysql db that is running on the web in a shared hosting environment using jdbc as the connector. The problem is if I let OO base sit for a few minutes it looses the connection to the db and I have to restart OO base to get it to

Re: OO base - jdbc - mysql timeout problem

If this is a web app, then it should be making a new connection every time a page is loaded (where applicable). At least that's how every PHP site I've ever made works... If this is a stand alone app, if your language has threads you could (hackily) have a thread that does some NO-OP every hour

Combining NDB, MySAM and InnoDB

Hi All,I need tom combine two ndb cluster db and one MyISAM db and one InnoDB db together using one mysqld demon, can anyone help me to build the my.cnf? ndb cluster details ndb node1 = 172.18.18.1 ndb node2 = 172.18.18.2 ndb_mdmd1 = 172.18.18.3 ndb_mdmd2 = 172.18.18.4 myisam db details

Query to Select records in the last 4 weeks

Hi, I get stuck to build a query to select records between curdate() and the last 4 weeks and groupped by week. I tested with: SELECT * FROM momtbak WHERE insertdate BETWEEN curdate( ) AND curdate( ) - INTERVAL 4 week It doesn't work. Please help, TIA. Willy Every why hath a wherefore. --

Re: Query to Select records in the last 4 weeks

On Thu, 2008-12-04 at 08:27 +0700, sangprabv wrote: Hi, I get stuck to build a query to select records between curdate() and the last 4 weeks and groupped by week. I tested with: SELECT * FROM momtbak WHERE insertdate BETWEEN curdate( ) AND curdate( ) - INTERVAL 4 week It doesn't

Re: Query to Select records in the last 4 weeks

Hi, Thanks for the prompt reply. I have tested yours and it seems to be working. What about to group the result by week? TIA. Willy Your life would be very empty if you had nothing to regret. -Original Message- From: Daevid Vincent [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc:

strange character while mirgation mysql db in arabic

Hi, I am having problem migrating a arabic vbulletin database from a remote server to my server, as it shows strange characters , or what we call charset or encoding issue and I have not been able to get past and fix it. On my server mysql show variables like 'char%' ;