Rory O'Connor writes:
I want to leave one record behind, but delete all other records that
have the same e-mail address. Is there a standard query for this or do
I need to write a script that will do it?
Getting a list of the duplicate rows is simple enough, but
deleting them requires a
On 31-Aug-2001 Greg Callaghan wrote:
Hi,
I have tables in which I use the mysql AutoIncrement facility to generate
a new ID when creating new rows.
What I typically do is to (a) create a new row and then (b) retrieve the
associated ID directly after this by using the SELECT ID FROM
Hi!
I am trying to compile mysql on one of our new servers. (RH 7.1)
Compilation stalles after these messages:
...
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... (cached) yes
checking for gawk... gawk
checking for gcc... gcc
checking whether the C
Hi!
mmokrejs == mmokrejs iso-8859-2 writes:
mmokrejs On Thu, 30 Aug 2001, Michael Widenius wrote:
mmokrejs Hi,
mmokrejs yes this patch *fixes* all of my problems, except one table which is/was
mmokrejs probably too big? I haven't found any options that would make myisamchk to
mmokrejs ask
On Thu, Aug 30, 2001 at 12:08:22PM -0700, [EMAIL PROTECTED] wrote:
Hi People,
I'm trying to execute this Simple query:
SET SQL_SAFE_MODE=0;
The server doesn't like it; However, SET any other option will work fine
except this one.
I'm still using mysqld v3.23.36 . If someone can
At 11:13 AM 8/30/01 +0200, Carl Troein wrote:
A quick question: How come the mailing list software
doesn't add a reply-to header? Is this intentional to
keep replies off the mysql list, and if so why?
I'll try to remember to reply to the list rather than
directly to the people who ask the
Hi
I was unable to write stored procedures in windows version of mysql. How
to write a stored procedures in winmysql version.
My mail id is [EMAIL PROTECTED] please mail if any one knows.
GSMurthy
-
Before posting, please
On Fri, 31 Aug 2001, Michael Widenius wrote:
mmokrejs == mmokrejs iso-8859-2 writes:
mmokrejs On Thu, 30 Aug 2001, Michael Widenius wrote:
mmokrejs Hi,
mmokrejs yes this patch *fixes* all of my problems, except one table which is/was
mmokrejs probably too big? I haven't found any
On 31-Aug-01, Claudio Cicali wrote:
There is also a famous document about reply-to:
http://www.unicom.com/pw/reply-to-harmful.html
Hmm.. good point, but it says nothing about using from: rather
than reply-to. I guess the same arguments could be applied tho.
Maybe I should just bring my
Carl Troein wrote:
On 31-Aug-01, G.S.Murthy wrote:
Hi
I was unable to write stored procedures in windows version of mysql. How
to write a stored procedures in winmysql version.
Did you read the manual? There's no such thing as stored procedures
in MySQL. Who told you that there is? :-o
There is also a famous document about reply-to:
http://www.unicom.com/pw/reply-to-harmful.html
Here's another point of view as well:
http://www.metasystema.org/essays/reply-to-useful.mhtml
As little as it has to do with databases, just for the record I'm on a bunch
of lists - some munge
Dear All,
I have a question:
How can build multi-master-host?
I have 3 mysql hosts,I want to use mysql data replicate. thanks!
wac
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Dear Friends Future Millionaire:
AS SEEN ON NATIONAL TV:
Due to the popularity of this letter on the Internet, a national weekly news
program recently devoted an entire show to the investigation of this
program described below, to see if it really can make people money. The
show also
mysql
Hi
I have a triangluar replication system working 100%, A -- B, B -- C,
C -- A.
What I know want to know is, is replication intelligent enough that if A had
to sometimes connect to C, and replicate, and then the next day connect to B
again, and so on and so on, would everything
I have MySQL server installed in my linux box. And want a windows based
client program that can be used to create and modify table designs and
other functions.
Is there any PHP client for such purpose or any library to enable
Microsoft Access to interface the server.
Thanks
Biniam
Hi!
I having a very weird unpredictable problem.
A script run from cron at 2:00am every day
must conect to database 'ubex' and do some
stuff with it. The script is in perl and uses DBI.
It works fine pretty much all the time but sometimes
(1 or 2 time per month) it gives an error:
Unknown
[EMAIL PROTECTED] writes:
Anyone,
I apologize for broadcasting to the group, but I've been trying to set-up a
maintenance contract
and licenses for about a month and no-one seems to be listening to the sales and
licensing
e-mail drops for MySQL AB Company.
I assume those that are 'in
Hi,
- Original Message -
From: Biniam Gebremichael [EMAIL PROTECTED]
I have MySQL server installed in my linux box. And want a windows based
client program that can be used to create and modify table designs and
other functions.
Is there any PHP client for such purpose
A very nice
Hi again,
I have the following problem:
mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert --quick
Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum
ERROR 1054 at line 52: Unknown column 'nan' in 'field list'
I have even tried OPTIMIZE TABLE REP; REPAIR TABLE
I am using, well trying to use mysql through WinNT. I have
successfully installed mysql and have had a look at the client
programs provided with the package. I'm trying to use mysql
through the DOS command prompt under Windows but when I type
C:\mysql I get an error message saying that 'it's
- Original Message -
From: Neil Davies [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 31, 2001 12:11 PM
Subject: just starting problem - WinNT
I am using, well trying to use mysql through WinNT. I have
successfully installed mysql and have had a look at the client
Dear all.
about to load sharing DB server,
I'd like to use facility which automatically part and execute requests from client ,
such as : update - Master?load -Slave.
previously,
Client Master --- Slave
^ update|--- Slave
|
I am using, well trying to use mysql through WinNT. I have
successfully installed mysql and have had a look at the client
programs provided with the package. I'm trying to use mysql
through the DOS command prompt under Windows but when I type
C:\mysql I get an error message saying that
I am posting this in the hope it will be useful; I seem
to have solved the problem.
The problem was(on 3.23.38) and Linux 2.2.18 or 2.4.0
This is a huge system, all SCSI, 2GB or RAM, 2PIII
x1000MHz processors and 37GB in the volume group
corresponding to /var/lib/mysql
There is an
Jeremy Zawodny writes:
On Thu, Aug 30, 2001 at 12:08:22PM -0700, [EMAIL PROTECTED] wrote:
Hi People,
I'm trying to execute this Simple query:
SET SQL_SAFE_MODE=0;
The server doesn't like it; However, SET any other option will work fine
except this one.
I'm still using
I have a table
CREATE TABLE currency_rate (
currency_id VARCHAR(3),
currency_date DATE,
currency_rate NUMERIC(16,8),
PRIMARY KEY (currency_id, currency_date)
);
and want to list the latest registered rates of all currencies.
Normally I would go about like this:
SELECT
I am a Sybase user who has recently shifted to MySQL. I searched and
searched but couldn't get the answer to my question.
Question is:
Q - How do I declare a User Defined Data Type?
In sybase the procedure is:
sp_addtype names, char(40), not null
go
Here names becomes a user defined datatype.
Description:
I use the MM JDBC driver version 2.0.4 to access my MySQL database from my
Java app. If I do SELECT NOW(), it returns a String object and not a Date
object. I tried to call different functions (e.g. SELECT DATE_ADD(NOW(),
INTERVAL 0 SECOND)) in order to have a Date in my
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
Hi again,
I have the following problem:
mysqldump -# --socket=/tmp/mysql.sock --add-drop-table -f --extended-insert
--quick Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum
ERROR 1054 at line 52: Unknown column 'nan' in 'field list'
I
Neil:
Did you add c:\mysql\bin to your system's path? The installer does not.
Did you install MySQL as a service (c:\mysql\bin\mysqld-nt --install) and
start the service (net start mysql)?
Gerald Jensen
- Original Message -
From: Neil Davies [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
ALTER IGNORE TABLE mytable ADD UNIQUE (email);
will both add a unique key ( which will avoide this problem in the
future ) and delete the duplicates.
Rory O'Connor wrote:
excuse me if this is too newbie...but I need to perform a duplicate
delete on my database using the e-mail address as
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
Ehh, now I know what you meant: - to use -Q option to mysqldump , ok
but it anyway did not help.
cut
I'm pretty sure the problem is with text nan being in place of a float
number.
--
And should say that
update rep set low='0.00' where id=148;
solved my problem for command:
mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended-insert
--quick --databases Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum
... to be complete. ;)
--
Martin Mokrejs - PGP5.0i key
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
Ehh, now I know what you meant: - to use -Q option to mysqldump , ok
but it anyway did not help.
cut
I'm pretty sure the problem is with text nan being in place of a float
number.
--
On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
May be you used some special chars in column names. In that case you
should use instruct mysqldump to use backticks for table and column
names.
Ehh, now I know what you meant: - to use -Q option to mysqldump , ok
but it anyway did not help.
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
And should say that
update rep set low='0.00' where id=148;
solved my problem for command:
mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended-insert
--quick --databases Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum
...
There is indeed a PHP client called PHPMyAdmin
(http://www.phpwizard.net/projects/phpMyAdmin/) and there are several
Windows-based clients including urSQL
(http://www.urbanresearch.com/ursql).
On Fri, 31 Aug 2001, Biniam Gebremichael wrote:
I have MySQL server installed in my linux box.
You need to look at the mysql error log, usually in your data directory.
99% of the time, if this is your first attempt to use MySQL you don't have
the permissions tables created yet. There should be a mysql_install_db
script that cam with your system, see if you have that, and try running
maybe not the 100% correct list, but then again...
SCRIPT
-
#!/usr/bin/perl -w
use DBI;
my $dbh = DBI-connect( DBI:mysql:database=xxx, xxx, xxx )
or die( Cannot connect to DB\n
I'm doing a query like:
select Title from inv where Title LIKE '%TOMMY%' OR Content LIKE
'%TOMMY%' OR Notes LIKE '%TOMMY%' order by Title
What I need is to have the results that match Title LIKE '%TOMMY%' to
appear first and then the rest. I have been doing 2 separate queries and
filtering
Hi,
I am sure there are cleaner ways, but this works
for my scripts just fine.
use DBI;
$drh=DBI-install_driver('mysql') || warn no Driver\n;
$dbh=$drh-connect(search:localhost,user_1) or warn No connect\n;
$cursor=$dbh-prepare(select email from opt2 where resend=100);
$cursor-execute;
Hi!
Sending SQL strings in PHP like
set autocommit=0
commit
rollback
seemed to work for Andre.
Regards,
Heikki
http://www.innodb.com
-Original Message-
From: Andre Konopka [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Friday, August 31, 2001 3:32 PM
Subject: Re: Why
hi,
i am trying to build a message board in php with mysql as back end;
what i want to do is to query the database in a certain way that the result
is returned in the correct order for php to display the discussion thread
properly
here is my table structure:
mysql show fields from posts
It's been a hot summer indeed, not only for the weatherman, but for Internet folks as
well. The latest round of economic warnings come at a time when everyone has been once
again scared by the media.
Don't believe all the hype that you hear on the news. As a matter of fact, a
surprising new
Plesae review your log files!
On Fri, 31 Aug 2001, nirav shah wrote:
Dear friends,
I have got mysql current 3.23 version installed
with linux in my pc.
but it is not working properly when i give
command
$ safe_mysqld
Here after few seconds, it displays
From: Rudy Metzger [EMAIL PROTECTED]
ERROR MESSAGE ---
Can't locate auto/DBI/do.al in @INC...
It sounds like your DBI didn't get built correctly. If you think that it probably was
built right, then you can start by trying to find do.al:
Stephen Johnson wrote:
I have a client that uses an Access dB in house and wants that database to
automatically update a MySQL database that I am creating for their website.
Is this possible and if so where can I find some reading material on how to
accomplish it?
Thanks for the
OK
Well as you know MySQL has less bells and whistles vs oracle. This makes it
very fast.
The other thing with MySQL is that it is very reliable. The last thing is
that it can deal with very big databases.
So if you need a very fast DB but not all the stuff of oracle MySQL is you
database.
We use
It sounds like the PHP module was compiled without MySQL support.
root wrote:
Hi,
I'm running mysql MAX 3.23.41 on LinuxPPC, everything was installed from
an RPM.
My problem is whenever I try to call mysql_connect (), from a php3
script, I got the error function not found or
Can you change the location of a MySQL database ? The default is
'/var/lib/mysql'.
Pete
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
I've not been using mysql for some time but did have it running for a
couple of small databases I use at home. It doesn't appear to work now,
the most obvious sympton being that msyqlshow shows a list of blank table
names.
[root@phoenix mysql]# rpm -q redhat-release
redhat-release-7.1-1
Way OT but I had to ask the Red Flag got my Attention.
I am looking build my own E-mail Server for my Domain and would like some pointers
Is there an E-mail Server that uses MySQL
What is the easyest to setup, I do not need a full blown one to handle lists and such
and my Client can connect
Is anyone else getting these goofy bounces from 123box.co.uk besides
me? Should I report them to Spamcop? :-)
database, sql, ...
--
Any technology distinguishable from magic is insufficiently advanced.
[EMAIL PROTECTED] TopQuark Software Serv. Contract programmer, server bum.
Yes.
s . keeling wrote:
Is anyone else getting these goofy bounces from 123box.co.uk besides
me? Should I report them to Spamcop? :-)
database, sql, ...
--
Any technology distinguishable from magic is insufficiently advanced.
[EMAIL PROTECTED] TopQuark Software Serv.
This is one thing I really can't stand about mysql. We should have the option when
creating
databases and tables of specifying where the database is located and the datafile and
indexfile.
Dave
On Fri, Aug 31, 2001 at 07:03:40PM +0200, Simon J Mudd wrote:
On Fri, 31 Aug 2001, Peter Moscatt
Weird things have just started happening in at least one table of my MySQL
3.22.32 database. The symptoms are like this:
mysql describe orders;
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
So sprach »s . keeling« am 2001-08-31 um 11:51:00 -0600 :
Is anyone else getting these goofy bounces from 123box.co.uk besides
me? Should I report them to Spamcop? :-)
i'm getting these as well.
database, sql, ...
Alexander Skwar
--
How to quote: http://learn.to/quote (german)
I'm porting an application to MySQL and I need to support transactions.
I will appreciate so much if someone could give me some impressions about
which one is better. BerkeleyDB or InnoDB?
Thanks in Advance,
Ary.
MySQL'ers,
I am one of the core members of the Rubi-con Security and Technology
conference held in Detroit every year. At this year's conference, when
asked what our attendees would like to see most next year, many of them said
they wanted someone to explain how MySQL works, what it's
On 31-Aug-2001 Jeremiah T. Folsom-Kovarik wrote:
Weird things have just started happening in at least one table of my MySQL
3.22.32 database. The symptoms are like this:
mysql describe orders;
+--+--+--+-+-+---+
| Field| Type
Thanks for your quick response! More below..
mysql select contact_info, expired from orders where order_num = '1';
+--+-+
| contact_info | expired |
+--+-+
| NULL | NULL|
+--+-+
^^
Hello, im in this situation:
i have a PC AMD K6-2 with 64 MB RAM. SuSE Linux 6.3 OS
when i compile the php with mysql everything works fine, but after y
compile the apache with this command:
./configure --activate-module-=src/modules/php4/libphp4.module
make
and after a few seconds this error
On 31-Aug-2001 Jeremiah T. Folsom-Kovarik wrote:
Thanks for your quick response! More below..
snip
Plus, all this just started happening yesterday, after everything worked
fine for many days. That leads me to believe there is a problem with a
corrupt table or something. How about
can anyone tell me why an auto increment field would jump from 231 to
something large like 883607 and then give me failure on future insertions
because of a duplicate key?
I'm running mysql 3.23.39 on RH 7.1
--Tony
-
Before
The remote hosts you mention are not allowed to access the database. This
is a permissions problem, in particular the value of hosts in one of the
permissions tables. It sounds like they only allow connections from the
localhost or their own network.
..chris
- Original Message -
From:
On Fri, Aug 31, 2001 at 05:37:58PM -0300, Pablo Javier Gonzalez Mateos wrote:
Hello, im in this situation:
i have a PC AMD K6-2 with 64 MB RAM. SuSE Linux 6.3 OS
when i compile the php with mysql everything works fine, but after y
compile the apache with this command:
./configure
Hi all,
How can I get the output of the DBUG_PRINT (which is
everywhere in the code of the mysql) option to
print the output as it is intended (functions and their
parameters)
and further extension to my question is how to get
separate the DBUG_PRINT output(once I get it, I am sure there
I think you will you have to do it in 2 steps using a temporary table. This
is one of MySQL's biggest weak points.
..chris
- Original Message -
From: Mattias Jiderhamn [EMAIL PROTECTED]
I have a table
CREATE TABLE currency_rate (
currency_id VARCHAR(3),
currency_date DATE,
Hello,
I just moved my databases from one machine to another. I recompiled
the whole thing, but I have some problems. MySQL now locks up, and
takes 100% cpu, after an hour or two. I need to shut it down and
restart it, and then it goes another hour again.
The machine is a dual pIII 866 with 2gb
can anyone please tell me what is happening here ?
[root@ns dump]# /usr/local/mysql/bin/mysql
/usr/local/mysql/bin/mysql: DROP: command not found
/usr/local/mysql/bin/mysql: syntax error near unexpected token `('
/usr/local/mysql/bin/mysql: /usr/local/mysql/bin/mysql: line 12: `CREATE
TABLE
Jens Hjalmarsson wrote:
Hello,
I just moved my databases from one machine to another. I recompiled
the whole thing, but I have some problems. MySQL now locks up, and
takes 100% cpu, after an hour or two. I need to shut it down and
restart it, and then it goes another hour again.
The
Hi!
On Sep 01, Mallikarjuna Rao N wrote:
Hi all,
How can I get the output of the DBUG_PRINT (which is
everywhere in the code of the mysql) option to
print the output as it is intended (functions and their
parameters)
and further extension to my question is how to get
separate the
Hello,
I am trying to insert large TEXT data into a MySQL database. The
server rejects insert statements that include a 15MB text file.
The manual says to change max_allowed_packet for the server
to accept large data. I have set this on the server side to
65535KB, which appears to be the largest
I'm not a mysql person, but I've seen similar stuff.
I think that for some reason Unix thinks that the file
you're trying to execute is not an executable, so it
is trying to run it as a shell script. Try this first:
file /usr/local/mysql/bin/mysql
and when it tells you that it is a text
Hi,
I am running MySQL 3.23.14-alpha for Solaris 2.6 and
am running into disk space problems with an ISAM table
I have in it. Table info:
15.8M rows of
datetime,
varchar 16,
varchar 64,
varchar 128,
varchar 64,
varchar 64,
varchar 32,
varchar 15,
varchar 32,
varchar 64.
So currently it is
I just moved my databases from one machine to another. I recompiled
the whole thing, but I have some problems. MySQL now locks up, and
takes 100% cpu, after an hour or two. I need to shut it down and
restart it, and then it goes another hour again.
The machine is a dual pIII 866 with 2gb
i have three tables. products, class, and dept.
class and dept each have two fields - code and text.
products has a field named class (containing class codes) and a field named dept
(containing dept codes)
for some depts, all the products that have that dept have the same class
for other
I have a database of minute by minute stock prices and I would like to
summarize daily information in a 'daily' table, which contains
information about the max, min, range of prices, total volume, etc...
This works so far:
CREATE TABLE daily (
ticker VARCHAR(8) not null,
date
I've used all three, Access, Oracle and MySQL. I have the least expertise
with Access.
My impressions are:
* Access is very limited in what it can do with respect to real database
manipulations, those contained in SQL. It does not handle large amounts of
data well. Access is really a very
hi,
I am setting up replication between two servers, and I have it working for
the most part- however- when I do cross-database updates, the changes don't
go through to the slave. as in:
use mysql;
update test.test_table set a=1;
I followed the instructions in the manual for replicating
so how to fix the error ?
How did file /usr/local/mysql/bin/mysql
become a text file ?
chris
- Original Message -
From: Lezz Giles [EMAIL PROTECTED]
To: christopher sagayam [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Saturday, September 01, 2001 2:36 AM
Subject: Re: weird error that I
On Sat, Sep 01, 2001 at 04:43:25AM +0100, christopher sagayam wrote:
so how to fix the error ?
How did file /usr/local/mysql/bin/mysql
become a text file ?
You tell us.
Regardless, is your data still intact? Make sure it's safe, rip out
mysql, and re-install.
Binaries don't just become
On Fri, Aug 31, 2001 at 11:50:25AM -0600, [EMAIL PROTECTED] wrote:
I am looking build my own E-mail Server for my Domain and would like
some pointers
Is there an E-mail Server that uses MySQL
Exim, Postfix, and Sendmail can all use MySQL to varying degrees.
There are probably others.
Hi everyone,
I am trying to get mysql-3.23.41 to compile under Solaris 2.6
sparc with gcc 2.95.2 and have been running into some problems. Currently
I am using this as my comfigure :
./configure --prefix=/usr/local/mysql \
--with-client-ldflags='-R /usr/local/lib'\
On Thu, Aug 30, 2001 at 12:01:09PM -0400, Jay Fesco wrote:
Is anyone else getting a strange flag associated with Jeremy's
email, or is it just me? Every one of his posts comes in flagged
in Outlook, and the headers have a line which reads:
X-message-flag: Mailbox corrupt. Please
On Thu, Aug 30, 2001 at 02:12:33PM +0300, Sinisa Milivojevic wrote:
from the manual:
F.2.26 Changes in release 3.23.15
To start mysqld as root, you must now use the --user=root option.
This does not seem to be true (tested on freebsd 3.23.41 etc), the
reason I have a problem
Dear Sir,
We are developing supply chain management where we are using EJB and mysql as
back end. We want to use transaction safe tables, but I tried 'show variables;'
command to know about table support for mysql support. Only 'have_isam' is 'YES'
all other are 'NO'. Does this means I
On Sat, Sep 01, 2001 at 05:30:16AM -, sameer ranadive wrote:
Dear Sir,
We are developing supply chain management where we are using EJB and
mysql as back end. We want to use transaction safe tables, but I
tried 'show variables;' command to know about table support for
mysql support.
On Fri, Aug 31, 2001 at 04:07:14PM -0500, Tony Bibbs wrote:
can anyone tell me why an auto increment field would jump from 231
to something large like 883607 and then give me failure on future
insertions because of a duplicate key?
Sounds like a corrupt index.
I'm running mysql 3.23.39 on
On Thu, Aug 30, 2001 at 12:49:15PM -0400, Luc Foisy wrote:
Has anyone tested dropping a master database?
By accident, yes.
I have dropped the master database that was replicating just to see
how it would affect the slave. The slave kept its data.
Was it up-to-date with the master, or was
90 matches
Mail list logo