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
> 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 [mail
ProcModeCode, dateexam) -- 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, Novembe
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 e
be able to search on the `AssociatedWith` field
to find all records 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.
>
>> When creating a record, the first field (KeyField)...
>>
>>
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
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 LAST_INSERT_ID()
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!
>
> J
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
> ___
l any practical 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
>> --
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,
af.O
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
th
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?
http://stackoverflow.com/
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 didn
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 mak
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
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 杨涛涛 :
> This way is very well, but it has to do lots of human work.
> David Yeung, In China, Beijing.
> My First Blog:http://yuelian
2010/11/30 Johan De Meersman :
> 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 apt-get.
--
MyS
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 k
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 c
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
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 databas
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: http:
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
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
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.
InnoD
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,
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
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
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
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 s
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 :)
> 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
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 val
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. Thi
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 du
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 e
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]
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 process)
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 name
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.
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:
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
med 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?
Thanks
Ed W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
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
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
y this has 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]
ehaviour can be controlled, 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 M
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
x27;t 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
n 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
2/20/2008 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 W
).
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 t
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
to
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
> 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
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 t
quot;many 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://
),
(2,NULL),
(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://list
REATE 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&qu
s all
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
u1.FName = u2.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 d
nt 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.
--
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 o
esult 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
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 connect
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
--
My
> 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 t
ssage!
--
Chris W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 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 s
1 - 100 of 798 matches
Mail list logo
