Re: strange difference in creating views (mysql 5.0.1)

2004-10-28 Thread SGreen
I suspect that you actually have two records in address_association that don't match up with a record in address. Yes, either a data mismatch or data duplication would be suspected in a case like this. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Elim Qiu" <[EMAIL PROTEC

strange difference in creating views (mysql 5.0.1)

2004-10-28 Thread Elim Qiu
I'm trying to create a view from two tables address and address_association. So I did the following and expect they are the same: CREATE VIEW associated_address AS select t0.association_id AS association_id, t0.property_dict AS property_dict, t0.type_id AS type_id, t0.owner_id AS owner_id, t0.own

MySQL 5.0.1 won't restart

2004-08-25 Thread Scott Hamm
I'm running Windows 2000 and MySQL 5.0.1. When I tried to restart the service, it won't start up again, error message saying to try again in 30 minutes. After waiting for 30 minutes, it still bring up same error message. What might be the cause? Scott -- MySQL General Mailing Lis

VIEWS and SHOW TABLE STATUS in MySQL 5.0.1

2004-08-03 Thread Martijn Tonies
Hi, Currently, a VIEW lists "NULL" as value for the "Engine" column in the SHOW TABLE STATUS resultset. Is this the right behaviour? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- M

Re: MySQL 5.0.1-alpha-snapshot has been released

2004-08-03 Thread Martijn Tonies
Hi, Absolutely great news! Thanks. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

MySQL 5.0.1-alpha-snapshot has been released

2004-08-03 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 5.0.1, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads

MySQL 5.0.1?

2004-06-23 Thread Martijn Tonies
Hi, Is there any idea of a release date for a MySQL 5.0.1 build that includes stored procedures on a per database basis? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- M