mysql float data type

2014-12-16 Thread xiangdongzou
HI everyone: I have created a table as flowing; create table t1(c1 float(10,2), c3 decimal(10,2)); insert two records insert into t1 values(531808.11, 9876543.12); insert into t1 values(531808.81, 9876543.12); the result is mysql select * from t1; +---++ | c1

DB redolog

2014-12-16 Thread xiangdongzou
HI all: As we know,when we shutdown the database cleanly,the database can do a checkpoint.So we don't need redo log againg.In mysql(innodb),we can restart normaly.But oracle database also need redo log group(current), why? 2014-12-17 I AM AN ORACLE FANS! Skype:Frank.oracle

回复: Re: forum vs email

2014-12-11 Thread xiangdongzou
DEAR guys: I think Email is good for search and I can download to my moible device. 2014-12-11 I AM AN ORACLE FANS! Skype:Frank.oracle Email:xiangdong...@gmail.com Name:东东堂 发件人:Mark Goodge m...@good-stuff.co.uk 发送时间:2014-12-11 17:23 主题:Re: forum vs email

回复: Incorrect Infomation in tables_priv.frm

2014-08-15 Thread xiangdongzou
DEAR john You can try rename tables_priv.frm.then restart mysql instance. If the mysql instance can restart sucessfully,you can export the production database by using mysqldump. 2014-08-15 I AM AN ORACLE FANS! Skype:Frank.oracle Email:xiangdong...@gmail.com

回复: Multi-master to one slave

2014-02-25 Thread xiangdongzou
DEAR zhang: You can use GoldenGate do that. 2014-02-25 I AM AN ORACLE FANS! Skype:Frank.oracle Email:xiangdong...@gmail.com 发件人:Zhigang Zhang zzgang2...@gmail.com 发送时间:2014-02-25 12:06 主题:Multi-master to one slave 收件人:mysqlmysql@lists.mysql.com 抄送: Does someone have the best