On Tue, 18 Feb 2003, Virdhagriswaran SHIBATA wrote:
> Mysql, your immediate help is needed. We are a .com
> corporation that is growing fast (over 1000% per year). We simply cannot
> keep up with demand.
Remind me again why we bother with a spam filter?
--
John Klein
FROM mountain ORDER BY height desc LIMIT 10;
--
John Klein, Database Applications Developer | Omnia Mutantur,
Systems Group - Harvard Law School | Nihil Interit
-
Before posting, please check:
http://www.mysql.com/ma
cause
it's more useful in Perl-land to have an epoch time value. It might be
worthwile to have some way of retreiving a timestamp as an epoch value in
addition to other fifty ways you can currently retrieve it. (If there
already is a way, I'd be thrilled to hear about it.)
--
John Klei
d,a.title,a.date,a.summary,COUNT(c.id) AS comments
FROM articles AS a
LEFT JOIN article_comments AS c
ON a.article_id = c.article_id
GROUP BY a.article_id,a.title,a.date,a.summary
ORDER BY a.date DESC
LIMIT 3
--
John Klein, Database Applications Developer
ram, processor etc...?
Yes. You should do this anyway if you think you're going to be searching
by those a lot, since it'll be more efficient that way.
(In fact, you should make another table for computer types, colors,
processor types, etc, and join the two together.)
--
John Klein, D
be exactly the same length. And it would be more appropriate to
store the name of the hardware component as a varchar, since that would be
a different length for each record.
Also: query, query, sql. Blasted filter.
--
John Klein, Database Applications Developer | Omnia Mutantur,
Systems
to apply only to one server, put it in that
server's data area (e.g. /usr/local/mysql/var/my.cnf). So basically you'd
have an /etc/my.cnf for global options and then a couple of my.cnfs for
the two seperate servers in the appropriate data areas.
--
John Klein, Database Applications Develop
fake DB like yours and experiment with it.
...
...
Here we go, this seems to work:
SELECT t1.clientid, max(t1.revision) as maxrev, t2.revision, t2.name,
t2.address FROM foobar t1, foobar t2 WHERE t1.clientid=t2.clientid GROUP
BY clientid, revision HAVING maxrev=revision;
See if that helps any.
--
J
irements. Is mySQL too basic
> for these capabilities?
>
> Pros and Cons, please. This should help settle an internal debate that is
> raging!
Something from the MySQL front page:
http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp
--
John Klein, Database Applications Dev
the current behavior, though, try:
select [fields] from [table] where concat([firstname],[lastname]) is
[value];
--
John Klein, Database Applications Developer | Omnia Mutantur,
Systems Group - Harvard Law School | Nihil Interit
->[1]\"";
}
print STATFILE "\n";
close (STATFILE);
$dbh->disconnect;
## END
sub makeheader {
my $outstring = '"Year","Month","Day","Hour","Minute"';
my $sth = $dbh->prepare('show status');
I
don't have to worry about someone sneakily starting MySQL without
safe_mysqld (with terrifying and sexy results).
--
John Klein, Database Applications Developer | Omnia Mutantur,
Systems Group - Harvard Law School
12 matches
Mail list logo
