--- Jeff Lacki <[EMAIL PROTECTED]> wrote:
>
+-+--+--+-++---+
> | Field | Type | Null | Key |
> Default| Extra |
>
+-+--+--+-++---+
> | id | bigint(20) |
lack of a primary key was the problem.
I am surprised the problem didnt show up in 3.23
but did in 4.12
Thanks for the suggestions!
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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| Ext
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 |
+--
Im running a 2.8Ghz celeron P4, 1Gbyte RAM on
a 160Gb HD (IDE).
mysql> show variables;
+-++
| Variable_name | Value
|
+--
Hello.
Maybe you had configuration file with different
settings. Nevertheless, send the information about
your RAM size, the output of SHOW VARIABLES,
configuration file, table definitions (use SHOW CREATE
TABLE), EXPLAIN output for your query, and list should
help you.
Jeff Lacki <[EM