ANN: Advanced Data Generator 3.3.0 released

2014-12-17 Thread Martijn Tonies (Upscene Productions)
on www.upscene.com Pricing information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=newsid=20141217 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com

Re: mysql float data type

2014-12-17 Thread Lucio Chiappetti
On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote: On 16.12.2014 15:16, xiangdongzou wrote: Can anyone tell me why 531808.11 has been changed to 531808.12 ? typical decimal-binary-decimal conversion/rounding error. never used DECIMAL nor intend to, but the issue is typical of precision

Re: mysql float data type

2014-12-17 Thread Patrick Sherrill
We always store as strings to avoid rounding issues and then convert for calcs to whatever precision we need. Pat... Sent from my iPhone On Dec 17, 2014, at 6:24 AM, Lucio Chiappetti lu...@lambrate.inaf.it wrote: On Tue, 16 Dec 2014, Hartmut Holzgraefe wrote: On 16.12.2014 15:16,

Re: mysql float data type

2014-12-17 Thread Hartmut Holzgraefe
On 17 December 2014 14:21:40 CET, Patrick Sherrill patr...@michael-clarke.com wrote: We always store as strings to avoid rounding issues and then convert for calcs to whatever precision we need. Pat... So you'll still be affected by rounding errors during conversion and calculation, two

Re: Function

2014-12-17 Thread shawn l.green
On 12/12/2014 2:38 PM, Alexander Syvak wrote: Hello! How is actually a function done internally in MySQL after CREATE FUNCTION statement? Why can't there be a dynamic SQL inside a function? Sorry for the delay. The answer is embedded in this description of what is or is not allowed

Re: DB redolog

2014-12-17 Thread shawn l.green
Hi Frank, On 12/17/2014 2:11 AM, xiangdongzou wrote: 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? While

Re: forum vs email

2014-12-17 Thread Ruben Safir
they are no indexing usenet any longer which is a real problem because of volumns of archival information on them from everything from SQL theory to networking commands. It is depressing almost as depressing as the university library with stacks of books on the floors pushed away to make