Re: Selecting rows by DATE ranges

2007-06-23 Thread Pintér Tibor
date(), date_format() t Miguel Cardenas írta: Hello list I found a little problem with an application am developing, in particular creating reports by DATE ranges. Examples: select ... where date>"2007-01-01"; returns all records where date is greater (and equal inclusive) to 2007-01-01 s

Accented characters in InnoDB tables?

2007-06-23 Thread patrick
Do you have to do something special with InnoDB tables to accept various character sets like accented, European characters? Using the default, these accented characters come out as garbage. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lis

Selecting rows by DATE ranges

2007-06-23 Thread Miguel Cardenas
Hello list I found a little problem with an application am developing, in particular creating reports by DATE ranges. Examples: select ... where date>"2007-01-01"; returns all records where date is greater (and equal inclusive) to 2007-01-01 select ... where date>="2007-01-01"; returns all rec

how can i set configurations variables per user ?

2007-06-23 Thread Amr Elgbaly
Hello ! how can i set mysql configurations variables per user for example i want limit connections per user to 50 and exclude some users from this limitation Regards , :) -- ِAmr Elgbaly, GNU/Linux system Engineer

Re: duplicate key question

2007-06-23 Thread Steve Edberg
At 10:19 PM -0500 6/22/07, Chris W wrote: when you get a duplicate key error it says something to the effect of "Duplicate entry 'xyz' for key x" What I want to know is how to find out what table fields are part of key x? 'show index' is what you want, I think: http://dev.mysql.com/doc/refma