ANN: Upscene releases Database Workbench 5.6.0
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.6.0 " This new release brings you the Command Line Data Pump & Favorites feature (Pro Edition) and a few important bugfixes. Version 5.5 brought you support for the latest versions of supported database systems, that includes PostgreSQL 11, InterBase 2017 and MySQL 8. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! Here's the full list of changes http://www.upscene.com/go/?go=tracker=5.6.0=12 and for version 5.5.0 http://www.upscene.com/go/?go=tracker=5.5.0=12 For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
ANN: Database Workbench 5.5.0 released and free Lite Edition for MySQL
Upscene releases Database Workbench 5.5.0 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.5.0 " This new release brings you support for the latest versions of supported database systems, that includes PostgreSQL 11, InterBase 2017 and MySQL 8. There's also a new release of the free Lite Edition for MySQL: version 5.4.6 has been made available today. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! Here's the full list of changes http://www.upscene.com/go/?go=tracker=5.5.0=12 and for version 5.4.x http://www.upscene.com/go/?go=tracker=5.4.x=12 For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
In MySQL 8, how do you distinguish between Roles and Users in table mysql.user?
Hi there, In MySQL 8, how can you figure out if an entry in the mysql.user table is a role or a user? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
ANN: Upscene releases Database Workbench 5.4.6
Upscene releases Database Workbench 5.4.6 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.4.6 " This is a bugfix release, previous releases included support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure, a custom report writer, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! Here's the full list of changes http://www.upscene.com/go/?go=tracker=5.4.x=12 For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
ANN: Upscene releases Database Workbench 5.4.4
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.4 “ This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a custom report writer, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! Here's the full list of changes http://www.upscene.com/go/?go=tracker=5.4.x=12 For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
ANN: Stored routine debugger Hopper, version 2.0.1 released
Dear ladies and gentlemen, Upscene Productions is proud to announce version 2.0.1 of "Hopper", a stored routine debugger for InterBase, Firebird and MySQL. Major version 2 has a fully renewed user interface, support for Firebird 3 packages, stored functions, MySQL diagnostic-statements, binary data in variables and much more. For more information, see http://www.upscene.com/go/?go=news=20180627 With regards, Martijn Tonies Upscene Productions http://www.upscene.com
ANN: Upscene releases Database Workbench 5.4.2
Upscene releases Database Workbench 5.4.2 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.2 “ This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a custom report writer, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! Here's the full list of changes http://www.upscene.com/go/?go=tracker=5.4.x=12 For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
ANN: Upscene releases Database Workbench 5.4.0
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.0 " This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a custom report writer, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! Here's the full list of changes http://www.upscene.com/go/?go=tracker=5.4.0=12 For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
In MySQL 8.0, how does one recognize roles?
Hi, In MySQL 8.0, if you use CREATE ROLE, it seems to create an entry in mysql.users But how does one distinguish between roles and users? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
ANN: Upscene releases Database Workbench 5.3.4
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.3.4 " This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and adds several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! "Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions. "It added code editor features, has diagramming improvements, multiple editions, is fully HiDPI aware and offers secure connections to PostgreSQL, MySQL and MariaDB. The most recent version adds a custom report writer and increased support for PostgreSQL, as requested by many of our customers." Here's the full list of changes http://www.upscene.com/go/?go=tracker=5.3.4=12 For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
ANN: Stored routine debugger Hopper, version 2.0 released
Dear ladies and gentlemen, Upscene Productions is proud to announce version 2 of "Hopper", a stored routine debugger for InterBase, Firebird and MySQL. This version includes support for Firebird 3 packages and stored functions, MySQL diagnostic-statements, binary data in variables and much more. For more information, check the Hopper page on this website. http://www.upscene.com/stored_procedure_debugger/ About Hopper Hopper is a stored routine debugging tool for MySQL, Firebird and InterBase. If you use stored procedures on these database systems, Hopper will be a great tool for debugging these routines. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 15 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Upscene releases Database Workbench 5.3.2
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.3.2 “ This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and adds several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! "Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions. "It added code editor features, has diagramming improvements, multiple editions, is fully HiDPI aware and offers secure connections to PostgreSQL, MySQL and MariaDB. The most recent version adds a custom report writer and increased support for PostgreSQL, as requested by many of our customers." Here's the full list of changes http://www.upscene.com/go/?go=tracker=5.3.2=12 For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Upscene releases Database Workbench 5.3
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.3 " This release includes a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packges and adds several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! "Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions. "It added code editor features, has diagramming improvements, multiple editions, is fully HiDPI aware and offers secure connections to PostgreSQL, MySQL and MariaDB. The most recent version adds a custom report writer and increased support for PostgreSQL, as requested by many of our customers." For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Starting MySQL takes a long long time
Hello all, Had a normal MySQL shutdown, reboot and then this happens: 161010 10:58:30 [Note] Plugin 'FEDERATED' is disabled. 161010 10:58:31 InnoDB: The InnoDB memory heap is disabled 161010 10:58:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions 161010 10:58:31 InnoDB: Compressed tables use zlib 1.2.3 161010 10:58:32 InnoDB: Initializing buffer pool, size = 107.0M 161010 10:58:32 InnoDB: Completed initialization of buffer pool 161010 10:58:32 InnoDB: highest supported file format is Barracuda. 161010 10:58:39 InnoDB: Waiting for the background threads to start 161010 10:58:40 InnoDB: 1.1.8 started; log sequence number 5809271388 161010 11:42:54 [Note] Event Scheduler: Loaded 0 events 161010 11:42:54 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections. Version: '5.5.15' socket: '' port: 3306 MySQL Community Server (GPL) What is causing the delay between starting InnoDB and finishing this startup? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
ANN: Database Workbench 5.2 now includes PostgreSQL support
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.2 " This release includes support for PostgreSQL and adds several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! "Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions. "It added code editor features, has diagramming improvements, multiple editions, is fully HiDPI aware and offers tunnelling for MySQL and MariaDB connections. The most recent version adds support for PostgreSQL, as requested by many of our customers." For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
ANN: Upscene releases Database Workbench 5.1.12
Upscene releases Database Workbench 5.1.12 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.12 “ This release adds a few small features and useful enhancements. The full version 5.1.x change log is available here: http://www.upscene.com/go/?go=tracker=5.1.x=12 Version 5 added numerous new features and improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Version 5.1 includes SQL Azure and Firebird 3 support, additional data export functionality, improved Oracle XML and Object-type support, Diagramming enhancements and new printing features as well as improvements in other areas. http://www.upscene.com/news/item/20160322 Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Azure, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Upscene releases Database Workbench 5.1.10
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5.1.10 This release adds a few small features and includes Windows Terminal Server support. The full version 5.1.x change log is available here: http://www.upscene.com/go/?go=tracker=5.1.x=12 Version 5 added numerous new features and improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Version 5.1 includes SQL Azure and Firebird 3 support, additional data export functionality, improved Oracle XML and Object-type support, Diagramming enhancements and new printing features as well as improvements in other areas. http://www.upscene.com/news/item/20151215 Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Azure, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
ANN: 20% discount on Database Workbench Basic or Pro!
Dear reader, We're offering a 20% Mid Autumn Discount on our database design and development product "Database Workbench", available in Basic and Pro edition. Use coupon code MAD15 while ordering, valid until November the 9th. You can find more information about Database Workbench here: http://www.upscene.com/database_workbench/ Thank you. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!
ANN: 20% discount on Database Workbench Basic or Pro!
Dear reader, We're offering a 20% Mid Autumn Discount on our database design and development product "Database Workbench", available in Basic and Pro edition. Use coupon code MAD15 while ordering. You can find more information about Database Workbench here: http://www.upscene.com/database_workbench/ Thank you. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!
Upscene releases Database Workbench 5.1.6
Upscene releases Database Workbench 5.1.6 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.6 " This version is the next big release after version 5 and includes new features, enhancements and fixes. The full version 5.1.x change log is available here: http://www.upscene.com/go/?go=tracker=5.1.x=12 Version 5 added numerous new features and improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Version 5.1 includes SQL Azure and Firebird 3 support, additional data export functionality, improved Oracle XML and Object-type support, Diagramming enhancements and new printing features as well as improvements in other areas. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Azure, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Upscene releases Database Workbench 5.1.2
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.2 This version is the next big release after version 5 and includes new features, enhancements and fixes. The change log is available here: http://www.upscene.com/go/?go=trackerv=5.1.2id=12 http://www.upscene.com/go/?go=trackerv=5.1.0id=12 Version 5 added numerous new features and improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Version 5.1 includes SQL Azure and Firebird 3 support, additional data export functionality, improved Oracle XML and Object-type support, Diagramming enhancements and new printing features as well as improvements in other areas. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Azure, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Upscene releases Database Workbench 5.1.0
For immediate release: http://www.upscene.com/news/item/20150624 Upscene releases Database Workbench 5.1.0 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1 This version is the next big release after version 5 and includes new features, enhancements and fixes. The change log is available here: http://www.upscene.com/go/?go=trackerv=5.1.0id=12 Version 5 added numerous new features and improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Version 5.1 includes additional data export functionality, Firebird 3 support, improved Oracle XML and Object-type support, Diagramming enhancements and new printing features as well as improvements in other areas. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Upscene releases Database Workbench 5.0.10
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5 This release fixes several issues as reported by our customers. The change log is available here: http://www.upscene.com/go/?go=trackerv=5.0.10id=12 Version 5 added numerous improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
ANN: Upscene releases Database Workbench 5.0.8
Upscene releases Database Workbench 5.0.8 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5 This release fixes several issues as reported by our customers. The change log is available here: http://www.upscene.com/go/?go=trackerv=5.0.8id=12 Version 5 added numerous improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
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
ANN: Database Workbench 5.0.6 released
ANN: Upscene releases Database Workbench 5.0.6 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5 Version 5.0.6 fixes an issue with the MySQL module and includes some changes for Firebird 3. The change log is available here: http://www.upscene.com/go/?go=trackerv=5.0.6id=12 Version 5 added numerous improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server. With regards, Martijn Tonies
Re: alter table for foreign key
Hi, This is an example: ALTER TABLE cart ADD CONSTRAINT fk_cart_customers FOREIGN KEY (custid) REFERENCES customers (custid) ON DELETE CASCADE ON UPDATE NO ACTION; (take from the GUI tool Database Workbench, avoids having to know the syntax ;) ) With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -Original Message- From: thufir Sent: Monday, November 17, 2014 10:42 AM To: mysql@lists.mysql.com Subject: alter table for foreign key Looking at the docs: http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html how do I alter the child table, links, so that it has a foreign key with the parent table, feeds? The feed_id field in links should, in fact, be constrained by the foreign key of feeds with a RESTRICT reference option. mysql mysql show tables; +---+ | Tables_in_rome_aggregator | +---+ | feeds | | links | | pages | +---+ 3 rows in set (0.00 sec) mysql mysql describe feeds; +--+--+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-++ | id | int(11) | NO | PRI | NULL| auto_increment | | created | datetime | NO | | NULL|| | accessed | varchar(45) | NO | | NULL|| | url | varchar(767) | NO | UNI | NULL|| | status | int(11) | NO | | 0 || +--+--+--+-+-++ 5 rows in set (0.05 sec) mysql mysql describe links; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(11) | NO | PRI | NULL| auto_increment | | created | datetime | NO | | NULL|| | feed_id | int(11) | NO | | 0 || | link| varchar(767) | NO | UNI | NULL|| | status | int(11) | NO | | 0 || +-+--+--+-+-++ 5 rows in set (0.00 sec) mysql While I know that I should alter the table, I don't know the syntax to establish the foreign key constraint. thanks, Thufir -- 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: alter table for foreign key
On 14-11-17 01:42 AM, thufir wrote: Looking at the docs: http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html how do I alter the child table, links, so that it has a foreign key with the parent table, feeds? The workbench GUI came up with: ALTER TABLE `rome_aggregator`.`links` ADD INDEX `fk_links_1_idx` (`feed_id` ASC); In general, an index is used for performance, while a constraint is used for logical concepts, like uniqueness. Most often, the DBMS uses an index to implement these logical concepts, but it's better to understand the difference. A foreign key needs a unique constraint (either a primary of a secondary unique constraint) to point to: when there's no uniqueness in the parent table, it cannot point to a record in that table. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Upscene releases Database Workbench 5.0.4
Upscene releases Database Workbench 5.0.4 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5 Version 5.0.4 introduces some small new features and a list of fixes base on user feedback. The change log is available here: http://www.upscene.com/go/?go=trackerv=5.0.4id=12 Version 5 added numerous improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
ANN: Upscene releases Database Workbench 5.0.2
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5 Version 5.0.2 fixed some issues that came to light after the initial major version 5 release. http://www.upscene.com/news/item/20140918 Version 5 added numerous improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! A few bugs popped up after the initial version 5 release, all minor issues but also a lack of documentation showing in the trial version. I'm proud of the team that thoroughly tested the version 5 release, says Martijn Tonies, founder of Upscene Productions. The major version 5 release adds adds code editor features, has diagramming improvements, comes in multiple editions, is fully HiDPI aware and offers tunnelling for MySQL and MariaDB connections. It all was a lot of work, but it was worth it! We worked closely with out customer and implemented many of their requests and for new users, we offer multiple editions to suit their development needs. From design to productivity, there's new features and improvements in almost everything! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Re: database developer tool Database Workbench 5 now available
Hello Jan, list, From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! Unless you don't do Winblows. Please put Windows dependency clearly in your announcements and on your website. I couldn't find it anywhere, until I attempted a download, and got a useless .EXE file. The announcement said: ... and works fine under Wine on Linux. Several of our customers are long-time Linux users and are very happy with Database Workbench. See also: http://www.upscene.com/company/support/database_workbench_5_on_wine_ubuntu14 Hope this helps. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: database developer tool Database Workbench 5 now available
MGMy development is identical ..Development on Windows..Production on Linux MGWhen google routes me to Vladimir Putins site for Official Windows Mysql Stack you download god knows what MGsolution is to give the customer an in-between solution such as mysqld, mysqladmin and mysql shell scripts that will work under Windows cygwin MGThe Database Workbench version5 MySQL plugin README should detail *a seamless installation* for Windows cygwin MGif I have to make changes to my.ini or etc/init.d the readme should be specific on what those changes should be MGReadme should also be specific on how to successfully test mysql ports (presumably 3306)..i assume netstat -a | grep 3306? MGThanks Martin, I have no idea what the above means -- Database Workbench is a client side Windows based database design and development tool, no need to Cygwin or modify my.ini With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: database developer tool Database Workbench 5 now available
Upscene releases Database Workbench 5 Upscene Productions is proud to announce the availability of the next major version of the popular multi-DBMS development tool: Database Workbench 5 There have been numerous improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux. Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! There is so much new in Database Workbench 5, I don't know where to start, says Martijn Tonies, founder of Upscene Productions. This release adds code editor features, has diagramming improvements, comes in multiple editions, is fully HiDPI aware and offers tunneling for MySQL and MariaDB connections. It all was a lot of work, but it was worth it! We worked closely with out customer and implemented many of their requests and for new users, we offer multiple editions to suit their development needs. From design to productivity, there's new features and improvements in almost everything! For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 10 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 12 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Re: Stored procedure debuggers
Hello Larry, Subject: Stored procedure debuggers Does anyone know of any debuggers for stored procs that run on Mac and/or Linux? Although all our tools are Windows tool, we have customers running Database Workbench under Wine without major problems. We have a standalone debugger tool called Hopper, I haven tried it under Wine yet, but there's a good chance it runs fine. Here's my latest (successful) attempt running Database Workbench under Wine, as a complete Linux novice. ;) http://www.upscene.com/support.php?page=dbw_ubuntu_wine With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Cannot Update, at least not how I'm telling it to!
The AND in your UPDATE clause makes this a logical operator instead of being a SQL keyword. Your syntax is wrong: UPDATE ... SET mycol = value, mycol2 = value [WHERE ... ] With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -Original Message- From: Surya Savarika Sent: Wednesday, July 09, 2014 3:56 PM To: mysql@lists.mysql.com Subject: Cannot Update, at least not how I'm telling it to! Hi. mysql describe unions_data; +-+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-++ | ID | int(11) | NO | PRI | NULL| auto_increment | | Title | varchar(70) | NO | | NULL|| | Description | text| YES | | NULL|| | UsersID | int(11) | NO | MUL | NULL|| +-+-+--+-+-++ 4 rows in set (0.02 sec) mysql select * from unions_data; ++---+-+-+ | ID | Title | Description | UsersID | ++---+-+-+ | 4 | Union One | descr one | 2 | | 5 | Union Two | descr two | 2 | ++---+-+-+ 2 rows in set (0.00 sec) mysql update unions_data set Title='Dos' and Description='dos' where ID=5; ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'Dos' mysql update unions_data set Title=2.2 and Description='dos' where ID=5; Query OK, 1 row affected (0.33 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from unions_data; ++---+-+-+ | ID | Title | Description | UsersID | ++---+-+-+ | 4 | Union One | descr one | 2 | | 5 | 0 | descr two | 2 | ++---+-+-+ 2 rows in set (0.00 sec) Notice that it threw an error about an incorrect DOUBLE value for a field that is a varchar. Notice that when it did decide to update, it updated incorrectly and it updated Title but _not_ Description, yet issued no Warnings. Am I missing something?? TIA, Savi -- 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
ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available!
ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.7 Pro For more information, see http://www.upscene.com/go/?go=newsid=20140617 Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com
ANN: Hopper - Stored Routine debugger - v1.5.1 released
ANN: Hopper - Stored Routine debugger - v1.5.1 released Dear ladies and gentlemen, Upscene Productions is proud to announce version 1.5.1 of our product called Hopper. Hopper is a Windows-based Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=hopper This release contains new features and bugfixes, see http://www.upscene.com/go/?go=newsid=20140616 for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com
Three days left on the 75% FIFA World Cup Discount!
Dear reader, There’s 3 days left on our FIFA World Cup special: 75% discount on all our database development products! http://www.upscene.com/ With regards, Martijn Tonies Upscene Productions http://www.upscene.com
ANN: 75% special FIFA World Cup 2014 discount on all our products
Hello everyone, We’re currently offering a 75% discount on all our (Windows based) products! This includes test data generator, development and debugging tools, feel free to take a look at http://www.upscene.com Thank you for your attention. With regards, Martijn Tonies Upscene Productions http://www.upscene.com
ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available!
ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.6 Pro For more information, see http://www.upscene.com/go/?go=newsid=20140429 The FREE Lite Editions will be released at a later stage. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com
ANN: Hopper - Stored Routine debugger - v1.5.0 released
ANN: Hopper - Stored Routine debugger - v1.5.0 released Dear ladies and gentlemen, Upscene Productions is proud to announce version 1.5.0 of our product called Hopper. Hopper is a Windows-based Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=hopper This release contains new features and bugfixes, see http://www.upscene.com/go/?go=newsid=20140401 for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com
ANN: Database Workbench 4.4.5, special MySQL discount!
ANN: Database Workbench 4.4.5, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.5 Pro March only: 25% discount on Database Workbench Pro for MySQL using discount coupon MYSQLSPECIAL - additional modules can be purchased at a later stage. For more information, see http://www.upscene.com/go/?go=newsid=20140319 The FREE Lite Editions will be released at a later stage. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com
ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available!
ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.4 Pro For more information, see http://www.upscene.com/go/?go=newsid=20140127 The FREE Lite Editions will be released at a later stage. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com
ANN: Advanced Data Generator 3.2.0 released
ANN: Advanced Data Generator 3.2.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.2.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, presets 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=20140107 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com
ANN: Advanced Data Generator 3.1.2 released
ANN: Advanced Data Generator 3.1.2 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.1.2 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, presets 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=20131202 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com
ANN: Hopper - Stored Routine debugger - v1.4.1 released
ANN: Hopper - Stored Routine debugger - v1.4.1 released Dear ladies and gentlemen, Upscene Productions is proud to announce version 1.4.1 of our product called Hopper. Hopper is a Windows-based Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=hopper This release contains bugfixes, see http://www.upscene.com/go/?go=newsid=20131202b for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com
ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available!
ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.3 Pro This release fixes a blocking problem after a recent Windows XP security update. There's a 15% autumn discount until the end of November! For more information, see http://www.upscene.com/go/?go=newsid=20131127 The FREE Lite Editions are also updated, this includes several enhancements compared to the previous available Lite Editions. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com
ANN: Database Workbench 4.4.2, the multi-DBMS IDE now available!
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.2 Pro There's a 15% autumn discount until the end of November! This release includes enhancements and fixes several bugs as reported by our users. For more information, see http://www.upscene.com/go/?go=newsid=20131024 The FREE Lite Editions will follow later. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com
ANN: Advanced Data Generator 3.1.1 released
ANN: Advanced Data Generator 3.1.1 released Dear ladies and gentlemen, Upscene Productions is happy to announce the next release of their flexible and easy to use test data generator tool: Advanced Data Generator 3.1.1 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, presets 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=20131014 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com
ANN: Hopper - Stored Routine debugger - v1.4.0 released
ANN: Hopper - Stored Routine debugger - v1.4.0 released Dear ladies and gentlemen, Upscene Productions is proud to announce version 1.4.0 of our product called Hopper. Hopper is a Windows-based Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=hopper This release contains bugfixes and improvements, see http://www.upscene.com/go/?go=newsid=20131009 for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com
ANN: Database Workbench 4.4.1, the multi-DBMS IDE now available!
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.1 Pro This release includes new features and fixes several bugs as reported by the users. For more information, see http://www.upscene.com/go/?go=newsid=20130819 The FREE Lite Editions will follow later. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Advanced Data Generator 3.1 released
ANN: Advanced Data Generator 3.1 released Dear ladies and gentlemen, Upscene Productions is happy to announce the next release of their flexible and easy to use test data generator tool: Advanced Data Generator 3.1 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, presets 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=20130805 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.4.0, free Lite Editions now available!
ANN: Database Workbench 4.4.0, free Lite Editions now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.0 Lite Today we are making the free Lite Editions available for version 4.4.0 For more information, see http://www.upscene.com/go/?go=newsid=20130717 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) The Lite Editions are available for: - InterBase - Firebird - MySQL Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Hopper - Stored Routine debugger - v1.3.0 released
ANN: Hopper - Stored Routine debugger - v1.3.0 released Dear ladies and gentlemen, Upscene Productions is proud to announce version 1.3.0 of our product called Hopper. Hopper is a Windows-based Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=hopper This release contains bugfixes and improvements, see http://www.upscene.com/go/?go=newsid=20130603 Bugfixes include, but not limited to: - possible data type not supported on specific (param) IS NULL constructor in Firebird or InterBase - (INSERT INTO ...) RETURNING-clause not working in Firebird version - assigning values to output parameters fails using Trace Into in MySQL - possible errors on using built in function in SQL queries in MySQL With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.4.0, the multi-DBMS IDE now available!
ANN: Database Workbench 4.4.0, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.0 Pro This release includes new features and fixes several bugs as reported by the users. For more information, see http://www.upscene.com/go/?go=newsid=20130423 The FREE Lite Editions will follow later. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: beta 2 of Advanced Data Generator 3 released
ANN: beta 2 of Advanced Data Generator 3 released Dear ladies and gentlemen, Upscene Productions is happy to announce the second public beta of the next major version of their Windows based test data generator tool: Advanced Data Generator 3 A fast test-data generator tool that comes with a library of real-life data, can generate data into your database, XML Data Files, SQL script, CSV files, has many filling options, templates and much more. Fixed in beta 2: * Trial version asking for registration key * clearing a numerical edit box results in minus max integer value * some captions modified New feature highlights: * Unicode support * renewed user interface * ability to use external data sources as lookup data * new data generator options * new and improved data libraries * sample project, sample templates * renewed documentation including comprehensive how to section * improved error reporting (beta currently only available for the Pro edition) More info and a 30-day trial version on www.upscene.com Pricing information available on: http://www.upscene.com/purchase.php#adg More information available here: http://www.upscene.com/go/?go=newsid=20130319 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Hopper - Stored Routine debugger - v1.2.0 released
Dear ladies and gentlemen, Upscene Productions is proud to announce version 1.2.0 of our product called Hopper. Hopper is a Windows-based Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=hopper This release contains bugfixes and improvements, see http://www.upscene.com/displaynews.php?item=20130315 Bugfixes include, but not limited to: - SQL errors with certain regional settings - some Unicode data not properly displayed - InterBase EXECUTE PROCEDURE always returns NULL With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.3.2, free Lite Editions now available!
ANN: Database Workbench 4.3.2, free Lite Editions now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.2 Lite Today we are making the free Lite Editions available for version 4.3.2 For more information, see http://www.upscene.com/go/?go=newsid=20130204 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) The Lite Editions are available for: - InterBase - Firebird - MySQL Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Hopper, version 1.1.0 released
ANN: Hopper, version 1.1.0 released Dear ladies and gentlemen, Upscene Productions is proud to announce version 1.1.0 of our product called Hopper. Hopper is a Windows-based Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=hopper This release contains bugfixes and some small new features, see http://www.upscene.com/displaynews.php?item=20130129 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.3.2, the multi-DBMS IDE now available!
ANN: Database Workbench 4.3.2, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.2 Pro This release fixes several bugs as reported by the users. For more information, see http://www.upscene.com/go/?go=newsid=20121112 The FREE Lite Editions will follow later. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.3.1, free Lite Editions now available!
ANN: Database Workbench 4.3.1, free Lite Editions now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.1 Lite Today we are making the free Lite Editions available for version 4.3.1 For more information, see http://www.upscene.com/go/?go=newsid=20120925 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) The Lite Editions are available for: - InterBase - Firebird - MySQL Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.3.1, the multi-DBMS IDE now available!
ANN: Database Workbench 4.3.1, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.1 Pro This release fixes a few issues with MySQL support. For more information, see http://www.upscene.com/go/?go=newsid=20120820 The FREE Lite Editions will follow later. Changes include: - NEW: Stored Procedure Trigger debugger for MySQL - NEW: incremental data search in SQL, Table View Editor - FIXED: Oracle Debugger fixes - FIXED: NexusDB error when testing Stored Functions - FIXED: MySQL module not properly displaying stored procedures/functions without mysql.procs access and much more... Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.3.0, the multi-DBMS IDE now available!
ANN: Database Workbench 4.3.0, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.0 Pro For more information, see http://www.upscene.com/go/?go=newsid=20120813 The FREE Lite Editions will follow later. Changes include: - NEW: Stored Procedure Trigger debugger for MySQL - NEW: incremental data search in SQL, Table View Editor - FIXED: Oracle Debugger fixes - FIXED: NexusDB error when testing Stored Functions - FIXED: MySQL module not properly displaying stored procedures/functions without mysql.procs access and much more... For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.3.0id=3 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: create roles/groups in MYSQL
There's nothing built in but if you want explore this it is an extension http://www.securich.com/ That seems like a nice extension. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! On 1 Aug 2012 21:56, Aastha aast...@gmail.com wrote: Hello, I have 10 different users and i have to give different accesses to different tables. Is it possible to create a groups with different set of access rights on different tables. I know there are ROLES and PROFILES in Oracle. Is there something similar in MySQL. Thanks, Aastha Gupta -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Hopper (stored procedure debugger), version 1.0.3 released
ANN: Hopper, version 1.0.3 released Dear ladies and gentlemen, Upscene Productions is proud to announce version 1.0.3 of our product called Hopper. Hopper is a Windows-based Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL. This version fixes an imporant error with the MySQL version, amongst other small issues. For more information, see http://www.upscene.com/displaynews.php?item=20120801 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Hopper, version 1.0.2 released
ANN: Hopper, version 1.0.2 released Dear ladies and gentlemen, Upscene Productions is proud to announce version 1.0.2 of our product called Hopper. Hopper is a Windows-based Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/displaynews.php?item=20120713 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: ANN: Hopper (stored procedure debugger), version 1.0.1 released
Hello Jan, others, I do find your juvenile comments about worshipping, changing product names etc just that. Ah, you must be from the marketing department -- always willing to make friends and influence people. Please, Jan, I'm obviously not, I'm but a simple programmer. And given the fact that you started out by implying I worshipped Bill Gates, I'll take it you aren't willing to make new friends either. Website has been modified, product announcement as well. Can we close the book on this now? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: ANN: Hopper (stored procedure debugger), version 1.0.1 released
Hello Jan, Can you PLEASE note in your listing when a product is Microsloth-only? While you're at it, can you PLEASE note it prominently on your website? I looked through your product description and saw no specific requirements beyond what databases were supported. It wasn't until I tried to download it that I noticed the warning sign. (.EXE in the file name) Hard as it is to believe, the entire world does not worship at the alter of Bill Gates. We don't allow any Microsloth products on our site. Although you have a point about the product announcement and lack of mentioning the required OS on our website, I do find your juvenile comments about worshipping, changing product names etc just that. I'll adjust the website and announcements. :) Have a nice weekend. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Hopper (stored procedure debugger), version 1.0.1 released
ANN: Hopper, version 1.0.1 released Dear ladies and gentlemen, Upscene Productions is proud to announce version 1 of a new product called Hopper. Hopper is a Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/displaynews.php?item=20120620 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.2.4, free Lite Editions now available!
ANN: Database Workbench 4.2.4, free Lite Editions now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.2.4 Pro Today we are making the free Lite Editions available for version 4.2.4 For more information, see http://www.upscene.com/go/?go=newsid=20120601 For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.2.4id=3 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) The Lite Editions are available for: - InterBase - Firebird - MySQL Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Only 2 days left, 70% discount on all products!
Hello everyone, There's only a few days left to get a massive discount of 70% on all database development products at Upscene Productions. www.upscene.com Database tools for: - Firebird - MySQL - Microsoft SQL Server - Oracle - InterBase - NexusDB - Advantage Database - ADO ODBC -- With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: ANN: Hopper for MySQL, first public beta available!
Welcome to Hopper! Claudio Thank you Claudio, we hope it will serve it's purpose and we get lots of feedback on it. 2012/5/25 Martijn Tonies m.ton...@upscene.com Dear ladies and gentlemen, Upscene Productions is happy to announce the launch of a new database-developer tool: Hopper (public beta 1) Hopper is a Stored Routine Debugger, the first beta for MySQL is now available. For more information, see http://www.upscene.com/** displaynews.php?item=20120525http://www.upscene.com/displaynews.php?item=20120525 With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Hopper for MySQL, first public beta available!
Dear ladies and gentlemen, Upscene Productions is happy to announce the launch of a new database-developer tool: Hopper (public beta 1) Hopper is a Stored Routine Debugger, the first beta for MySQL is now available. For more information, see http://www.upscene.com/displaynews.php?item=20120525 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: 70% Ten Year Anniversary discount on all our products!
Upscene Productions is celebrating it's 10 year anniversary with a massive discount on all our products: 70% discount until the end of May. Don't forgot to blog and twitter about this! We produce database development, management and testing tools for: * Oracle * Microsoft SQL Server * MySQL * InterBase * Firebird * SQL Anywhere * NexusDB * Advantage Database * Generic connectivity tools for ADO and ODBC These include test data generator tools, database design and development tools, auditing tools, a dbExpress driver for Firebird, debugging tools, performance analysis tools. Coupon code TENYEARS will get you this discount, check http://www.upscene.com for more information. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.2.4 released, 70% discount!
ANN: Database Workbench 4.2.4, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.2.4 Pro For more information, see http://www.upscene.com/go/?go=newsid=20120510 The FREE Lite Editions will follow later. For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.2.4id=3 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
List of global/session variables (@myvar)
Hi, Is there a way to get the currently available global variables that are defined by, for example, a Stored Procedure that returns stuff as set @myvar = 'result'; when outside the stored procedure? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Very early preview movie of Hopper, Stored Routine Debugger
Hello everyone, Given the feedback I got about starting a Stored Routine Debugger for MySQL like we did for Firebird and InterBase, work has started... This debugger will be part of Database Workbench Pro http://www.upscene.com/go/?go=dbw but also as a standalone product, Hopper for MySQL (see Firebird version) http://www.upscene.com/go/?go=hopper Here's a small demo movie so you get an idea of how it works: http://www.upscene.com/products/hopper/demos/hopper_mysql_alpha1.htm Thanks for watching! With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Database Workbench 4.2.3, the multi-DBMS IDE now available!
Hello Daevid, Any plans to add sqlite to your list of supported DBs there? I develop Android and use LAMP as the server backend. Currently I use SQLYog as I have for like 10 years. But I would really like one GUI to work on both the android sqlite and the mysql backend since they usually tie together. Full native SQLite is not planned. You probably can access it as a read only datasource, run queries etc, via ODBC, I haven't tested that. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available!
ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.2.3 Pro For more information, see http://www.upscene.com/go/?go=newsid=20120323 Today's release includes the FREE Lite Editions. For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.2.3id=3 http://www.upscene.com/go/?go=trackerv=4.2.2id=3 http://www.upscene.com/go/?go=trackerv=4.2.1id=3 http://www.upscene.com/go/?go=trackerv=4.2.0id=3 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.2.1, the multi-DBMS IDE now available!
ANN: Database Workbench 4.2.1, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.2.1 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=newsid=20120209 For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.2.1id=3 http://www.upscene.com/go/?go=trackerv=4.2.0id=3 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Stored Procedure Debugging?
Hi all, As you probably now, we created Database Workbench, a developer tool for MySQL and other DBMSses. This tool includes a Stored Routine Debugger for several DBMSses, including Firebird and InterBase, but not MySQL. Both Firebird and InterBase do not provide a debugging API, so our tool emulates stored code behaviour at the client side. As far as I know, MySQL doesn't have a debugging interface either. I'm wondering if there would be a market to add such emulation to Database Workbench. For info and screenshots, see: http://upscene.com/documentation/dbw4/tools_debugger_basics.htm Would you like to be able to debug stored routines like this? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Database Workbench 4.2.0, the multi-DBMS IDE now available!
ANN: Database Workbench 4.2.0, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS Windows-based development tool: Database Workbench 4.2.0 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. There's a 40% discount available until the 1st of January 2012! For more information, see http://www.upscene.com/go/?go=newsid=20111212 For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.2.0id=3 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!
Hi all, No SQLite support? http://www.sqlite.org/ Seems curious you wouldn't have this yet, especially given its popularity on both embedded systems and Android to say the least. Indeed, no native SQLite support. Lots of other systems are popular and not supported. The reason for this is that the tool is not generic and tries to get the most of all. Apparently Winblows-only. It sure would be nice if people would note platform requirements in their announcement, rather than forcing people to dig through their websites for such info. I guess I should know better; if it doesn't list platform requirements, the developer hasn't thought beyond the dominant paradigm. You sure have a point, I'll list it in the future. However, I should note that Database Workbench users have succesfully used it under Wine. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!
ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.3 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=newsid=20110816 For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.1.3id=3 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Advanced Data Generator 2.5.2 released
ANN: Advanced Data Generator 2.5.2 released Dear ladies and gentlemen, Upscene Productions is happy to announce the next version of their test data generator tool: Advanced Data Generator 2 (v2.5.2) 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, presets and much more. Feature highlights: * Ability to generate flexible and real-life master/detail data * Ability to use (legacy) data from CSV files * Ability to generate proper multi-column referential links * New ways of generating data for BLOBs, CLOBs and more * Automatic detection of table order by using Foreign Key Constraints * Support for custom SQL statements after data generation * Generate data to your database, SQL scripts or CSV files 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/purchase.php#adg With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Any table visualization tools with wires connecting the actual columns?
Hi, Also take a look at Database Workbench - www.upscene.com The free Lite Edition doesn't do diagramming, but the Pro does. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Does anyone have any suggestions on this? I've written to SQL Maestro twice and they've not replied either. From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Friday, April 01, 2011 4:27 PM To: mysql@lists.mysql.com Subject: Any table visualization tools with wires connecting the actual columns? I am evaluating various tools for diagram generating of existing databases on some smaller databases (9 tables or so) first. The two I've tried so far are these: http://dev.mysql.com/downloads/workbench/ http://www.sqlmaestro.com/download/#mysql Both _seem_ robust and cosmetically polished, but feel to me lacking the most obvious and key component of the whole purpose to make an EER diagram. I don't understand in workbench, why it creates new keys for me on existing tables. Maestro doesn't do this nonsense. It isn't the tools business where I have keys, it only needs to be concerned with what links to what -- that I tell it to. It's further exacerbated by the fact that the documentation indicates these aren't even REAL keys, they are cosmetic only! WTF? Why add confusion guys? 1. Neither one seem to be smart enough to automatically know that columns of the same name should be linked, and furthermore they should be linked from all tables to the one where that column name is the PK. my tables don't have true InnoDB FKs setup. And some tables are MYISAM (as they're significantly faster). But I do use keys and I do have sane naming conventions, so I don't understand why they can't use the names, and if there are multiple tables (for some unlikely reason) then just prompt me which table to use. Which leads me to the second and third problems... So I manually have started to draw the connections, but: 2. How can I make the wires stick to a column on the left or right edge, so that I can have a direct visual link between the columns. Right now, it seems they float around the edge of the table box. That's sort of useless isn't it? it's like saying, well, something in this table points to something in that table.?! I would think that two programs with such high version numbers would have this feature. Maybe I'm missing a configuration or some way I'm supposed to do it? 3. Some of my databases point to tables in other databases on the same server. It would be useful if I could make a wire that indicates this. Are there other (better) options out there for this? I really don't want to do this in Visio or make a printout of the table boxes and tape string to my walls to visualize all the databases, tables and columns. -Daevid. _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3544 - Release Date: 04/01/11 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dae...@daevid.com _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3544 - Release Date: 04/01/11 _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3557 - Release Date: 04/07/11 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.1.2, the multi-DBMS IDE now available!
ANN: Database Workbench 4.1.2, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.2 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=newsid=20110330 For a full list of fixes in 4.1 releases, see: http://www.upscene.com/go/?go=trackerv=4.1.2id=1 http://www.upscene.com/go/?go=trackerv=4.1.1id=1 http://www.upscene.com/go/?go=trackerv=4.1.0id=1 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.1.1, the multi-DBMS IDE now available!
ANN: Database Workbench 4.1.1, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.1 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. This release fixes a possible crash and some other issues. For more information, see http://www.upscene.com/go/?go=newsid=20110216 For a full list of fixes in version 4.1.1 and 4.1.0, see: http://www.upscene.com/go/?go=trackerv=4.1.1id=1 http://www.upscene.com/go/?go=trackerv=4.1.0id=1 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Which row in which table has been accessed at which time?
Hi, I could envision a way of doing this when accessing your tables only via Stored Procedures instead of using them directly. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Hi listers I have a mysql web application. in this application it would be fine to be able to track the database entries i have visited, because often later on i grat my head: which entry did i see this already in? So i would need a way to find out which entries in which table i have visited lately. i first created a last_access table column and updated it before selecting the table entry, but alas, this way i also updated the last_update entry of the table which has on update current_timestamp. it can't be done this way. i also looked for an on select event in mysql, but i was not sucessful. also, the show status command was not helpful. the complicated way would be to create a special table and make entries into it whenever i access entries in different tables. when googling around i found, it is even not easy to find out, which tables have been accessed in general. if, now, i want to know even which row in a particular table has been accessed at which time, the problem gets even more difficult. does anybody have a solution to this, which is easier than the complicated way mentionned earlier? thanks for any hints. suomi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=m.ton...@upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: New Year's Sale at Upscene Productions, 25% discount!
New Year's Sale at Upscene Productions, 25% discount! Dear reader, We wish you the best for 2011. We would like to point you to our New Year's Sale! Go to http://www.upscene.com and use coupon code NY2011 when ordering. With regards, Martijn Tonies Upscene Productions www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.1.0, the multi-DBMS IDE now available!
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.0 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. Version 4 introduced full Unicode support, 4.1.0 adds new features, latest DBMS support and improved functionality. For more information, see http://www.upscene.com/go/?go=newsid=20101224 For a full list of fixes in version 4.1.0 and previous versions, see: http://www.upscene.com/go/?go=trackerv=4.1.0id=1 http://www.upscene.com/go/?go=trackerv=4.0.3id=1 http://www.upscene.com/go/?go=trackerv=4.0.2id=1 http://www.upscene.com/go/?go=trackerv=4.0.1id=1 http://www.upscene.com/go/?go=trackerv=4.0id=1 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Which tool to use for developing Pl/Sql on MySQL?
I use Database Workbench, but might be biased ;-) www.upscene.com - there's a free Lite edition available. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com Hi, beginning to work with MySQL I've found there exist two similar tools for browsing the db and developing in Pl/Sql and they are SQL-Front and MySQL Query Browser. Fot not wasting time in learning both can anyone tell me which of these is generally used wordwide? So I make practice with the most used one. Thanks in advance! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=m.ton...@upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Triggers and FOR EACH ROW
Manao ahoana, Hello, Bonjour, I just read several documentation on MySQL triggers. The way to create triggers is: CREATE TRIGGER t21_au BEFORE UPDATE ON t22 FOR EACH ROW BEGIN // ... END; The trigger I want is only on UPDATE. Is FOR EACH ROW referring to each existing row in the table, or to each UPDATEd row? Each updated row, as per documentation: It can be BEFORE or AFTER to indicate that the trigger activates before or after each row to be modified. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.0.3, the multi-DBMS IDE now available!
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.0.3 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. Version 4 introduced full Unicode support, 4.0.3 fixes some issues found in that initial release and subsequent releases, including the Query was empty-error in some parts of the MySQL module. There have been numerous improvements to existing tools and the user interface making it even better than before. For more information, see http://www.upscene.com/ For a full list of fixes in version 4.0.3 and previous versions, see: http://www.upscene.com/go/?go=trackerv=4.0.3id=1 http://www.upscene.com/go/?go=trackerv=4.0.2id=1 http://www.upscene.com/go/?go=trackerv=4.0.1id=1 http://www.upscene.com/go/?go=trackerv=4.0id=1 Database Workbench supports: - Borland InterBase ( 4.x - 9.x ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10 and 11 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.0.2 released - including Free Lite Editions
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.0.2 Pro Version 4 introduced full Unicode support, 4.0.2 fixes some issues found in that initial release, like ODBC connectivity issues, BLOBs taking too much memory, the ability to specify file encoding when saving SQL Scripts and several other errors. For a full list of fixes in version 4.0.2 and previous versions, see: http://www.upscene.com/go/?go=trackerv=4.0.2id=1 http://www.upscene.com/go/?go=trackerv=4.0.1id=1 http://www.upscene.com/go/?go=trackerv=4.0id=1 Database Workbench supports: - Borland InterBase ( 4.x - 9.x ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10 and 11 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql Schema design Rollback necessity Question
Hi, I am new to using mysql. I want to prepare an application for my employer. The application will be accessed by staff from as many as 10 different departments such as sales, marketing, admin, finance etc. The users will be using DML commands on the tables. My question has two parts: Part I: While designing the schema of the database, I have two choices: Scenarios: 1. Create multiple tables, one for each department. The relationship for most of the tables is one-to-one. 2. Create one master table so that each department updates its respective columns in the same table. Please advise which choice is better. I fail to see what kind of data a table (one for each department) would hold? How would a single table (one master table) hold the data for the processes of this application? What should the application do? Questions: 1. With single table will table locking become an issue if multiple users edit the table simultaneously or is it something that mysql can handle without problem? It depends on the storage engine. 2. What is the maximum recommended size of a table for mysql? How many columns should be master table should have ? Is it recommended to design a master table having more than 200 columns? Have you ever read a book on database design normalization? PART II: Secondly, I am using PHP, Mysql, ADODB, APACHE on windows 7 platform. This is my typical DML command: I am not using any rollback statement to rollback the db if the DML command is not completed successfully. Is it advisable to use rollback? If it is how should I modify the above statement to include it ? If the DML command failed and modifies a single row only, the rollback won't do anything, but if it updates multiple rows or trying to do a unit of work inside the same transaction, things become different. Have you ever read about atomicy on database transactions? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: test - please ignore
i said: ignore! But did it work? ;-) With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.0.1 Pro released
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.0.1 Pro Version 4 introduced full Unicode support, 4.0.1 fixes some issues found in that initial release, like MySQL Stored Procedures/Functions metadata not getting fetched properly and failed data export to Excel. There have been numerous improvements to existing tools and the user interface making it even better than before. For more information, see http://www.upscene.com/ For a full list of fixes in version 4.0.1, see: http://www.upscene.com/go/?go=trackerv=4.0.1id=1 Database Workbench supports: - Borland InterBase ( 4.x - 9.x ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10 and 11 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: order by numeric value
But I'd prefer not to see the extra sorting field.
You don't need to select a field in order to be able to order by it.
So
select chart_of_accounts.accountname as Account,
concat('$',format(coalesce(sum(sales_journal_entries.debit),0),2)) as
Debit,
concat('$',format(coalesce(sum(sales_journal_entries.credit),0),2)) as
Credit,
concat('$',format(coalesce(sum(sales_journal_entries.credit),0)-coalesce(sum(sales_journal_entries.debit),0),2))
as Balance
from sales_journal_entries
left join sales_journal
on sales_journal.journalID=sales_journal_entries.journalID
left join chart_of_accounts
on chart_of_accounts.accountID=sales_journal_entries.accountID
where sales_journal.date '2008-12-31'
and sales_journal.date '2010-01-01'
group by sales_journal_entries.accountID
order by
coalesce(sum(sales_journal_entries.credit),0)-coalesce(sum(sales_journal_entries.debit),0)
asc;
should do the trick.
Jesper
Perfectamundo! I thought there would have been a more elegant way but
this works just fine. Thanks.
There is a more elegant way: do not do your $ at the database, but rather
in the presentation layer.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How to select rows from only the first N rows in a table?
It seems that there is no direct support to limit 'select' to only the first N rows in a table. Could you let me know what the best way select rows from the first N rows in a table is? LIMIT usually works fine ;-) http://dev.mysql.com/doc/refman/5.0/en/select.html With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
