Re: Mysql, Need extra Cash? - Get Paid in 48hrs - Home Reps Needed.Com home representatives are required!

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 Database Applications

Re: Any way to make a top ten query?

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/manual.php (the manual

Re: is there a MySQL 'field contains' function

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, Database Applications Developer | Omnia Mutantur, Systems Group - Harvard Law School

Re: A small SQL query problem

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 | Omnia Mutantur, Systems Group - Harvard Law School | Nihil Interit

Re: time zones?

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 Klein, Database Applications Developer | Omnia Mutantur, Systems Group - Harvard Law School

Re: Char vs Varchar field types

. 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 Group - Harvard Law School

Re: MySQL Power ?

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=708a=23115,00.asp -- John Klein, Database Applications Developer | Omnia Mutantur, Systems Group - Harvard Law

Re: Tricky Query...

, 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. -- John Klein, Database Applications Developer | Omnia Mutantur, Systems Group - Harvard Law School | Nihil Interit

Re: Keeping MySQL Databases Heathly

($outstring); } -- John Klein, Database Applications Developer | Omnia Mutantur, Systems Group - Harvard Law School | Nihil Interit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Query help

, 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 - Before posting

Redefining data area

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 | Nihil Interit