In the last episode (May 12), Ferindo Middleton said:
> Suppose you have a field in a db table that holds email addresses and all of
> the address end in domain.com. Is there a MySQL function that can be used to
> extract the first part of the email address, the username (the part of the
> email ad
Why not store them in separate columns? You could then have the domain
field be a foreign key into another table.
-Original Message-
From: Ferindo Middleton [mailto:[EMAIL PROTECTED]
Sent: Friday, May 12, 2006 2:14 PM
To: mysql@lists.mysql.com
Subject: how to extract common text string f
Check the string functions SUBSTRING and LOCATE. As a hint look for the
position of '@'.
Ferindo Middleton escribió:
Suppose you have a field in a db table that holds email addresses and
all of
the address end in domain.com. Is there a MySQL function that can be
used to
extract the first part
Suppose you have a field in a db table that holds email addresses and all of
the address end in domain.com. Is there a MySQL function that can be used to
extract the first part of the email address, the username (the part of the
email address before the 'domain.com' part of the email address).
I
Hi Sheeri
No, I wanted to search through both columns in the same time (and it
will be always at the same time) - the problem was I didn't know that I
have to have one multi-column index.
:)
But, it's fixed (after really helpful comments on this mailing list) and
works perfect
:)
Thanks to
On 5/12/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
So, our MySQL master database crashes about once a week, then
immediately recovers. We are running a Dell 2850 -- 64-bit Fedora Core
3 box with 6G of memory, 4 Intel Xeon processors, at 3.60 GHz speed
each (says /proc/cpuinfo), each cpu cache
So, our MySQL master database crashes about once a week, then
immediately recovers. We are running a Dell 2850 -- 64-bit Fedora Core
3 box with 6G of memory, 4 Intel Xeon processors, at 3.60 GHz speed
each (says /proc/cpuinfo), each cpu cache size is 2048 Kb. It
replicates to 2 slaves, which have
Hi Dan,
You never really say what your memory problems are. Is MySQL crashing
because you're trying to use too much memory?
more comments inline
On 5/11/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
What I'm dealing with here is memory problems using MySQL 5.0.19 under
FreeBSD. Although I'
I'm going to guess that the path variable is only looking at the MySQL
3.23 mysqld binary. Try using a full path to the MySQL 5.0.20 binary
and see if you still get errors.
-Sheeri
On 5/10/06, Miles Thompson <[EMAIL PROTECTED]> wrote:
I am trying to install two MySQL servers to run as Windows
See response below:
On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
It looks like today is my day! :)
I FULLTEXT indexed my table "products":
CREATE TABLE `products` (
`prod_id` int(8) unsigned NOT NULL auto_increment,
`prod_no` varchar(50) NOT NULL default '',
`prod_name` varcha
I'm sorry but I think you're all making this more complicated than it needs
to be.
I could easily write a Java program that obtained a result set, then
processed that set in almost any way you wanted, including two records at a
time. I could probably do the same in Perl or any other language s
I ran into this same type of question the other evening at a local
linux group.
I think that once you reach the end of the results set the only way to
start back at the beginning of that results set is to do the query
again.
Once option - do your query and grab all the rows
load them into a dat
> Is there a way I can get a set of records incrementally such as to get 2
> then the next query get the next 2 then at the end of all records to get the
> 2 from the beginning? I need to keep going incrementally by 2 in a circle.
I don't know any way to do this directly with SQL, but I could be w
On Fri, 2006-05-12 at 10:59 -0400, RV Tec wrote:
> Yeah, I'm aware of that. Since glibc 2.4 has only NPTL, I was
> wondering if it
> is possible to MySQL use a threading system of its own. However, what
> I want to
> know, is a way to confirm that it has been compiled against NPTL.
>
> This appe
Well, basically it can be done to an extent in some kind of code. Basically
I am drawing from a table 2 records at a time. I want to make sure that all
records are pulled at least once. If at all possible not to have 2 from the
same vendor.
So, in this case.
I have columns id, html, vendor
So I
Hey folks I'm trying to crate a view that runs a stored procedure. Can
anyone tell me what I might be doing wrong or if what I'm trying it
possible?
Here is what I get:
mysql> create view v as CALL flatscore(6,2);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that
co
- Original Message -
From: "Steffan A. Cline" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 12, 2006 1:38 PM
Subject: Returning records in a circle
Is there a way I can get a set of records incrementally such as to get 2
then the next query get the next 2 then at the end of all records
Is there a way I can get a set of records incrementally such as to get 2
then the next query get the next 2 then at the end of all records to get the
2 from the beginning? I need to keep going incrementally by 2 in a circle.
Thanks
Steffan
--
sheeri kritzer wrote:
Hi Amer,
Indeed, the 'func' table in the 'mysql' database has the same
structure that you found in your client database. in your upgrade,
did something go wrong and you did a mysqldump of the mysql database
and reimport? Are you sure you're in the right database? What do
I diagree on point 1. If you warn your members that their password is
insecure, and if you e-mail out passwords anyway, there's no reason
not to have a secure password. Many people I know use an insecure
password for many things, from silly required free registration sites
(go ahead, break into
http://www.ncb.ernet.in/education/modules/dbms/SQL99/
-Sheeri
On 5/10/06, Peng Yi-fan <[EMAIL PROTECTED]> wrote:
hi,
does anyone know where to download ISO-SQL-99?
PDF is best.
thanks
Pang
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
MySQL's pretty good when it describes an error. (if the error message
is vague you might be screwed, but MySQL is pretty good).
Which means:
1) You didn't properly change the max_allowed_packet on the master.
what does show variables like "max_allowed_packet"; show you?
2) The slave is actu
Hi Amer,
Indeed, the 'func' table in the 'mysql' database has the same
structure that you found in your client database. in your upgrade,
did something go wrong and you did a mysqldump of the mysql database
and reimport? Are you sure you're in the right database? What does
describe mysql.func
I worked on a system years ago that used "binary encoded" integer for
latitude & longitude.
The Most Significant Bit (MSB) was a sign bit ( + or -).
The next bit was 180 degrees
The next bit was 090 degrees
The next bit was 045 degrees.
etc
Functions were written to transform these into human read
Not particularly. You're not buying an upgrade, you're buying a
license for a new product. You can use MySQL all you want for free,
you just can't repackage or embed it without a license.
I don't see it as an upgrade issue really. You'll want to rewrite
many queries, add new features, etc to g
Hi,
MySQL 4.0.27, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/mysql/4.0.html
http://downl
The courses MySQL offers are excellent. Perhaps good courses to take
would be the MySQL DBA or Developer Certification Tutorials, and then
take the certification tests. http://www.mysql.com/training/ I've
taken their courses and have only good things to say.
-Sheeri
On 5/12/06, Barry <[EMAIL
I'll add "make sure logs and data are on separate partitions" so
you're not doing excessive seeking back and forth.
-Sheeri
On 5/12/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
Hope it is useful.
I agree, you may want to look at adding another card and disks, for
speed and to segregate the vari
Well, that clears things up on my end. I was confused as to how a
SELECT statement produces "updatable results" because SELECT just
gives output. Go into MySQL on the commandline and see if
Select * from vwMyView
and
Select * from vwMyView ORDER BY Name
produce the same results, just in a di
It looks like MySQL installed but when it tried to start the server,
the server crashed. Can you confirm that?
If so, try starting it with the startup script -- you should get the
same error. If it's still broken, start it with the core-file and
core-file-size option (I recommend unlimited):
h
On 5/11/2006 9:17 AM Fan, Wellington wrote:
Damn, I really didn't mean to use that subject line; Sorry all!
Nor should you reply to a message when starting a new thread. It screws
up the threading whether or not you change the subject. Please start
all new threads with a new message.
Tha
http://www.devshed.com/c/a/MySQL/A-Technical-Tour-of-MySQL/
The MySQL server has it built in.
-Sheeri
On 5/8/06, Jim <[EMAIL PROTECTED]> wrote:
Hi All,
Didn't know there was an "optemizer" for mySQL.
Where can I get it from?
Thanks
Jim
Best regards,
Jim Clark
Project Manager
Mu
Dobromir,
As I said in my first message (see the message quoted below), MySQL
could use up to 4.991913 G of memory. So you could use more than 4GB.
Check out the calculation below. Also read the rest of my message,
regarding thread size, the manual page for crashing, max_connections,
slow query
Hi Jesse,
Have you tried the following:
1) ordering by only part.d and seeing how long the query takes
2) putting an index on (part.d, cwGroup.stripped_cw) and seeing how
long the query takes.
1 will help pinpoint the problem, and 2 might actually help.
-Sheeri
SELECT part.d, quotation.qt,
Hey Sheeri. Thanks again for the response.
I do agree that this is a known problem with SQL Server. My problem is that I
am using a Windows Visual Basic application to access a Linux based MySQL
Server via MyODBC/Connector. There is no longer SQL Server in the loop. I
believe this is a Mic
Hope it is useful.
I agree, you may want to look at adding another card and disks, for
speed and to segregate the various operations (temp, logging, data).
Splitting up your MYD and MYI files may help, though if you have enough
RAM to keep indexes in memory, maybe you don't need to do that.
On 5/12/06, RV Tec <[EMAIL PROTECTED]> wrote:
Buettner,
First of all, thanks a lot for your reply!
This server has 4 disks to MySQL usage, in two pairs of RAID-1, connected
to a single channel (ok, I realize now this means a bottleneck) LSI
PCIe card.
One RAID1 for MySQL logging and temp space
Good morning RV -
On your 3rd question, about how to make things faster:
More RAM should help by allowing the server to keep more/all of the
indexes in memory, enabling much faster access. Be sure to adjust the
cache settings in your my.cnf file after adding RAM. (Keep in mind -
some my.cnf
abhishek jain schrieb:
Hi all,
I have been using mysql from last few years but for small projects only,
recently i have been on to some good projects, I want toknow what is the
best coding practices for mysql to kee it fast etc.
I mean in mine earlier post one friend told me that size upto 4 GB c
That's a problem with SQL Server -- google search on your error and
you'll see that that's associated with SQL server, not MySQL.
-Sheeri
On 5/11/06, Eland, Travis M. <[EMAIL PROTECTED]> wrote:
Thanks for the response! Unfortunately, it is that simple.
A basic "Select * from vwMyView" yields
1) Is there a way to see MySQL using both processors? Is SMP helpful in
this case? (This server is dedicated to MySQL, only one instance).
PS (*nix) should tell you how your processors are used.
PS does show me about the CPU usage, but it doesnt tell me which
processor, or if they're being use
Buettner,
First of all, thanks a lot for your reply!
This server has 4 disks to MySQL usage, in two pairs of RAID-1, connected
to a single channel (ok, I realize now this means a bottleneck) LSI
PCIe card.
One RAID1 for MySQL logging and temp space, and the other pair for the
database files
Hi all,
I have been using mysql from last few years but for small projects only,
recently i have been on to some good projects, I want toknow what is the
best coding practices for mysql to kee it fast etc.
I mean in mine earlier post one friend told me that size upto 4 GB can be
achieved with Mysq
Stephen Cook wrote:
There are such things as extensions to the standard, and many
languages besides BASIC that have the ability to output a character
string. No need to be snippy.
The preference expressed is to that SQL not be bowdlerised into
Microsoftese.
PB
-
I will look into the --
This is an Access problem; you'll need to find folks who know access to fix it.
Try:
http://www.tek-tips.com/viewthread.cfm?qid=1146857&page=1 ??
-Sheeri
On 4/26/06, Daevid Vincent <[EMAIL PROTECTED]> wrote:
I have a critical problem that I hope there is a simple solution for.
I've just spen
We use float. I have no idea if that's better or worse, but that's what we use.
-Sheeri
On 4/26/06, René Fournier <[EMAIL PROTECTED]> wrote:
Just curious the majority use. I've been using decimal(18,14), but
that appears bigger than necessary... Maybe varcar(21) for latitude,
and varchar(22) f
RV Tec schrieb:
Folks,
I had some recommendations about operating system last time I posted,
and decided to follow it. It's been a couple of weeks running Gentoo
Linux 2006.0 SMP 2.6.15-gentoo-r5, with glibc 2.4 (NPTL), gcc 3.4.4, XFS
as my FS, deadline scheduler and this has proven to be rea
Checking. I don't think the customer bought the "network" version.
Apparently its MySQL Pro Licence V4.
It's a bit rich not to offer upgrades at a discount IMO.
Adam
-Original Message-
From: David Logan [mailto:[EMAIL PROTECTED]
Sent: 12 May 2006 11:52
To: Adam Lipscombe
Cc: 'MySQL
Folks,
I had some recommendations about operating system last time I posted, and
decided to follow it. It's been a couple of weeks running Gentoo Linux
2006.0 SMP 2.6.15-gentoo-r5, with glibc 2.4 (NPTL), gcc 3.4.4, XFS as my
FS, deadline scheduler and this has proven to be really stable -- MyS
Adam Lipscombe wrote:
Folks,
We have a commercial product that uses mysql 4.0.24. We bought a commercial
licence for this version.
We want to upgrade to 5.0.21.
I spoke with the MySQL saleswoman this morning and she says they don't do
upgrades and want another entire licence fee for v5.x.
Folks,
We have a commercial product that uses mysql 4.0.24. We bought a commercial
licence for this version.
We want to upgrade to 5.0.21.
I spoke with the MySQL saleswoman this morning and she says they don't do
upgrades and want another entire licence fee for v5.x.
Does anyone else have ex
Stephen Cook wrote:
There are such things as extensions to the standard, and many
languages besides BASIC that have the ability to output a character
string. No need to be snippy.
I will look into the --silent option, thanks!
I also tend to use -BN with these kind of scripts:
mysql -u use
There are such things as extensions to the standard, and many languages
besides BASIC that have the ability to output a character string. No
need to be snippy.
I will look into the --silent option, thanks!
Peter Brawley wrote:
Stephen Cook wrote:
I appreciate it but SELECT isn't quite what I
53 matches
Mail list logo