Jeff Lacki wrote:
Ok I appear to have narrowed down the issue.
it appears to be the last table I had listed
named 'user_account1':
mysql> describe user_account1;
+-----------------+--------------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+------------+-------+
| id | bigint(20) | | | 0 | |
| is_active | varchar(10) | | | | |
| last_login | date | | | 0000-00-00 | |
| reason | varchar(100) | YES | | NULL | |
| term_reason | varchar(100) | YES | | NULL | |
| last_login_time | time | | | 00:00:00 | |
+-----------------+--------------+------+-----+------------+-------+
6 rows in set (0.00 sec)
Is that user_account1.id field indexed?
show create table user_account1;
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]