Re: Query to get count of ages

2006-09-19 Thread Anders Lundgren
e; but MySQL Query Browser says: Unknown column 'age' in 'field list' 1054 What am I doing wrong? How can I count ages? -- Anders Lundgren Viba IT Handelsbolag Web: http://www.vibait.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: debian installation

2006-09-21 Thread Anders Lundgren
someone outline step by step instructions on how to install the latest mysql on debian? my version of debian is debian-31r3-i386-netinst (sarge) thanks. -- Anders Lundgren Viba IT Handelsbolag Web: http://www.vibait.se -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: moving to other web server

2006-10-11 Thread Anders Lundgren
olumn 'f.id' in 'on clause' The alias seem not working? What should I do, I dont want to rewrite all my sql statement.... Thanks. Jason -- Anders Lundgren Master Software Engineer Viba IT Handelsbolag Web: http://www.vibait.se [EMAIL PROTECTED] wrote: hi, currently us

Re: Grant privs to multiple tables at once?

2006-10-12 Thread Anders Lundgren
I think you should try % that is used as wildcard instead for one or many characters. Granting on 'foo_%' might work. Regards, Anders -- Anders Lundgren Master Software Engineer Viba IT Handelsbolag Web: http://www.vibait.se David Felio wrote: Assume database 'biggie' w

Re: Date v. DateTime index performance

2007-01-09 Thread Anders Lundgren
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Anders Lundgren Viba IT Handelsbolag Webb: http://www.vibait.se E-post: [EMAIL PROTECTED] Mobil: 070-55 99 589 -- MySQL General Mailing List For l

Re: Date v. DateTime index performance

2007-01-10 Thread Anders Lundgren
OK, thank you. How is the speed of this index compared with an indexed date column if I do: year_number='x' and month_number='y' and day_number='z'; They should have about the same cardinality, right? Thanks, Anders Chris wrote: Anders Lundgren wrote: > O

Re: Date v. DateTime index performance

2007-01-10 Thread Anders Lundgren
ay of the month and < the first day of the next month. That will use an index. - Original Message - From: "Anders Lundgren" <[EMAIL PROTECTED]> To: "Dan Buettner" <[EMAIL PROTECTED]> Cc: "Thomas Bolioli" <[EMAIL PROTECTED]>; Sent: