Further information re Error 13 updating table structure

2002-07-31 Thread Jeff Dyer
ssions? OS - Windows XP Pro, MySQL ver 4.0.1-alpha-nt Thanks in advance Jeff Dyer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reques

Re: subquery syntax

2002-07-30 Thread Jeff Dyer
- Original Message - From: "Daniel Brockhaus" <[EMAIL PROTECTED]> To: "Jeff Dyer" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 4:43 PM Subject: Re: subquery syntax > Wouldn't > > SELECT Contac

Re: subquery syntax

2002-07-30 Thread Jeff Dyer
Forget it (at least for the forseeable future) This is the well known MySQL feature that means that MySQL is not even SQL compatible. Argg. Apparently you will have to wait for version 4.1. Subqueries are not supported Jeff - Original Message - From: <[EMAIL PROTECTED]> To: <[

Error updating table structure.

2002-07-27 Thread Jeff Dyer
I am running Windows XP Professional, MySQL 4.0.1-alpha-nt. Anyone know what's wrong? What do other people use to edit table structures (and don't say SQL queries because that's not a productive option when compared to MS Access linked to SQL Server. Regards Jeff Dyer Logic Softw