- Am 1. Apr 2016 um 21:56 schrieb shawn l.green shawn.l.gr...@oracle.com:
> Correct. MyISAM is not a transactional storage engine. It has no concept
> of COMMIT or ROLLBACK. Changes to it are controlled by a full table lock
> and as soon as the change is complete, the table is unlocked and is
- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com:
>> Is the mix of MyISAM and InnoDB a problem with Row-Based-Logging or
>> with Statement-Based-Logging or with both ?
>>
>>
>
> Both.
>
>
>>
>> I don't understand the example:
>> Does "begin transaction" and "COMMIT"
Am 01.04.2016 um 21:09 schrieb Lentes, Bernd:
- Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com:
You said, "This is done on the master, written in the log and then
replicated to the slave, "
The INSERT would not appear in the Binary log until after session 1
commits
if the transaction that rolled back contained statements that
> changed MyISAM tables, then the entire transaction (all of the work it
> did) needs to be written into the Binary Log and REDO log just to have
> the very last command be "ROLLBACK". What that will do is create
- Am 1. Apr 2016 um 17:52 schrieb shawn l.green shawn.l.gr...@oracle.com:
>> What is true ? when the transaction started or when the first read is
>> performed ?
> Until you need to establish a snapshot of the data, then you don't need
> a snapshot position.
>
> The transaction physically
On 4/1/2016 10:08 AM, Lentes, Bernd wrote:
- On Apr 1, 2016, at 3:12 PM, Bernd Lentes
bernd.len...@helmholtz-muenchen.de wrote:
Btw:
i read about isolation levels. REPEATABLE READ is the default for InnoDB.
http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says:
i read the more i'm getting confused. I totally underrated
replication.
But i will not give up ;-) And i appreciate your help, Shawn.
What do you mean with the workaround ? Does MySQL this automatically or has it
be done
in the app code ?
It's inside the server. You don't need to
- On Apr 1, 2016, at 3:12 PM, Bernd Lentes
bernd.len...@helmholtz-muenchen.de wrote:
Btw:
i read about isolation levels. REPEATABLE READ is the default for InnoDB.
http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says:
"...so that all queries within a transaction s
the same time.
>
Hi,
oh my god. The more i read the more i'm getting confused. I totally underrated
replication.
But i will not give up ;-) And i appreciate your help, Shawn.
What do you mean with the workaround ? Does MySQL this automatically or has it
be done
in the app code ?
> You
On 3/30/2016 1:26 PM, Lentes, Bernd wrote:
- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:
So i should use the default (autocommit=1)?
no, you should what is appropriate for your application
if you don't care about inserts/updates triggered by let say a
webr
Am 30.03.2016 um 19:26 schrieb Lentes, Bernd:
- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:
So i should use the default (autocommit=1)?
no, you should what is appropriate for your application
if you don't care about inserts/updates triggered by let say a
w
- On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote:
>> So i should use the default (autocommit=1)?
>
> no, you should what is appropriate for your application
>
> if you don't care about inserts/updates triggered by let say a
> webrequest are half written due a crash
Am 30.03.2016 um 18:56 schrieb Lentes, Bernd:
- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
I read that the converting is not difficult. But has the code of our webapp to
be changed ? It's written in php and perl.
What i understand is that inserts/updates/dele
- On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
>>
>> I read that the converting is not difficult. But has the code of our webapp
>> to
>> be changed ? It's written in php and perl.
>> What i understand is that inserts/updates/deletions in InnoDB tables have to
Am 28.03.2016 um 21:36 schrieb Lentes, Bernd:
- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote:
Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine behaviors (tran
Hello Bernd,
On 3/28/2016 3:36 PM, Lentes, Bernd wrote:
- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote:
Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine beha
- On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote:
> Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
>>> You would be better served by first converting your MyISAM tables to
>>> InnoDB to stop mixing storage engine behaviors (transactional and
>>> non-transactional) wit
Am 27.03.2016 um 14:34 schrieb Lentes, Bernd:
You would be better served by first converting your MyISAM tables to
InnoDB to stop mixing storage engine behaviors (transactional and
non-transactional) within the scope of a single transaction. But if you
cannot convert them, using MIXED will be a
- Am 25. Mrz 2016 um 21:54 schrieb shawn l.green shawn.l.gr...@oracle.com:
> Hello Bernd,
>
> Sorry for the delay, I wanted to make sure I had enough time to address
> all of your points.
>> He proposed to have two hosts, and on each is running a MySQL instance
>> as master AND slave. But
Hello Bernd,
Sorry for the delay, I wanted to make sure I had enough time to address
all of your points.
On 3/22/2016 7:07 AM, william drescher wrote:
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know t
- On Mar 23, 2016, at 11:11 AM, william drescher will...@techservsys.com
wrote:
>>
>> Hi William,
>>
>> thanks for the try. Good idea !
>> Did you change anything ?
>>
>>
>> Bernd
>
> Yes, in the original document there were some characters that
> were put on the screen as asian pictograph
On 3/22/2016 7:49 AM, Lentes, Bernd wrote:
- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com
wrote:
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list ded
- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com
wrote:
> sent for Bernd, and to see if it works from another sender
> --
> Lentes, Bernd wrote:
> Hi,
>
> i know that there is a list dedicated to replication, but when
> y
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list dedicated to replication, but when
you have a look in the archive it's nearly complete empty. Really
not busy.
So i hope it's ok if i
2016/03/18 12:54 ... Don Wieland:
Trying to get the correct syntax on this:
ORDER BY
CASE
WHEN tr.Placed = "X" THEN r.Division ASC,
FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does on
x27;t bad.
But nevertheless it must also have to do with the e-mail itself. I sent it from
gmx.de and web.de, both werde declined.
My other mails (like this one) arrive.
I shrinked the mail already, but also this did not help.
You can have a look on the two mails i tried:
https://hmgub
Dear list admin,
i need your help. I'm trying to write an e-Mail to the list for already one
week. I always get it back because it's classified as spam.
The mail is formatted as plain-text, include neither links nor attachments. I
don't understand why it's classified as spam
Hi gang,
Trying to get the correct syntax on this:
ORDER BY
CASE
WHEN tr.Placed = "X" THEN r.Division ASC,
FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”),
tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does one deal with CONDITION
Hi gang,
Trying to get the correct syntax on this:
ORDER BY
CASE
WHEN tr.Placed = "X" THEN r.Division ASC,
FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”),
tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does one deal with CONDITION
Am 18.03.2016 um 14:56 schrieb Chris Knipe:
Blah blah blah...
Delivery to the following recipient failed permanently:
mysql@lists.mysql.com
Technical details of permanent failure:
Your message was rejected by the server for the recipient domain
lists.mysql.com by lists-mx.mysql.com. [13
On Fri, Mar 18, 2016 at 3:43 PM, Lentes, Bernd <
bernd.len...@helmholtz-muenchen.de> wrote:
> i need your help. I'm trying to write an e-Mail to the list for already
> one week. I always get it back because it's classified as spam.
>
Ditto. I've pretty much given up on this list...
Am 19.03.2016 um 15:23 schrieb Reindl Harald:
Am 19.03.2016 um 15:17 schrieb Lentes, Bernd:
one further question:
if some of my e-mails get through (like this one) and others don't, it
does not depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that parti
Am 19.03.2016 um 15:17 schrieb Lentes, Bernd:
one further question:
if some of my e-mails get through (like this one) and others don't, it does not
depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that particular e-Mail?
both
a spamfilter is typically
Am 19.03.2016 um 15:08 schrieb Lentes, Bernd:
Ok. I tried again:
pc53200:~ # nslookup 20.103.107.146.score.senderscore.com.
Server: 146.107.8.88
Address:146.107.8.88#53
Non-authoritative answer:
Name: 20.103.107.146.score.senderscore.com
Address: 127.0.4.62
My result is 127
Hi,
one further question:
if some of my e-mails get through (like this one) and others don't, it does not
depend on theh reputation of our domain or mailserver ? Right ?
So the reason has to be that particular e-Mail ?
Bernd
Helmholtz Zentrum Muenchen
Deutsches Forschungszentrum fuer Gesundh
- Am 18. Mrz 2016 um 15:34 schrieb Reindl Harald h.rei...@thelounge.net:
> Am 18.03.2016 um 15:25 schrieb Lentes, Bernd:
>>
>> - Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman vegiv...@tuxera.be:
>>
>
> as i already told you offlist
> senderscore.com LISTED 127.0.4.67
>
> this *
f the mailserver classifies you as spam, that's
usually caused by something on your side :-)
- Original Message -
From: "Chris Knipe"
To: "Lentes, Bernd"
Cc: "MySql"
Sent: Friday, 18 March, 2016 14:46:26
Subject: Re: need help from the list admin
Ditto.
;
>>> - Original Message -
>>>
>>>> From: "Chris Knipe"
>>>> To: "Lentes, Bernd"
>>>> Cc: "MySql"
>>>> Sent: Friday, 18 March, 2016 14:46:26
>>>> Subject: Re: need help from the list adm
u as spam, that's
> usually caused by something on your side :-)
>
> - Original Message -
>> From: "Chris Knipe"
>> To: "Lentes, Bernd"
>> Cc: "MySql"
>> Sent: Friday, 18 March, 2016 14:46:26
>> Subj
> > To: "Lentes, Bernd"
> > Cc: "MySql"
> > Sent: Friday, 18 March, 2016 14:46:26
> > Subject: Re: need help from the list admin
>
> > Ditto. I've pretty much given up on this list...
>
> --
> Unhappiness is discouraged and will be corrected with kitten pictures.
>
--
Regards,
Chris Knipe
000): Can't reopen table: 'a'
>
>
> So, it's a temporary table, and you'll need to make that not so.
Yes, cst_rollup is a temp table. The underlying table is millions of
rows (with 300 columns) so for efficiency a subset of the rows and
columns are selected into the temp table
On Fri, Jan 1, 2016 at 2:12 PM, Peter Brawley
wrote:
> On 12/31/2015 0:51, Larry Martell wrote:
>>
>> I need to count the number of rows in a table that are grouped by a
>> list of columns, but I also need to exclude rows that have more then
>> some count when grouped by a different set of columns
On 12/31/2015 0:51, Larry Martell wrote:
I need to count the number of rows in a table that are grouped by a
list of columns, but I also need to exclude rows that have more then
some count when grouped by a different set of columns. Conceptually,
this is not hard, but I am having trouble doing th
I need to count the number of rows in a table that are grouped by a
list of columns, but I also need to exclude rows that have more then
some count when grouped by a different set of columns. Conceptually,
this is not hard, but I am having trouble doing this efficiently.
My first counting query wo
JOIN invoice_InvoiceLines i ON p.pk_ProductID = i.fk_ProductID AND
i.fk_InvoiceID IN (1,2,3)
WHERE p.pk_ProductID IN (1,2,3)
GROUP BY i.fk_ProductID;
but it is not working.
Little help please. Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
--
M
One more guess:
Try explicitly aliasing the fields of interest and using those aliases
exclusively throughout the rest of the expression.
SELECT
p.pk_ProductID as pid,
p.Description as dsc,
SUM(i.Quantity) as totl
FROM invoice_invoicelines_Product p
JOIN invoice_InvoiceLines i ON pid = i.fk_Prod
> On Oct 22, 2015, at 2:41 PM, Michael Dykman wrote:
>
> I'm not at a terminal but have you tried grouping by p.pk_ProductID instead
> of i.fk...? It is the actual value you are selecting as well as being on
> the primary table in the query.
Yeah I tried that - actually the SUM I need is on the
antity)
>
> FROM invoice_invoicelines_Product p
> JOIN invoice_InvoiceLines i ON p.pk_ProductID = i.fk_ProductID AND
> i.fk_InvoiceID IN (1,2,3)
>
> WHERE p.pk_ProductID IN (1,2,3)
> GROUP BY i.fk_ProductID;
>
> but it is not working.
>
>
> Little help please. Thanks!
>
>
> Don Wieland
> d...@pointmade.net
> http://www.pointmade.net
> https://www.facebook.com/pointmade.band
>
>
>
>
>
invoice_InvoiceLines i ON p.pk_ProductID = i.fk_ProductID AND
i.fk_InvoiceID IN (1,2,3)
WHERE p.pk_ProductID IN (1,2,3)
GROUP BY i.fk_ProductID;
but it is not working.
Little help please. Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
On 10/22/2015 11:48 AM, Don Wieland wrote:
On Oct 20, 2015, at 1:24 PM, shawn l.green wrote:
Which release of MySQL are you using?
Version 5.5.45-cll
How many rows do you get if you remove the GROUP_CONCAT operator? We don't need
to see the results. (sometimes it is a good idea to look
> On Oct 20, 2015, at 1:24 PM, shawn l.green wrote:
>
> Which release of MySQL are you using?
Version 5.5.45-cll
> How many rows do you get if you remove the GROUP_CONCAT operator? We don't
> need to see the results. (sometimes it is a good idea to look at the raw,
> unprocessed results)
>
row of the “hiv_transactions” table when there are
multiple rows.
On the GROUP_CONCAT I am trying to get a comma delineated list of the child
rec_code with no duplicates
Appreciate any help. Hopefully a small mod ;-)
Don Wieland
Which release of MySQL are you using?
How many rows d
SC, ht.rec_code ASC;
I am only showing one row of the “hiv_transactions” table when there are
multiple rows.
On the GROUP_CONCAT I am trying to get a comma delineated list of the child
rec_code with no duplicates
Appreciate any help. Hopefully a small mod ;-)
Group_Concat() is an aggregating
g one row of the “hiv_transactions” table when there are
multiple rows.
On the GROUP_CONCAT I am trying to get a comma delineated list of the child
rec_code with no duplicates
Appreciate any help. Hopefully a small mod ;-)
Don Wieland
D W D a t a
Hello Steve,
On 8/27/2015 9:11 PM, Steve Matzura wrote:
I have a Wordpress user who is setting up a Website and says he can't
connect to his database. Both I and the Wordpress admin are new to
this, so I've probably done something wron when I set him up
initiallyg.
Once I connected to SQL as th
I have a Wordpress user who is setting up a Website and says he can't
connect to his database. Both I and the Wordpress admin are new to
this, so I've probably done something wron when I set him up
initiallyg.
Once I connected to SQL as the SQL admin, I used the following
commands to set up the ne
> From: Olivier Nicole
>
> You could look for a tool called "The Regex Coach". While it is mainly
> for Windows, it runs very well in vine. I fijd it highly useful to debug
> regexps.
On the Mac, look for "RegExRx." It lets you paste in text to work on, build a
regex, and see the result in real
I don't think it accepts \d, or much of anything else I am used to
putting in expressions :)
This is what I ended up with and it appears to be working:
REGEXP '10.[[:alnum:]]{1,3}.(22[4-9]|23[0-9]).[[:alnum:]]{1,3}'
On Thu, Mar 19, 2015 at 11:10 AM, Michael Dykman wrote:
> Trying to pattern m
Trying to pattern match ip addresses is a famous anti-pattern; it's one of
those things like you feel like it should work, but it won't.
Your case, however, is pretty specific. taking advantage of the limited
range (I will assume you only wanted 4 sections of IPv4)
this should come close:
10[.]\
Paul,
You could look for a tool called "The Regex Coach". While it is mainly
for Windows, it runs very well in vine. I fijd it highly useful to debug
regexps.
Best regards,
Olivier
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
I am trying to pick out a range of IP addresses using REGEXP but
failing miserably :)
The pattern I want to match is:
10.%.224-239.%.%
The regex I have looks like this:
AND INET_NTOA(src_ip) REGEXP '\d{1,3}\\.\d{1,3}\.(22[4-9]|23[0-9])\\.\d{1,3}'
but, go fish. Thoughts?
Thanks!
--
Paul Hal
measparams.id =
data_cst.meas_params_name_id
INNER JOIN data_recipe ON data_recipe.id = data_cst.recipe_id
WHERE data_target.id IN (172) AND
data_recipe.id IN (148) AND
data_cst.date_time BETWEEN '2015-01-26 00:00:00' AND '2015-01-26
23:59:59'
GROUP BY wafer_id, data_cst.lot_id, ta
quot;,
>>>> MAX(data_cst.date_time) "end",
>>>> MIN(data_target.name) as target,
>>>> MIN(data_lot.name) as lot,
>>>> MIN(data_wafer.name) as wafer,
>>>> MIN(measname) as measname,
>&g
data_recipe.id IN (148) AND
data_cst.date_time BETWEEN '2015-01-26 00:00:00' AND '2015-01-26
23:59:59'
GROUP BY wafer_id, data_cst.lot_id, target_name_id
... snip ...
Thanks for taking the time to read this, and for any help or pointers
you can give me.
The bigges
gt; FROM data_cst
>> INNER JOIN data_tool ON data_tool.id = data_cst.tool_id
>> INNER JOIN data_target ON data_target.id = data_cst.target_name_id
>> INNER JOIN data_lot ON data_lot.id = data_cst.lot_id
>> INNER JOIN data_wafer ON data_wafer.id = data_cst.wafer_id
>> INNER JOIN dat
7;
GROUP BY wafer_id, data_cst.lot_id, target_name_id
... snip ...
Thanks for taking the time to read this, and for any help or pointers
you can give me.
The biggest difference is the added selectivity generated by the WHERE
term against the data_recipe table.
Compare the two EXPLAINS, in
_dbe16c2b |1 | roiname
| A |12415961 | NULL | NULL | YES | BTREE
| | |
+--++---+--+-+---+-+--+----+--++-+---+
Thanks for taking the time to read this, and for any help or pointers
you can give me.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hello Mimko,
Sorry for the late reply. I had a bunch of work to take care of before
vacation, then there was the vacation itself. :)
On 11/13/2014 2:34 PM, Mimiko wrote:
Hello. I have this table:
> show create table cc_agents_tier_status_log:
CREATE TABLE "cc_agents_tier_status_log" (
"i
On 15.11.2014 01:06, Peter Brawley wrote:
Let's see the results of Explain Extended this query, & result of Show
Create Table cc_member_queue_end_log.
cc_member_queue_end_log is not of interest, it is used just as a series
of numbers. It may be any table with ids.
I've changed a bit the quer
Let's see the results of Explain Extended this query, & result of Show
Create Table cc_member_queue_end_log.
PB
-
On 2014-11-13 1:34 PM, Mimiko wrote:
Hello. I have this table:
> show create table cc_agents_tier_status_log:
CREATE TABLE "cc_agents_tier_status_log" (
"id" int(10) unsign
Hello. I have this table:
> show create table cc_agents_tier_status_log:
CREATE TABLE "cc_agents_tier_status_log" (
"id" int(10) unsigned NOT NULL AUTO_INCREMENT,
"date_log" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
"cc_agent" varchar(45) NOT NULL,
"cc_agent_tier_status_id" tinyint(3)
egory INT(11))
>>> BEGIN
>>> SET @a = 0;
>>> UPDATE
>>> documents SET sort_id = (@a := @a + 1)
>>> WHERE
>>> document_category = category
>>> ORDER BY
>>>
ORDER BY
sort_id;
END
//
2014-07-14 11:42 GMT+09:00 Don Wieland :
I am trying to create this stored procedure, but can't understand why my
editor is chocking on it. Little help please:
DELIMITER //
CREATE PROCEDURE `reset_sortid` (IN category INT(11))
BEGIN
DECL
t; I am trying to create this stored procedure, but can't understand why my
> > editor is chocking on it. Little help please:
> >
> > DELIMITER //
> > CREATE PROCEDURE `reset_sortid` (IN category INT(11))
> > BEGIN
> > DECLARE a INT;
> >
GMT+09:00 Don Wieland :
> I am trying to create this stored procedure, but can't understand why my
> editor is chocking on it. Little help please:
>
> DELIMITER //
> CREATE PROCEDURE `reset_sortid` (IN category INT(11))
> BEGIN
> DECLARE a INT;
>
Mon, Jul 14, 2014 at 12:42 PM, Don Wieland wrote:
>
> > I am trying to create this stored procedure, but can't understand why my
> > editor is chocking on it. Little help please:
> >
> > DELIMITER //
> > CREATE PROCEDURE `reset_sortid` (IN category INT(11)
maybe try 'order by sort_id desc'?
On Mon, Jul 14, 2014 at 12:42 PM, Don Wieland wrote:
> I am trying to create this stored procedure, but can't understand why my
> editor is chocking on it. Little help please:
>
> DELIMITER //
> CREATE PROCEDURE `reset_sortid`
I am trying to create this stored procedure, but can't understand why my editor
is chocking on it. Little help please:
DELIMITER //
CREATE PROCEDURE `reset_sortid` (IN category INT(11))
BEGIN
DECLARE a INT;
SET a = 0;
UPDATE
documents SET sort_id = (a
delete b from icd9x10 a
join icd9x10 b on a.icd9 = b.icd9 and a.id < b.id
>...
> CREATE TABLE `ICD9X10` (
> ...
> id icd9 icd10
> 25 29182 F10182
> 26 29182 F10282
> ...
Good luck,
Bob
On 3/29/2014 2:26 PM, william drescher wrote:
I am given a table: ICD9X10 which is a maping of ICD9 codes to
ICD10 codes. Unfortunately the table contains duplicate entries
that I need to remove.
CREATE TABLE `ICD9X10` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`icd9` char(8) NOT NULL,
`
10158
Direct: (646) 487-6522 | Fax: (646) 487-1569 | dle...@univision.net |
www.univision.net
-Original Message-
From: william drescher [mailto:will...@techservsys.com]
Sent: Saturday, March 29, 2014 2:26 PM
To: mysql@lists.mysql.com
Subject: Help with cleaning up data
I am given a table: IC
On 29-03-2014 19:26, william drescher wrote:
I am given a table: ICD9X10 which is a maping of ICD9 codes to ICD10
codes. Unfortunately the table contains duplicate entries that I need
to remove.
...
I just can't think of a way to write a querey to delete the duplicates.
Does anyone have a sugg
Hi Bill,
How big is your table? It seems to me that you might want to change your
unique keys to something like (icd9, icd10), thus guaranteeing that every
mapping will exist only once in your table. You could create a new table
with that constraint and copy all your data to it:
CREATE TABLE `ICD
I am given a table: ICD9X10 which is a maping of ICD9 codes to
ICD10 codes. Unfortunately the table contains duplicate entries
that I need to remove.
CREATE TABLE `ICD9X10` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`icd9` char(8) NOT NULL,
`icd10` char(6) NOT NULL,
PRIMARY KEY (`id`),
U
I'm using MySQL 5.0.92-log.
I'm trying to do a pivot-sort-of-thing. I've tried a few things from the
O'Reilly "SQL Cookbook," but I seem to be having a mental block.
I have a table of farm harvests. Each harvest has a date, quantity, and foreign
keys into product and harvester tables:
-
2013/10/22 12:20 -0400,
I recently upgraded a local MySQL installation to 5.5.32 and am trying to
figure out why the following query won't work as expected anymore. I'm just
trying to compare a set of dates to NOW() but since the upgrade, these don't
seem to work as expected.
SELECT
Thanks Sam.
It turns out that if I put the DATE_ADD.. within DATE(), it works as expected.
That is sufficient for my goals, but it would be nice to understand this issue
in case there may be other cases that I need to watch out for.
Cheers,
Michael
On Oct 22, 2013, at 6:18 PM, kitlenv wrote
Hi Michael,
FYI: I'm using 5.6.13 and your query returns 0 for the third column with my
instance.
Cheers,
Sam
On Wed, Oct 23, 2013 at 2:35 AM, Michael Stroh wrote:
> I recently upgraded a local MySQL installation to 5.5.32 and am trying to
> figure out why the following query won't work as ex
I recently upgraded a local MySQL installation to 5.5.32 and am trying to
figure out why the following query won't work as expected anymore. I'm just
trying to compare a set of dates to NOW() but since the upgrade, these don't
seem to work as expected.
SELECT
DATE_ADD(STR_TO_DATE('2013-350-00:
sounds like a scheduler issue
did you try "deadline"?
http://en.wikipedia.org/wiki/Deadline_scheduler
on Linux systems pass "elevator=deadline" as kernel param
Am 12.10.2013 20:58, schrieb Chris McKeever:
> We had a similar issue a bit back - and although it sounds similar - based
> on your foll
We had a similar issue a bit back - and although it sounds similar - based
on your followups it probably isnt, but will just toss this out there
anyhows. We were experiencing connection timeouts when load would ramp up.
Doing some digging we learned that our firewall between the servers
bandwidth
Am 12.10.2013 19:45, schrieb Jørn Dahl-Stamnes:
> On Saturday 12 October 2013 17:36, Reindl Harald wrote:
>> so someone did "optimize table" on a large table
>> you do yourself not a favour restarting the server in such a moment
>
> 7 hours before the server was shut down, we did a alter table t
On Saturday 12 October 2013 17:36, Reindl Harald wrote:
> so someone did "optimize table" on a large table
> you do yourself not a favour restarting the server in such a moment
7 hours before the server was shut down, we did a alter table to add a primary
key to a table that is read-only from the
Am 12.10.2013 17:02, schrieb Jørn Dahl-Stamnes:
> On Saturday 12 October 2013 13:07, Andrew Moore wrote:
>> Could be a crash related to innodb data dictionary being out of sync. Could
>> be a bug.
>
> Seems like a bug yes. However, we had a strange situation yesterday when we
> had several proc
On Saturday 12 October 2013 13:07, Andrew Moore wrote:
> Could be a crash related to innodb data dictionary being out of sync. Could
> be a bug.
Seems like a bug yes. However, we had a strange situation yesterday when we
had several processes in the state "copying to tmp table" (if i remember the
t a bug. It is
> also possible that this binary
> Oct 12 11:53:33 cebycny mysqld: or one of the libraries it was linked
> against
> is corrupt, improperly built,
> Oct 12 11:53:33 cebycny mysqld: or misconfigured. This error can also be
> caused by malfunctioning hardware.
> Oct 1
cebycny mysqld: or one of the libraries it was linked against
is corrupt, improperly built,
Oct 12 11:53:33 cebycny mysqld: or misconfigured. This error can also be
caused by malfunctioning hardware.
Oct 12 11:53:33 cebycny mysqld: We will try our best to scrape up some info
that will hopefully he
You might want to comment
bind-address= 127.0.0.1
in your my.cnf and restart mysql server.
On 12/10/13 10:49, Jørn Dahl-Stamnes wrote:
Hello,
I got a strange problem related to a production server. It has been working OK
for months, but yesterday it start to fail. There are seve
Hello,
I got a strange problem related to a production server. It has been working OK
for months, but yesterday it start to fail. There are several batch scripts
using the database in addition to a web application using it.
The php scripts running in batch mode began to get:
mysql_connect(): L
As a matter of dumb questions, what versions are the old and new mysqld; and
are they running on the same platform (OS, 32/64 bit, ...) ?
- Original Message -
> From: "Peter"
> To: "Reindl Harald" , mysql@lists.mysql.com
> Sent: Friday, 21 June, 2013 10
1 - 100 of 7359 matches
Mail list logo
