Dear All,
I'm trying to create a regular expression query to match phone numbers
in a database field.
My issue is this , the numbers have no set standard for input in the db.
So the number in the db could be in multiple formats.
EX:
333.333.
(333)333-
333-333-
33
So I am
Hi all,
I am setting up a mysql server for running reports. Which engine (innodb or
myisam) will be better. Only select will be done on the mysql server. Some
of the tables have more than 5 millions records.
--
Krishna Chandra Prajapati
MySQL DBA,
Mob: 9912924044
Email-id: [EMAIL PROTECTED]
Hi,
Seems to work! But the number is a zero you have to add an extra escape:
(\\0+\3+\\0+\9+)
or you get ERROR 1139 (42000): Got error 'parentheses not balanced' from regexp
Thank you!!
Paul
- Original Message
From: Bartis, Robert M (Bob) [EMAIL PROTECTED]
To: Paul Nowosielski
I have the table 'test' which includes two columns: 'study' and 'symbol':
study symbol
a2008 A
a2008 B
a2008 C
a2008 D
b2005 A
b2005 B
b2005 E
The task is to perform an intersection on 'name' column according to all
distinct values in 'study' column. During the experiments the
intersection
On 12/01/2008 08:30 AM, Andrej Kastrin wrote:
I have the table 'test' which includes two columns: 'study' and 'symbol':
study symbol
a2008 A
a2008 B
a2008 C
a2008 D
b2005 A
b2005 B
b2005 E
The task is to perform an intersection on 'name' column according to
all distinct values in
Hello,
I am trying to plan we in advance our methods for backup and recovery
of our new MySQL replication cluster. After doing some research it
looks like a lot of people are using LVM snapshots as their backup
solution. We currently have two MySQL servers with 2 300 GB (Raid 1).
What I
The task is to perform an intersection on 'name' column according to
all distinct values in 'study' column.
Did you try ...
SELECT DISTINCT a.symbol
FROM test as a
JOIN test as b ON a.symbol=b.symbol
WHERE a.study b.study;
PB
-
Andrej Kastrin wrote:
I have the table 'test' which
Monty Widenius (MySQL co-founder who recently left Sun), on the other
hand, doesn't cast a very favorable light on 5.1 for production use.
Good read:
If you plan to use any of the new features of MySQL 5.1, regard
these as if they would be of beta quality.
On 12/1/08, Daevid Vincent [EMAIL PROTECTED] wrote:
Monty Widenius (MySQL co-founder who recently left Sun)...
What's the news on this?
David
Do a quick google search for Monty Widenius left sun and behold...
On Mon, 2008-12-01 at 13:45 -0600, David Giragosian wrote:
On 12/1/08, Daevid Vincent [EMAIL PROTECTED] wrote:
Monty Widenius (MySQL co-founder who recently left Sun)...
What's the news on this?
David
I have a table with a memo field, and I want to build a table of all words
used in all rows of that memo field.
Suggestions?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Thanks. Just finished the blog, and I think I'm getting the drift.
On 12/1/08, Daevid Vincent [EMAIL PROTECTED] wrote:
Do a quick google search for Monty Widenius left sun and behold...
On Mon, 2008-12-01 at 13:45 -0600, David Giragosian wrote:
On 12/1/08, Daevid Vincent [EMAIL PROTECTED]
This one was complicated but here is what you want and the three different sets
of test data to prove it (cut and paste this code as is into MySQL and see the
desired results):
USE test
DROP TABLE IF EXISTS SCHOOL;
CREATE TABLE SCHOOL (study VARCHAR(10),symbol CHAR(1), KEY StudySymbolIndex
I currently have an application that runs on MySQL 4.0.12. I'd like to
update it to the newest version of MySQL so I can have multiple applications
using the one database. However, I'm running into some permissions
problems.
When I install MySQL 4.0.12 I set up an administrator user. Then I
Hi Bai,
I think the best option is to read carefully the installation guide,
there are some post installation steps to set up initial privileges,
and everything is explained quite well.
After that if you still have problems please provide more informations
on platform and other points
like the
Hi Bai,
In case you want the privileges of the old system, please take a backup of
the mysql database as inserts and reimport the same in the upgraded server.
If you want a new admin user to be created, then
please check the below page for the syntax:
[EMAIL PROTECTED] (Shain Miley) writes:
I am trying to plan we in advance our methods for backup and recovery
of our new MySQL replication cluster. After doing some research it
looks like a lot of people are using LVM snapshots as their backup
solution. We currently have two MySQL servers
17 matches
Mail list logo