On Fri, 19 Jan 2018 11:25:42 -0500, shawn l.green wrote:
> Hello Chris,
>
> On 1/19/2018 12:50 AM, Chris Roy-Smith wrote:
>> Hi I am running mysql 5.7.20 in ubuntu linux 17.10
>>
>> I have 2 tables, member and status with contents like
>>
>> member:
>&
for a selected year.
select details.ident, given, surname from details left join status on
details.ident = status.ident where NOT EXISTS (select year from status
where (status.year = 2018) and (details.ident = status.ident) )
Thank you for looking at this.
regards, Chris Roy-Smith
--
MySQL General
dnât it be irrelevant whether AccountVolume-INT is
signed or unsigned?
How would I go about doing this? I have played quite a bit with CAST here, but
I am not having much luck.
Thnx,
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
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...
yet, both of those messages made it through :-p
>>>
>>> Stick your domain in http://mxtoolbox.com to see if there's any
>>> problems that
>>> might be worth solving. If the mailserver classifies you as spam, that's
>>> usually caused by something on your sid
returned was:
550 Currently Sending Spam See:
http://www.sorbs.net/lookup.shtml?5.200.22.158
Show me one site, where that IP is, or WAS ever blacklisted?
--
Chris.
On Fri, Mar 18, 2016 at 3:52 PM, Johan De Meersman <vegiv...@tuxera.be>
wrote:
>
> and yet, both of those m
nx.
--
Regards,
Chris Knipe
already exist), how is this query logged in the statistics?
When the ON DUPLICATE KEY UPDATE runs (i.e. it's updating a record), is it
still logged as a INSERT query, or is it logged as a UPDATE query?
Thnx.
--
Regards,
Chris Knipe
| |
|
+--++--+--+--+---+-+--++--++-+---+
2 rows in set (0.00 sec)
--
Regards,
Chris Knipe
suggestions given this info?
Thanks,
--
Chris Hornung
Johan De Meersman mailto:vegiv...@tuxera.be
March 24, 2015 at 6:08 AM
Please do
select id, customer_id, concat('-', group_id, '-')
from app_customergroupmembership
where customer_id ='ajEiQA';
I suspect one of those group IDs has
|
+-+-+--+-+
| 20279608258 | ajEiQA | ddH6Ev | 2015-02-17 00:14:54 |
+-+-+--+-+
Any thoughts on how this situation came to pass, and how to prevent it
from happening?
Thanks,
--
Chris Hornung
On Mon, Dec 8, 2014 at 3:02 PM, Wagner Bianchi
wagnerbianch...@gmail.com wrote:
Hello Chris,
Can pls you share the below command output...
SHOW STATUS LIKE 'Threads%';
SELECT @@thread_cache_size, @@net_buffer_length, @@max_allowed_packet;
mysql SHOW STATUS LIKE 'Threads
the mysql client running on the same host as the mysql server,
connected to localhost via TCP. Current connections to the DB was at about
200 out of 500
--
Chris.
-Original Message-
From: Chris Knipe [mailto:sav...@savage.za.org]
Sent: Sunday, December 07, 2014 11:34 PM
To: 'mysql
better than querying directly against the PRIMARY key, can it?
Many thanks,
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman vegiv...@tuxera.be wrote:
- Original Message -
From: Chris Knipe sav...@savage.za.org
To: mysql@lists.mysql.com
Sent: Thursday, 24 July, 2014 11:17:50 AM
Subject: Avoiding table scans...
mysql SELECT MIN(ArtNumber) AS ArtNumber
the mythology behind in order to be able to change the
other queries as well...
MANY thanks for the assistance :-)
--
Chris.
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
be able to go up from 4 to over 64 spindles whilst still
being able to share the storage and have redundancy.
Many thanks for the inputs and feedbacks...
--
C
On Fri, Jul 26, 2013 at 9:23 AM, Johan De Meersman vegiv...@tuxera.be wrote:
Hey Chris,
I'm afraid that this is not what databases
-
From: ckn...@savage.za.org [mailto:ckn...@savage.za.org] On Behalf Of
Chris Knipe
Sent: Friday, July 26, 2013 12:30 AM
To: Johan De Meersman
Cc: mysql
Subject: Re: hypothetical question about data storage
Hi All,
Thanks for the responces, and I do concur. I was taking a stab in
the
dark
thanks, and I look forward to any input.
--
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
update any records.
Thanks for the help.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
of password for a user called starsky!
--
*Chris Tate-Davies*
*Software Development*
Inflight Productions Ltd
Telephone: 01295 269 680
15 Stukeley Street | London | WC2B 5LT
*Email:*chris.tatedav...@inflightproductions.com
mailto:chris.tatedav...@inflightproductions.com
*Web:*www.inflightproductions.com
: [FAILED]
Nothing at all is written to the error log.
But if I start it with mysqld_safe it comes up and works fine.
Anyone know what could be going on here?
-larry
--
*Chris Tate-Davies*
*Software Development*
Inflight Productions Ltd
Telephone: 01295 269 680
15
On 06/02/12 13:33, Larry Martell wrote:
On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com wrote:
Have you tried:
mysql --verbose -uusername -ppassword
To output more information
When would I use that? If I try to start it with 'service mysqld
start
On 06/02/12 14:34, Reindl Harald wrote:
Am 06.02.2012 15:28, schrieb Chris Tate-Davies:
On 06/02/12 13:33, Larry Martell wrote:
On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
chris.tatedav...@inflightproductions.com wrote:
Have you tried:
mysql --verbose -uusername -ppassword
On 10/01/12 15:41, Chris Tate-Davies wrote:
On 10/01/12 13:34, Johan De Meersman wrote:
- Original Message -
From: Johnny Withersjoh...@pixelated.net
Security through obscurity?
That sentence has been overused way too much. If you want to remove
all obscurity from your security, just
that this particular layer is not the first
priority.
Indeed, have a read of http://en.wikipedia.org/wiki/Defence_in_depth
*Chris Tate-Davies*
*Software Development*
Inflight Productions Ltd
Telephone: 01295 269 680
15 Stukeley Street | London | WC2B 5LT
*Email:*chris.tatedav
displays them? it sounds to me as if the display lacks something, not so
much MySQL.
--
Chris Tate-Davies chris.tatedav...@inflightproductions.com
-
Registered Office: 15 Stukeley Street, London WC2B 5LT, England.
Registered in England number 1421223
On Fri, 2011-11-11 at 16:38 +, Mark Goodge wrote:
On 11/11/2011 16:29, Curtis Maurand wrote:
mysql select date_format(now(),'%m-%d%-%y
%h:%i:%s') AS time;
+---+
|
time
|
+---+
| 11-11-11 11:11:11 |
+---+
1 row in set
.* | gzip
/media/disk-1/Server11_MysqlBackup_15September2011/mysql_15sep2011backup.sql.gz
3)
The docs are here for mysqldump, might be worth a read:
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
HTH, Chris
On 15/09/11 06:29, Adarsh Sharma wrote:
Dear all,
Today i backup my all
Thanks,
I kinda guessed that, but I'm not sure how to pass the OLD object to it
as MySQL cannot handle a rowset datatype.
Has anyone had any experience with this? Not sure where to start or how
to proceed.
Chris
On 13/09/11 07:40, Luis Motta Campos wrote:
On 8 Sep 2011, at 16:23, Chris
reading your email, forgive me if I'm mistaken
what about serializing using *concat(old.f1,'|||',old.f2,'|||',old.f3)
('|||' = any separator that works for you)*
and deserialize inside the function?
does this make any sense to you?
Cheers
Claudio
2011/9/13 Chris Tate-Davieschris.tatedav
Hello. I want to know if there is a special way I can access all the
data in the NEW/OLD data?
I realise I can access it by referencing NEW.fieldname but I want to
serialise the NEW object so I can save as a string. Is this possible or
do I need to write a function?
Thanks, Chris
*Chris
might want to look at QIF Master. Generally designed to convert lists
of data into QIF formats but Mr. Wooward may have some other tools to
go the other way also.
c
On Aug 11, 2011, at 5:02 PM, David Brian Chait wrote:
I don't think I have ever heard of anyone directly importing a QIF
to someones home, knocking on their door,
and asking, Where do you live?
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
days for no apparent reason
what so ever, and everytime it repairs successfully...
--
Chris.
On Tue, Nov 30, 2010 at 1:20 PM, Mark Goodge m...@good-stuff.co.uk wrote:
Hi,
I have a very strange problem whereby one particular table in our database
is repeatedly (on average, every couple
not do that. Is there a standard way to get around this
and have it sort by the non-formatted time value?
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
to read/ understand if you second
condition is rewritten like this...
AND CURDATE() = announcements_postdate
Just my opinion on that.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
key does that for you.
Chris W
On 9/17/2010 1:28 PM, Elim PDT wrote:
I got a file of the list of the 1st 1270607 prime numbers (the
1270607th prime is 1999,
beat the $227 book at
http://www.amazon.com/prime-numbers-Carnegie-institution-Washington/dp/B0006AH1S8).
the file is an output
messages.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
. However in this situation it will be unique. I
can't put a unique key on this field in the second table because there
are other applications of the second table where I do need it to non
unique.
Hope that makes sense.
Chris W
--
MySQL General Mailing List
For list archives: http
If you want C to always be A-B then it would, in my opinion, be a very
bad idea to store C in the table. Instead you can just put C in your query.
SELECT `A`, `B`, `A` - `B` AS `C` FROM `table`
If that seems like a hassle, you could always create a view using that
select.
Chris W
b
number of digits after the decimal point.
So why would you even want to do this is?
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
queries are written.
CREATE TABLE `patnotes` (
`patid` INT UNSIGNED NOT NULL,
`patnote` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`parentid` INT UNSIGNED NOT NULL ,
`appuserid` VARCHAR(40) NOT NULL,
`subject` VARCHAR(100) NOT NULL,
`body` LONGTEXT NOT NULL,
PRIMARY KEY(`patnote`))
Chris W
dennis
||
||5|| 19|| 23 ||
||5|| 19|| 23 ||
Like I said, this should be pretty obvious to everyone but me.
chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
With out the table definitions, I'm not sure how anyone could help. Can
you send the output of show create table for each of the tables
involved in this query?
Chris W
Keith Clark wrote:
I'm trying to produce a report that will tell me how many products were
available with a Quantity0
SELECT COUNT(EntryID) FROM IVAOData; ## Grows by a few thousand
records per day.
++
| COUNT(EntryID) |
++
| 13130747 |
++
1 row in set (0.00 sec)
--
Regards,
Chris Knipe
...
RAM Size on the machine is 8GB...
Regards,
Chris.
On Fri, May 7, 2010 at 9:17 AM, Anirudh Sundar sundar.anir...@gmail.comwrote:
Hey Chris,
Please send the explain plan for this query, the estimated table sizes (in
MB or GB) and the RAM capacity.
These are also the requisites for helping
running... 3948 Seconds the last time I checked...
--
Regards,
Chris Knipe
been created.
Thanks for the assistance.
--
Regards,
Chris Knipe
. Surely there is some way to make InnoDB faster.
Any ideas?
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
is if you keep the full revision history. Although I
suppose that if you were to keep say the most recent X revisions then
the last revision would always be in the table and max could work where
count would not always.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Sorry I misspoke, I am doing updates not inserts. If I was doing
inserts I thought about the multiple record at a time idea but unless
there is something I don't know, I don't think you can do that with
updates. I will look into turning autocommit off and see what that does.
Chris W
I have no idea how you got here but there is no reason to do it that
way. This will work just fine and I do it every day in php.
However I don't use mysqli I still use ...
mysql_connect
mysql_select_db
mysql_real_escape_string
mysql_query
Don't forget to use the mysql_real_escape_string
.`LinkType` = '$LinkType'
AND u.`ID` = '$UserID' AND l.`ID` = '$ID'
AND g.`Active`
Is there any way merge these into one query?
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
the condition into a temp table. Then I
could join that temp table to other tables do other queries I may need
on those points.
Chris W
Werner Van Belle wrote:
Hello,
I have been pondering this for a while, but never really looked deeply
into the problem.
I have 96 dimensional points and I
`)
WHERE `FNumber` = '1' AND `Date` = '2010-03-02'
If id, id2 and or type change over time and you need to keep track of
that you could add those fields in this table.
Chris W
Steven Staples wrote:
Hi there,
I currently store some information about a users daily habits in a table.
The table has 4
of using the NOT IN syntax, which I understand can
be slow, you can modify the where condition to find points that are
inside the current cube of size r but are outside the previous cube.
Chris W
Werner Van Belle wrote:
Hello Chris,
The use case I'
m talking about is actually a typical usecase
I changed the names slightly when I tested it but here is the query that
gives the result you want...
SELECT a.`AccountID`, a.`company`, sum(h.hits), count(h.AccountID),
sum(h.hits)/count(h.AccountID) AS AvgHits
FROM account a
JOIN hitsperday h using (AccountID)
WHERE `date` DATE(now()) AND
)
Chris W
Stephane MAGAND wrote:
Hi
i am debutant in SQL and i am search to know if it's possible:
My SQL requets:
UPDATE Table_Logs_Summary SET
mails_recus=(mails_recus+1),mail_rbl=(mail_rbl+1) WHERE dom_id=4 AND
Date_Start=2010-03-16 06:00:00 AND Date_End=2010-03-16 06:59:59;
I wan't know
I'm not sure this is the best solution, but whenever I am inserting a
lot of records with the possibility of some of those records already
existing and I have no reason to update the existing records with new
data, I use 'INSERT IGNORE'. I'm not sure if that will 'ignore' other
errors that
are actually writing queries
with that many joins don't have a solid grasp of the fundamental
principles of relational database design.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mySQL-5.1.34-osx10.4-powerpc-64bit
Not sure how this happened, but mySql will not start anymore, either
from the command line or the system pref control panel.
here's a startup sample: [I have blocked out the password]
Power-Mac-G5:/usr/local/mysql chriselhardt$ sudo /usr/local/mysql/bin/
as described above a Many to Many link requires a table to
link to tables together having the two keys in it that relate to the two
tables being linked.
That's it for me tonight, everyone feel free to criticize at will.
Chris W
p.s. I don't mean to discourage the criticizing but a few notes about
Unless I am missing something, this should work.
SELECT DISTINCT X FROM `A`
WHERE Y IN (25)
AND Y NOT IN (24)
Chris W
Tim Molter wrote:
I'm new to MySQL and I'm looking for some guidance. I have a table A,
with two columns X and Y with the following data:
| X|Y|
1
to be updated therefor to accept longer
variables in the sizes column.
--
Regards,
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
have looked through the PHP docs and can't seem to
find it. Of course I could be blind.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I'm working in an environment where I have two similar servers, one
running production the other for development. They're not very
dissimilar - both run 4.1.20-log, both run CentOS 4.
The development server has a cut-down snapshot of the production
database, and it's where we ... well, develop
Perhaps some clues here: I started taking the problem query apart to see
what slows things down. I found a culprit, but I don't understand:
mysql select count(*) from Crumb where customer_id=380 and Actual_Time BETWEEN
'2009-06-01 00:00' AND '2009-06-02 00:00' and ErrorCode = 0;
+--+
|
Andrew Carlson said:
I know this is basic, but check that you recreated the indexes after you
reloaded the snapshot. That has bit me before.
I used myisamchk -r on the large table, and it has made a huge difference.
I had used myisamchk before to check the table and got no complaints.
in the study table.
So I can do a simple select like this
SELECT ProfileID, p.`Date` as `BadDate`, s.`Date` as `GoodDate`
FROM profile JOIN study USING (`StudyID`)
Of course study to profile is a one to many relationship. How do I run
an update to set p.`Date` equal to s.`Date`?
Chris W
;
update t2 set fk=fk+10 where fk 10;
That's saved me from a few unexpected consequences.
Cheers,
Chris.
-
Chris Clarke
Principal Consultant
C4 Consulting
High performance IT solutions
http://cfourconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Why not write a simple script that scans every record and inserts them
into the proper table one at a time?
In php for example..
$query = SELECT * \n;
$query .= FROM `X` \n;
$result = mysql_query($query);
while(($row = mysql_fetch_array($result, MYSQL_ASSOC))){
$Values = ;
foreach($row as
what they are going
to be doing. Also having the separate table to link employees and
departments allows for a many to many relationship, so an employee can
work in more than one department. I'll leave the discussion for how bad
an idea that is for another list :)
Chris W
--
MySQL General
if there is a
programmatic way of transferring the data to MySQL. Any help or insight
would be appreciated, I have been away from coding for several years because
of health issues and I'm trying to knock the rust off my brain and get going
again.
Chris Rehm
ch...@javadisciple.com
--
MySQL General
on the server is touching this table at the
moment. The exact date_format is not important, as I may want to group
by 5 second intervals, or full months.
Any tips/ideas for me?
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Aha! I get it! I *was* being an idiot. The longitude of @g1 is 12*2*, not 121...
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
find anything in the bug database.
Oddly enough, some other similar queries work as expected, so I'm at a loss.
Help?
Thanks,
chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is between 37.428 and 37.437
The points on the polygon are arranged LL, LR, UR, UL, LL of
a rectangle:
37.437 -121.157537.437 -121.1485
37.428 -121.157537.428 -121.1485
What am I missing?
Best,
chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
in one day just that it happened at least once on that day
for a user.
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have no idea what I was thinking. For some reason I was thinking
Distinct wouldn't work, must have been temporarily brain dead. Thanks
for the wake up call.
Gerald L. Clark wrote:
Chris W wrote:
I have two tables, one is a list of users and the other is a list of
events for each user
Not sure how someone can intelligently comment on your table structure
when you haven't given any details of the data you are storing. In my
experience, the fact that you have 75 fields in your table is a strong
indicator that your data is not normalized. If that is the case you
tables are
want it to be.
Mark
Can you elaborate on that point? Do you not use auto-increment values
to link records in a one to many relationship?
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
would be kind of like giving a 16 year old
kid the keys to a 200mph race car and say have fun. Sooner or later
something bad is going to happen. Just my opinion.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org
the joins?
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater Database.
http://hrrdb.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
with predefined
pathways.
Can't really argue with that.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater Database.
http://hrrdb.com
--
MySQL General Mailing List
For list archives: http
data I can't say for
sure but I am guessing a group by *might* be needed.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater Database.
http://hrrdb.com
--
MySQL General Mailing List
Jerry Schwartz wrote:
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 12:25 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Match/No Match query
Jerry Schwartz wrote:
I have a list of codes. Some, but not all, of these codes will match
Hello,
I _thought_ I knew how InnoDB worked, but due to a recent mysql doc
change, I am no longer sure--the change made the dox significantly
less clear, and potentially code-breaking.
Please can someone tell me the real behavior of InnoDB in the
following case, and ideally clarify the dox
the
spatial index (Rtree) be able to achieve this?
Are there any good tutorials (or heaven forbid, books) that anyone can suggest?
Should I go hang out with the cool kids that are using postGIS ;)
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater Database.
http://hrrdb.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
it.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater Database.
http://hrrdb.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
this query faster?
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater Database.
http://hrrdb.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Yves Goergen wrote:
On 06.02.2008 08:12 CE(S)T, Chris wrote:
Yves Goergen wrote:
My goal was to copy some potentially large BLOB from one record to
another in the same table
Update table set blob2_field=blob1_field;
This does something totally different. ;) See my first posting why.
Ah
be
faster. Take every record in the dupes table and then use the index in
the buglog table to find the row that matches the LogID.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater
Yves Goergen wrote:
On 05.02.2008 23:25 CE(S)T, Baron Schwartz wrote:
You can't select from a table you're updating at the same time. What
at the same time means is a bit unclear unless you're one of the
MySQL developers ;-)
Yes, Paul DuBois already replied to me off-list. Now I found that
is to add the index with your create temporary table
statement and then do an ...
INSERT INTO dupes (SELECT .)
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater Database.
http://hrrdb.com
Ivan Levchenko wrote:
Hi All,
What would be the best way to transfer a 20 gig db from one host to another?
mysqldump -A file.dump
tar -jcf file.dump
rsync
or use replication to do it (might take a bit longer this way though).
--
MySQL General Mailing List
For list archives:
mysql mysql wrote:
Thanks for the response Chris, although I can't seem to reproduce the
problem now, but I'm sure you're right.
There's something else strange that I've encountered while trying to
optimize this query. I've got two machines, dev and production. After
adding the index
mysql mysql wrote:
Can anyone explain the following? I encountered the following very strange
behaviour while attempting to optimize a query (more details are provided
later on for those interested):
1) execute query
takes 2 minutes
2) add index
3) execute same query
takes 11 seconds
4) drop
1 - 100 of 2034 matches
Mail list logo