I have been researching on how to deal with duplicate data. While I have a
case where there can be duplicate data, and I want to get rid of it, the
general ideas I seem to find are as follows, plus my own, which I would like
opinions on since I have not seen it mentioned.
I am not in a situation
Hi Scott, all!
Scott Haneda wrote:
I have been researching on how to deal with duplicate data. [[...]]
I am not in a situation where I can test for duplicates on insert, so the on
duplicate key update deal does me no good here.
Most data points to selecting distinct records to a temp table,
on 5/5/05 2:11 AM, Joerg Bruehe at [EMAIL PROTECTED] wrote:
Hi Scott, all!
Scott Haneda wrote:
I have been researching on how to deal with duplicate data. [[...]]
I am not in a situation where I can test for duplicates on insert, so the on
duplicate key update deal does me no good here.
Hi Shawn,
Thanks for your reply. The query you suggested seems to return all practices
that have bookings where the day type does not equal '1' - I changed your
query so it searches on the day_type rather than work_type as this is what
is required:
SELECT p.Practice_ID
,p.Practice_Name
Mark Sargent wrote:
Hi All,
if this script is in scripts by default, why does it have the
following code,
test -z $ldata ldata=./data
if test -z $basedir
then
basedir=.
bindir=./bin
execdir=./bin
pkgdatadir=./support-files
else
bindir=$basedir/bin
if test -x $basedir/libexec/mysqld
then
From: Dennis Fogg
I'm getting lots of duplicate rows even though I have a
unique index defined over multiple columns.
The issue is that multiple NULL values are allowed,
even when some values are not null.
This could be as specified by the SQL standard,
but it's certainly confusing for the
- Original Message -
From: Scott Haneda
on 5/5/05 2:11 AM, Joerg Bruehe at [EMAIL PROTECTED] wrote:
Basically, I have a chopping cart, this one is a little weird, for reasons
not worth explaining, you have a cart when a user is not logged in, and
they
*may* have one they made at some
on 5/5/05 2:52 AM, Jigal van Hemert at [EMAIL PROTECTED] wrote:
- Original Message -
From: Scott Haneda
on 5/5/05 2:11 AM, Joerg Bruehe at [EMAIL PROTECTED] wrote:
Basically, I have a chopping cart, this one is a little weird, for reasons
not worth explaining, you have a cart when a
From: Dennis Fogg
I'm getting lots of duplicate rows even though I have a
unique index defined over multiple columns.
The issue is that multiple NULL values are allowed,
even when some values are not null.
This could be as specified by the SQL standard,
but it's certainly confusing
- Original Message -
From: Scott Haneda
on 5/4/05 7:22 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
Error strings do change format sometimes.
And they won't necessarily be in English. :-)
I had a feeling, what is the general method most use to deal with the
above
scenario? I really
Hello.
I see default unix socket file is /tmp/mysql.sock
which could be removed by someone accidently.
Is it normal to keep it that way or keep in a
protected directory ?
See:
http://dev.mysql.com/doc/mysql/en/problems-with-mysql-sock.html
V. Agarwal [EMAIL PROTECTED]
Hello.
mysql.exe is a client utility, I've meant the server process. Check that
you're running mysqld-max-nt.exe.
I am not sure about max - but I am running mysql.exe (I think it is the
same as mysqld-nt).
No - when I do a select * from on a table in the moved database - I get
the
Hello.
There could be a lot of reasons for such a delay. First, you
should switch to bulk inserts and perform all operation as a single
transaction. Avoid usage of the autoextended or per-table tablespaces.
Are you able to upgrade? There could be some performance improvements
in the newer
Hello.
Have you been here?
http://bugs.mysql.com/bug.php?id=9211
I have been using ACCESS to do simpe data editing on our MySQL tables
for 3
years.
I recently installed 5.0.4 on my machine to evaluate it. I linked the
tables
into ACCESS through my old ODBC driver and got
Is it possible your data was changed during upgrade? How
have you performed it?
Andr$s Villanueva [EMAIL PROTECTED] wrote:
Hi! thanks for your response.
This are the values of the variables you asked for:
collation_connection: utf8_general_ci
collation_database:
Hi all,
I have installed a MySQL5.0 instance on Windows. And then created a
database( named 'SDN' ). Now I want to move this database to another
MySQL5.0 envirnment on Linux.
How can I make it. Thx
zlf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file. How is
this file generated..? I can't connect, keep getting errors. What about
via a port..? What is the argument for that..? Cheers.
Mark Sargent.
--
MySQL General Mailing List
For list archives:
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file. How is
this file generated..? I can't connect, keep getting errors. What about
via a port..? What is the argument for that..? Cheers.
Mark Sargent.
It's probably not in /tmp any more. Try
- Original Message -
From: Scott Haneda [EMAIL PROTECTED]
To: MySql mysql@lists.mysql.com
Sent: Thursday, May 05, 2005 3:39 AM
Subject: The age old delete duplicates
I have been researching on how to deal with duplicate data. While I have
a
case where there can be duplicate data,
Hi,
Thank you. I have a doubt, you mentioned one equation as
Memory Used By MySQL = Innodb_buffer_pool_size + key_buffer_size +
max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) +
max_connections*2MB
Is it against mysqld or for each mysql prompt?.
Could you please
Hi,
I dont think it's needed to go into to much details here but the query:
SELECT CONCAT(Airports.IATA, ' - ', Airports.Name) AS ArrivingFrom,
ADDTIME(FlightData.TimeStamp,
SUBTIME(FlightData.Enroute,DATE_FORMAT(SUBTIME(FlightData.TimeStamp,FlightData.ActDepTime),'%H:%i:%s')))
AS
Simon Garner wrote:
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file. How
is this file generated..? I can't connect, keep getting errors. What
about via a port..? What is the argument for that..? Cheers.
Mark Sargent.
It's probably not in /tmp any
No - mysqld-nt-max is not running - I can see in the task manager that only
mysqld-nt is running!!
I also confirmed this by checking in my services - I only have mysqld-nt
present as a service for mysql!
Should I run mysqld-nt-max for this functionality to work??
Also - I need to run only
Found my problem...
Thanks anyways :)
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by... - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: Chris Knipe [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, May
Mark Sargent wrote:
Simon Garner wrote:
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file.
How is this file generated..? I can't connect, keep getting errors.
What about via a port..? What is the argument for that..? Cheers.
Mark Sargent.
It's probably
Here is the table structure.
In this case I tried to change the 4 characters in prod_ID when I get the
message, but I get the same message when I try to make any changes.
Doing the exact same activity works fine on all of the 3.23/4.0/4.1 versions
I have installed previouly. Tables with unsigned
Thanks, that looks like my problem. I 'll wait until the fix percolates into
the 5. stream.
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 10:00 AM
To: mysql@lists.mysql.com
Subject: Re: ACCESS ODBC Interface whit 5.0.4
Hello.
Have you
Title: The Official Tennessee Hispanic Chamber of Commerce
(Mailing List Information, including unsubscription instructions,
is located at the end of this message.)
Upcoming THCC Networking Mixer
May 19
Mixer in collaboration with CABLE
Jalapeño's
try mysqldump -keq SDN SDN.sql
Then you can import it on another instance using mysql -u root
new_instance SDN.sql
On 5/5/05, zlf [EMAIL PROTECTED] wrote:
Hi all,
I have installed a MySQL5.0 instance on Windows. And then created a
database( named 'SDN' ). Now I want to move this
Hello,
I am developing a web application in which I have been working between home and
an away office. Anyway, up to lately, most of my efforts have been writing the
queries, etc for the backend. So I have a text file that dumps the database and
repopulates them. And up until now, it has been
Hello,
We have radius server and using mysql. I would like to determine
who are the users
who have not login to our dialup server for over six months and then
disable the account
In the example below, I'm just using 10 days
mysql SELECT distinct
If testuser signed in the day before the command was executed - i.e.
yesterday - he/she is well within the past 6 months and therefore
*shouldn't* be disabled.
Rhino
- Original Message -
From: Allan P. Magmanlac [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, May 05, 2005
You require SQLyog's Data Sync Tool. Download it from
http://www.webyog.com
You can find an article on it at:
http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent
Karam
--- Scott Purcell [EMAIL PROTECTED] wrote:
Hello,
I am developing a web application in which I have
been working
I prefder to use a FREE GUI like SQLyog found at
http://www.webyog.com
Karam
--- Gary Richardson [EMAIL PROTECTED] wrote:
try mysqldump -keq SDN SDN.sql
Then you can import it on another instance using
mysql -u root
new_instance SDN.sql
On 5/5/05, zlf [EMAIL PROTECTED] wrote:
Hi
NOTE: I sent this message yesterday, but for some
reason it didn't show up in the list. If you've
already received it, I apologize for the
inconvenience.
So here it goes again:
I searched the online manual and all I could find was
a reference to a statement of the form:
SELECT INTO
Actually, I did a full backup, uninstalled everything, installed a clean
4.1.11 and restored the backup
The data seems to be fine. The funny thing is that if i change one of
the inners for a left everything works fine! I think it's a bug, and an
ugly one...
Andrés Villanueva
Gleb Paharenko
Well... it's part of the SELECT statement, so you could try looking at
the SELECT documentation...
http://dev.mysql.com/doc/mysql/en/select.html
That has a good 9 paragraphs on the 'INTO OUTFILE' part of the SELECT
statement. It also refers you to...
I'm trying to set up replication over the Internet -- something
I've done successfully many times before. But this time I'm
having problems I haven't run into before, and I'm wondering if
they're related to firewall settings or network problems or just
something I'm overlooking.
For the
Can you see the slave thread on the master when you do a show processlist
from the master?
-Original Message-
From: Keith Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 05, 2005 1:48 PM
To: mysql@lists.mysql.com
Subject: Slave stuck at registering
I'm trying to set up replication
Victor Pendleton wrote:
Can you see the slave thread on the master when you do a show processlist
from the master?
Yes. It shows up with the command as Sleep, nothing in the
State column, and NULL in the Info column. It hangs around
for a while until Time reaches a little over 500, and then
From your previous posts I know you are very competent so no disrespect
intended. Was the slave data reloaded from the master, and the master.info
reset? What does the master.info log say?
-Original Message-
From: Keith Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 05, 2005 3:16 PM
Victor Pendleton wrote:
From your previous posts I know you are very competent so no disrespect
intended. Was the slave data reloaded from the master, and the master.info
reset? What does the master.info log say?
I copied over all the data from the master to the slave with
rsync, did LOCK TABLES
Gordon wrote:
Here is the table structure.
In this case I tried to change the 4 characters in prod_ID when I get the
message, but I get the same message when I try to make any changes.
Doing the exact same activity works fine on all of the 3.23/4.0/4.1 versions
I have installed previouly. Tables
Forgive me if this question has been answer in the past.
How can you record IP address on your first page index.html?
I am using my index.html to be index.lasso, and client_ip tag does not
seem to work.
It is picking up my server IP, and yes I have turned off the setting in
Lasso.
Now it
If you are windows then I prefer to use SQLyog at
http://www.webyog.com to do the job.
ITS FREE!
Karam
--- Homam S.A. [EMAIL PROTECTED] wrote:
NOTE: I sent this message yesterday, but for some
reason it didn't show up in the list. If you've
already received it, I apologize for the
Mark Sargent wrote:
Mark Sargent wrote:
Simon Garner wrote:
Mark Sargent wrote:
Hi All,
mysql is running, but, there seems to be no /tmp/mysql.sock file.
How is this file generated..? I can't connect, keep getting errors.
What about via a port..? What is the argument for that..? Cheers.
Mark
On 6/05/2005 4:18 p.m., Mark Sargent wrote:
Ok, I just took a punt, and changed the setting in my.cnf to reflect the
config settings, to /tmp/mysql.sock, and all is well. What I don't un,
is, why the default settings were like this, I certainly made no changes
to either the configs or the
Simon Garner wrote:
On 6/05/2005 4:18 p.m., Mark Sargent wrote:
Ok, I just took a punt, and changed the setting in my.cnf to reflect
the config settings, to /tmp/mysql.sock, and all is well. What I
don't un, is, why the default settings were like this, I certainly
made no changes to either the
48 matches
Mail list logo