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:
>&
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
sing GREATEST, shouldnâ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/mys
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...
ough :-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 side :-)
>>>
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
wrote:
>
> and yet, both of those messages made it through :-p
>
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
L | NULL | | BTREE | |
|
+--++--+--+--+---+-+--++--++-+---+
2 rows in set (0.00 sec)
--
Regards,
Chris Knipe
a j E i Q A \t d d H
030 6 E v \n
Any other 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 ap
-+
| id | customer_id | group_id | created |
+-+-+--+-+
| 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
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;
mysq
s from 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:
uthorised hosts are permitted to connect, all users
are authenticating by password and IP (%)
--
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
d the mythology behind in order to be able to change the
other queries as well...
MANY thanks for the assistance :-)
--
Chris.
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman wrote:
> - Original Message -
>> From: "Chris Knipe"
>> To: mysql@lists.mysql.com
>> Sent: Thursday, 24 July, 2014 11:17:50 AM
>> Subject: Avoiding table scans...
>>
>> mysql>
it
can't get any 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
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
will have seeks.
>>
>>No, adding more RAM won't help much. Here's an argument:
>>Suppose your data is 20 times as big as the buffer pool and you are
>>doing random fetches (MD5, etc). Then 1/20 of fetches are cached; 95%
>>cache miss. Estimated time: 0.95
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 wrote:
> Hey Chris,
>
> I'm afraid that this is not what databases ar
ere?
Many 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
ecords or don't 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
t of scripts?
PS. IMO hutch is terrible choice 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
<m
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
wrote:
Have you tried:
mysql --verbose -u -p
To output more information
When would I use that? If I try to
On 06/02/12 13:33, Larry Martell wrote:
On Mon, Feb 6, 2012 at 2:38 AM, Chris Tate-Davies
wrote:
Have you tried:
mysql --verbose -u -p
To output more information
When would I use that? If I try to start it with 'service mysqld
start' it fails to start.
From terminal comman
: [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 Stukeley Street
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...@inflightprodu
On 10/01/12 15:41, Chris Tate-Davies wrote:
On 10/01/12 13:34, Johan De Meersman wrote:
- Original Message -
From: "Johnny Withers"
Security through obscurity?
That sentence has been overused way too much. If you want to remove
all obscurity from your security, just pu
I'm just getting square boxes.
> <<<<<<<<
> What displays them? it sounds to me as if the display lacks something, not so
> much MySQL.
>
>
--
Chris Tate-Davies
-
Registered Office: 15 Stukeley Street, London WC2B 5
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 |
> > +
toignore.* | 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 ba
quick 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
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,
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
in
ng 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 wrote:
> Hi,
>
> I have a very strange problem whereby one particular table in our database
> is repeatedly (on average, every couple of days
e` ASC
Also to me it just makes it easier 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
uld rather 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
e
primary 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 o
p by displaying raw error 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:
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
use upper case letters as that is the standard way
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 N
right with the sane 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
23 ||
||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/mys
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
availab
way to do it.
I'll rethink this a bit more and come up with something better.
PS - Started the query before my first email was even posted, it's still
running... 3948 Seconds the last time I checked...
--
Regards,
Chris Knipe
hs worth
of data in the table...
RAM Size on the machine is 8GB...
Regards,
Chris.
On Fri, May 7, 2010 at 9:17 AM, Anirudh Sundar wrote:
>
> Hey Chris,
>
> Please send the explain plan for this query, the estimated table sizes (in
> MB or GB) and the RAM capacity.
>
> These a
--++---+-+--++--++-+
8 rows in set (0.00 sec)
mysql> SELECT COUNT(FlightID) FROM FlightRoutes; ## Grows by a few houndred
records per day.
+-----+
| COUNT(FlightID) |
+-+
| 106216 |
+-+
1 row in set (0.00 sec)
mysql> 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
#x27;t see / use the FULL TEXT that has already been created.
Thanks for the assistance.
--
Regards,
Chris Knipe
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.
u 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.mys
s InnoDB so I decided to change it
to MyISAM and try again. With MyISAM I was getting around 10,000
inserts per second. 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
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 funct
in
JOIN `grouplink` l USING (`GroupID`) //Groups the LinkType, ID is in
JOIN `group` g USING (`GroupID`)
WHERE u.`LinkType` = 'user' AND l.`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 next round. Also doing
it that way, instead 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
N `dftable` d USING(`name`)
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 u
t;= $r){
print "$PointID is with in $r of test point.\n";
}
}
In an application I had that was similar (but in 2D) I would insert the
id of the points that passed the condition into a temp table. Then I
could join that temp table to other tables do other queries I may need
o
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
s+1),mail_rbl=(mail_rbl+1)
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 D
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 you
0% of the people who 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
key) in the Cart table. Though it's not needed in
the system 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 w
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/
m
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
the warning, and truncate the field.
The poster's table needs 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
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.
M
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;
+--+
| c
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
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
00 where pk < 10;
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 archive
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($r
you don't know 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 :)
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
--
MyS
vertically). Nothing else 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.co
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]
24 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/mys
x27;m running 5.0.67-community-nt ... are there any bugs in this stuff? I didn't
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]
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
times 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]
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 li
t you
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]
interface 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 Mailin
h all 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
e DB. Doing so 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.d
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
the
ving more details on your 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.
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 too...
ut doing a table scan. Would 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 privac
ncted Description field like: "Jams, Jellies, Pur".
Any idea how to solve this ?
Thanks in advance, Cor
--
Chris W
KE5GIX
"Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm";
Ham Radio Repeater Datab
y to do 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
s I have set work, if the count is 1 or larger then that
user has access to the page.
Now the question is there anything I can do to make this query faster?
--
Chris W
KE5GIX
"Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what
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
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
ther way around, it would 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/w
The easiest way 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 R
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: http://lists.my
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.
1 - 100 of 2108 matches
Mail list logo
