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
Note the huge estimated number of rows. That should decline significantly.
What's the value of key_buffer_size? It should generally be 20% of
_available_ RAM (for MyISAM usage).
-Original Message-
From: James W. McNeely [mailto:jmcne...@nwrads.com]
Sent: Wednesday, November 14, 2012
I have a query I'm having trouble with. If do this query which is DATE plus
ProcModecode, it is very fast:
SELECT e.zzk FROM exams e
-- JOIN Appt_ a ON e.IdAppt = a.IdAppt
-- JOIN Affil_ af ON a.IdAffil_primary = af.IdAffil
WHERE e.dateexam = '2012-09-01' AND e.dateexam = '2012-09-30'
AND
) -- in that order
(I can't predict which index it would use.)
Are IdAppt the same datatype and collation in each table?
-Original Message-
From: James W. McNeely [mailto:jmcne...@nwrads.com]
Sent: Wednesday, November 14, 2012 2:34 PM
To: mysql@lists.mysql.com
Subject: query tuning
I have
When creating a record, the first field (KeyField)...
KeyFieldBIGINT UNSIGNED NOT NULL AUTO_INCREMENT
...is it possible to copy this auto-generated value into
another field when using the same INSERT that creates the record?
Or would I have to use an UPDATE query using
At 02:44 10/17/2012, Claudio Nanni, wrote:
Take a look at TRIGGERS
C.
PS: I am curious to know why you would do that anyway
Will want this 'AssociatedWith' field to be associated
with an older records' KeyField so I can search for a
group of records by this field.
Start Here to Find It
that rely on that first record's
`KeyField`.
PS: I am curious to know why you would do that anyway
2012/10/17 W. D. w...@us-webmasters.com
When creating a record, the first field (KeyField)...
KeyFieldBIGINT UNSIGNED NOT NULL AUTO_INCREMENT
...is it possible to copy this auto
I am working on a view based on this query:
===
SELECT
-- Patient Info
p.IdPatient,
p.IdLastword MRN,
p.NameLast,
p.NameFirst,
p.Addr1,
p.Addr2,
p.AddrCity,
p.AddrState,
p.AddrZip,
p.Gender,
p.DateOfBirth,
-- Provider Info
af.IdAffil,
af.PractName,
difference between the two.
Jim McNeely
On Aug 23, 2012, at 12:39 PM, Shawn Green wrote:
On 8/23/2012 2:30 PM, James W. McNeely wrote:
I am working on a view based on this query:
===
SELECT
-- Patient Info
p.IdPatient,
p.IdLastword MRN,
p.NameLast
This didn't help, but good try!
Jim McNeely
On Aug 23, 2012, at 12:27 PM, Martin Gainty wrote:
If memory serves predicates convert strings to column-data-type (in your case
DATE) this *should* help
WHERE dateexam = STR_TO_DATE('2012-08-13','%Y-%m-%d')
does this help?
Martin
I think I'll just make a nightly process run that drops and then recreates the
table, unless someone has a workable idea of how to make this view query-able.
Thanks!
Jim McNeely
On Aug 23, 2012, at 2:06 PM, James W. McNeely wrote:
This didn't help, but good try!
Jim McNeely
On Aug 23
My backups from a mysqldump process are useless, because the dump files are not
escaping single quotes in the data in the fields.
So, O'Brien kills it - instead of spitting out
'O\'Brien'
it spits out
'O'Brien'
I don't see anywhere in the documentation about mysqldump where you can tweak
Hi,
I asked this question over on stackoverflow - basically I have a query
and when using EXPLAIN I see that around 2400 rows are still being
scanned. I'd added various indexes but it cannot make it perform any
better.
I would appreciate if anyone has any further ideas?
We've been experimenting with the merge engine.
But suppose that instead of using the MERGE engine I instead modified my
code to UNION ALL the shards.
Would I get worse performance? In other words, besides the convenience,
does the MERGE engine have specific performance optimizations that
We are currently evaluating the merge engine. Right now we create and
preload several index caches.
But what is the best way to approach this with a merged table? Do I
create a single index cache and assign all of the shards to it?
Or do I create a separate index cache for each shard?
I
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
This guy has been saying nothing meaningful on this list, but
advertise his blog everywhere.
Just be shame. He should be kicked out from the list.
Jorg.
2010/12/23 杨涛涛 david.y...@actionsky.com:
This way is very well, but it has to do lots of human work.
David Yeung, In China, Beijing.
My
Hi,
I'm running mysql 5.1.37 for ubuntu 9.10 (64 bits OS).
I installed mysqld with apt-get, and going with /etc/init.d/mysql for
start/stop the server.
I can start mysql server successfully, but can't stop the server with
/etc/init.d/mysql stop. The error message is:
Nov 30 10:46:05 kickseed
2010/11/30 Johan De Meersman vegiv...@tuxera.be:
Yep, it's definitely an apparmor issue. Are you using your distribution's
packages ? I would say this is more a thing for their support - I for one
keep as far away from apparmor as I can :-)
yep I 'm using the distribution packages all from
Hello,
I have a question about the execution cycle of LOAD DATA INFILE.
If I issue a large file via LDI LOCAL, I know that the file is copied to
the MySQL server and executed there.
But at what point does the statement finish from the sender's point of view?
1) When the file is successfully
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
Charlene wrote:
Anybody have any idea why MySQL would start to have this error message
every 4 or so days at midnight:
Do look at the logs, but if the error always occurs at midnight, you
might look for a disk backup or compression program that's scheduled
to run than and accesses the
According to the 5.1 docs, I can have multiple key caches for MYISAM on
a 32-bit host, each with up to 4G.
But that means that each cache can take the entire address space of a
process. How does the MySQL server get around the limitation?
--
MySQL General Mailing List
For list archives:
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
. 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
Martijn Tonies wrote:
For example, the Firebird DBMS stores (longer) Blob data not right
there in the record, so whenever you don't request the blob (that is,
not selecting it), it ignores it completely and it can go through the
file quickly.
As do most of the MySQL storage engines.
Martijn Tonies wrote:
For example, the Firebird DBMS stores (longer) Blob data not right
there in the record, so whenever you don't request the blob (that is,
not selecting it), it ignores it completely and it can go through the file
quickly.
As do most of the MySQL storage engines.
Cheers,
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
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
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
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
Hello,
I would like to do a select on a table to get back the IDs of some of
the records.
Then take those IDs and do a single update using a WHERE clause like
(recordID IN (2,44,21))
My question is:
Can I build a string using a cursor that has all of the IDs and then
issue an update using the
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
Being rather new to all this, I understood from the MySql manual that
the auto_increment is to b e used immediately after an insertion not
intermittently. My application is for administrators (the site owner
designates) to update the database from and administration directory,
accessed by
Jerry,
To touch a little more on Claudio's statement, you are trying to compare
monkey's and trucks when you talk about mysql on these two different OS's.
Microsoft is a different best when it comes to the install.
What caught my attention though is you are running mysql 4.0 on CentOS.
Not sure that this is the problem BUT you should probably qualify the name of
the variable such that SELECT MAX(id) AS id FROM book. But you don't want
max(id) as id but rather max(id) + 1 as id. With that you can then just
return the final value. Also, if you don't want to alias the value
A few weeks back I was reading an article that said that INNODB doesn't take
adantage of servers using more than 4 processors. I think I also recieved this
as a reply some time ago as to the same thing.
I was wondering if this is indeed true. We are using 5.1.30 and wanted to
pickup a new
Truncate the time part of the datetime field when doing the compare
AND DATE_FORMAT(customer.created_dt, '%Y-%m-%d 00:00:00') BETWEEN '2008-12-30'
AND '2008-12-30'
Should work. Probably not the most efficient. The other options would be to
use take end date + 1 day, minue 1 second. That's
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
Gail,
I know the list has already recommended allowing more connections but the
bigger question is what is sucking them all up. Even with 1000 connections
things like apache can only use the number of connections that there are
processes (* the number of connections used within each
Hello,
I've been looking through the documentation/list and haven't found anything
directly on this subject. It's possible that I'm just not looking in the right
place.
I would like to log all failed authentications to the server. It would be nice
to be able to log the attempted 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
Rob Wultsch wrote:
On Tue, May 13, 2008 at 2:07 PM, Ed W [EMAIL PROTECTED] wrote:
I had naively assumed that dates would always be stored in UTC in the
database and the only effect of localtime would be for display purposes?
Can anyone shed some light on what's happening here please
then I have a bag of trouble when I want to figure out
the time something happened (as you can see c1 and c2 should be the same
in all cases, but not in your example)
Can anyone shed some light on the best approach?
Thanks
Ed W
--
MySQL General Mailing List
For list archives: http
always be stored in UTC in the
database and the only effect of localtime would be for display
purposes? Can anyone shed some light on what's happening here please?
Thanks
Ed W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
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
Baron Schwartz wrote:
Hi Ed,
On Thu, Apr 3, 2008 at 3:32 PM, Ed W [EMAIL PROTECTED] wrote:
Hi
Up until version 5.0.44 (on linux) it appeared that you could do stuff like
deliberately insert a NULL into a NOT NULL varchar field and it would be
silently converted to an empty string
changed? Innodb if
this makes a difference..
Thanks
Ed W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, but as far as I can see I don't
have the |STRICT_ALL_TABLES or ||STRICT_TRANS_TABLES options enabled
anyway..?
How can I return to the old behaviour (at least until I update my app)?
Is this change in behaviour defined anywhere?
Thanks
Ed W
|
--
MySQL General Mailing List
For list archives
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
expect.
Gary
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Thu 2/21/2008 8:06 AM
To: mysql@lists.mysql.com
Cc: Gary W. Smith; Baron Schwartz
Subject: Re: Column level replication q?
On Wed, Feb 20, 2008 at 10:48 AM, Gary W. Smith [EMAIL PROTECTED] wrote
1:19 AM
To: Gary W. Smith; mysql@lists.mysql.com
Subject: R: Column level replication q?
Of course I am talking about a materialized view, did you try?
Here some useful links:
http://forums.mysql.com/read.php?100,21746,21746#msg-21746
and from the reply in the same forum topic
by Waheed Noor
, on the other end, we don't even need to have the same table names. So
we can replicate it just like this with no problem.
Thanks for the links,
Gary
From: Nanni Claudio [mailto:[EMAIL PROTECTED]
Sent: Wed 2/20/2008 1:19 AM
To: Gary W. Smith; mysql@lists.mysql.com
We need to replicate a table to a third part. The information in the table is
pretty much public, with the exception of one column. Is it possible to
replicate all of the tables with the exception of one column?
What I was thinking was to replication it to a 2nd machine that will limit it
).
From: [EMAIL PROTECTED] on behalf of Baron Schwartz
Sent: Tue 2/19/2008 5:15 PM
To: Gary W. Smith
Cc: mysql@lists.mysql.com
Subject: Re: Column level replication q?
Hi,
This isn't natively supported. You can hack it with replication to
a table that has a trigger
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
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
We have a master/master environment that has tables in innodb. We want to
setup a slave that will be used for reporting and some other stuff as well. We
want to use MyISAM as the engine on the slave'd server.
Since all of the table creations are also part of the replication, is it
possible
You can set the default storage engine on each of the servers and then
don't declare it explicitly in any CREATE TABLE statements.
This seems like the most viable option. Since almost all of the remote
tables are created with INNODB it should work fine. I do have one table
that isn't but we
),
(3,NULL),
(3,NULL);
--
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 many
relationship table and in that case neither field is auto increment.
--
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
TABLE `t` (
`p` int(10) unsigned NOT NULL default '0',
`q` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`p`,`q`)
) ;
--
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
happened with in say 10 seconds. So my group by would be more like..
GROUP BY CreateDate +- 10 SECOND
Is there a way to do this?
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Ham Radio Repeater
.FName AND u1.LName = u2.LName
LEFT OUTER JOIN userprofile p ON u1.UserID = p.UserID
GROUP BY u1.UserID
HAVING `Count` 1
ORDER BY u1.LName, u1.FName
However that returns rows that are not duplicate names and I'm not sure why.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM
to match of FName and
LName. I tried to use concat to build the full name and do the not in
based on the new field MySQL didn't like that query at all.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Gift Giving Made Easy
Get the gifts you want
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http
variable.
--
Chris W
KE5GIX
Protect your digital freedom and privacy, eliminate DRM,
learn more at http://www.defectivebydesign.org/what_is_drm;
Gift Giving Made Easy
Get the gifts you want
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http
Mathieu Bruneau wrote:
I never tried the falcon engine, but could it be that mysql is running
out of file descriptor ?
That's less likely with Falcon than with engines that put each
table and index in its own file. By default, Falcon tables share
a single tablespace.
Regards,
Ann
--
Mariella Petrini wrote:
...MySQL 6.0.2 with Falcon on Linux with Debian 4.
I have compiled the source code for 64 bit executable.
The system is an Intel 2 cpus 4 cores each, with 8 GB
of RAM.
After having created
approximately 8,500 empty tables mysqld server was
still alive, you could
Hello list
I have doubt on TEXT data types... Checking my notes I see these ones:
TINYTEXT/TINYBLOB (2^8) 255 chars
TEXT/BLOB (2^16) 64K chars
MEDIUMTEXT/MEDIUMBLOB (2^24) 16M chars
LONGTEXT/LONGBLOB (2^32) chars
Well, my doubt consist on this... are these FIXED lengths for the text
for generating Statutory reports. Also cluster can not be a solution
as
it
requires min. 100 MB network.
Says who?
But clustering won't help. You are looking for active/active, which
could be accomplished but this would possibly lead to specific conflicts
if people are trying to edit the
Rick James wrote:
Instead I broke blobs into pieces, inserting them with a sequence number.
Understanding the underlying problem, that still seems like an
unnatural way to store pictures and documents.
Added benefit: Does not clog up replication while huge single-insert is
being copied
1 - 100 of 761 matches
Mail list logo