ANN: Advanced Data Generator 3.3.0 released
ANN: Advanced Data Generator 3.3.0 released Dear ladies and gentlemen, Upscene Productions is happy to announce the next release of their Windows based flexible and easy to use test data generator tool: Advanced Data Generator 3.3.0 A fast test-data generator tool that comes with a library of real-life data, can generate data to your database, SQL script or CSV files, many filling options, templates and much more. Version 3 included many new features, eg: * Unicode support in an all new fresh user interface * Ability to use external databases as the source for data * New and improved data libraries for real life like data * New template types * Much improved documentation with comprehensive How to-section This product comes in four versions: - Pro: ADO and ODBC connectivity - InterBase Edition - Firebird Edition - MySQL Edition More info and a 30-day trial version 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
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 issues among float (32-bit) and double (64-bit) in ANY programming language. Google for IEEE floating point Some (most) users are unaware that a 32-bit real (REAL*4 for oldtimer Fortran users like myself) have about 7 digits of precision, while 64-bit (doubles, double precision, REAL*8) get to about 16. So if a quantity needs high precision (typically this occurs for angular quantities where arcseconds are important), use double. -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html Do not like Firefox =29 ? Get Pale Moon ! http://www.palemoon.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql float data type
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, 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 issues among float (32-bit) and double (64-bit) in ANY programming language. Google for IEEE floating point Some (most) users are unaware that a 32-bit real (REAL*4 for oldtimer Fortran users like myself) have about 7 digits of precision, while 64-bit (doubles, double precision, REAL*8) get to about 16. So if a quantity needs high precision (typically this occurs for angular quantities where arcseconds are important), use double. -- Lucio Chiappetti - INAF/IASF - via Bassini 15 - I-20133 Milano (Italy) For more info : http://www.iasf-milano.inaf.it/~lucio/personal.html Do not like Firefox =29 ? Get Pale Moon ! http://www.palemoon.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql float data type
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 problems you'd avoid when using DECIMAL instead ... -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) MariaDB Corporation | http://www.mariadb.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Function
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 within a function: from: http://dev.mysql.com/doc/refman/5.6/en/create-procedure.html Stored functions may not contain statements that perform explicit or implicit commit or rollback. Support for these statements is not required by the SQL standard, which states that each DBMS vendor may decide whether to permit them. Since we cannot easily restrict the types of commands generated by dynamic SQL within a function, we simply disallowed those as part of the design. This and several other restrictions for functions are also listed here http://dev.mysql.com/doc/refman/5.6/en/stored-program-restrictions.html The gist of all of these restrictions is that a FUNCTION shall create the least side effects possible while generating the result value. -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: DB redolog
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 someone on this list probably knows the answer to your question, this list is in support of the MySQL database system and its related products. As you correctly identified, the InnoDB storage engine starts back up without any problems. In fact, the REDO log is there for recovery purposes only. During a normal startup following a normal or slow shutdown, it is not required at all. During a recovery restart, any transactions that were logged but not yet checkpointed into the physical data file(s) are handled then. This gives us the best chances of reaching a fully consistent state after some kind of dirty shutdown event (crash, power failure, disk failure, ...) This link describes the method that must be followed in order to erase the logs to allow the server to generate new ones on the next restart. This is usually done to change the size, number, or location of the REDO log files. http://dev.mysql.com/doc/refman/5.6/en/innodb-data-log-reconfiguration.html Please let us know if you have any other questions about MySQL. Yours, -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: forum vs email
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 room for computer terminals. Ruben On Thu, Dec 11, 2014 at 09:23:02AM +, Mark Goodge wrote: On 10/12/2014 23:40, Reindl Harald wrote: Am 10.12.2014 um 18:38 schrieb h...@tbbs.net: 2014/12/10 09:00 +0100, Johan De Meersman One of the (for me, at least) defining features of a forum, is that the subjects tend to be divided up into a tree structure, which has it's own benefits Something more sophisticated than grouping messages by trimmed subject-lines? maybe involving such header lines as were used in the old netnews (if e-mail is part of it)? every sane MUA supports threading see attached screenshot Indeed. That, to me, is one of the key arguments in favour of a mailing list: people can choose how to view the list according to their own preference (some like it threaded, others prefer a flat view based simply on message date). Other arguments in favour of email include: * Email is a push medium. I don't have to continually re-check a website to see if there's any new messages, they simply arrive in my list mailbox and I view them at my convenience. * Individual emails can be forwarded and/or saved independently of the others. * Email gives me a local archive of messages in addition to any central archive. having said that, I think that web-based archives of mailing lists can be very useful, particularly for a public list where the archive is open to search engines. That makes them a valuable historical resource as well as merely a for-the-moment discussion forum. And, if you're going to have a web-based archive, it isn't a huge step from there to add the ability to post to the list via the web as well. That can be helpful for people on corporate email systems who don't easily have the ability to subscribe to a list (or filter mail from it into a separate folder), as well as people who only need to contribute very infrequently and don't want to have to subscribe in order to do so. But all this should, IMO, be in addition to the core features of an email mailing list, rather than a replacement for them. Mark -- http://www.markgoodge.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998 http://www.mrbrklyn.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002 http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive http://www.coinhangout.com - coins! http://www.brooklyn-living.com Being so tracked is for FARM ANIMALS and and extermination camps, but incompatible with living as a free human being. -RI Safir 2013 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql