Hello,
I have a strange problem on the charset on mysql.
I'm using mysql-5.0.45, compiled from the source, and enabled:
'--with-charset=utf8' '--with-extral-charsets=all'
when compiling it.
My default charset in my.cnf is utf8:
character-set-server=utf8
OK I logined into mysql and run:
mysql
Hi Moli,
I hope this is because there is spelling mistake. It should be *
'--with-extra-charsets=all'*, but you have given
'--with-*extral*-charsets=all'.
That's why only the utf8 has been installed and not the other charsets.
Regards,
Thiyaghu CK
www.mafiree.com
On Wed, Feb 3, 2010 at 2:26 PM,
On Wed, Feb 3, 2010 at 6:33 PM, Thiyaghu CK theyaho...@gmail.com wrote:
Hi Moli,
I hope this is because there is spelling mistake. It should be
'--with-extra-charsets=all', but you have given
'--with-extral-charsets=all'. That's why only the utf8 has been installed
and not the other
On Jan 31, 2010, at 7:35 PM, ML wrote:
Hi All,
Switching from Oracle to MySQL, I seem to be having some difficulty selecting
dates using between or even where = and = like:
SELECT * FROM orders WHERE order_date BETWEEN='2010-01-01' AND '2010-01-30'
ORDER BY order_date;
No = after
I have the following query:
select concat(weight, ' ', ids, '\n')
from (
select
tableid,
tupleid,
group_concat(id separator ' ') as ids,
(
select count(*)
from (
select transactionid
from transactionlog
where (tableid, tupleid, querytype) =
Any SQL rewriting gurus know how I might be able to optimize this
query? The schema:
mysql show columns from transactionlog;
+---+---+--+-+-++
| Field | Type | Null |