OK well that table has no primary key established.
If I create a table with a PK:
create table test (id integer primary key);
you see PRIMARY KEY in the output:
mysql> show create table test;
+-------+----------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+-------+----------------------------------------------------------------------------------------------------------+
| test | CREATE TABLE `test` (
`id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+-------+----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
so in this case you'd need to specify PK cols in your Table or in your mapper
def.
On Mar 11, 2013, at 11:14 AM, Felix Schwarz <[email protected]>
wrote:
>
>> can you send the "SHOW CREATE TABLE", I'll copy it exactly
>
> CREATE TABLE `links` (
> `l_from` int(8) unsigned NOT NULL DEFAULT '0',
> `l_to` int(8) unsigned NOT NULL DEFAULT '0',
> UNIQUE KEY `l_from` (`l_from`,`l_to`),
> KEY `l_to` (`l_to`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1
>
>
> (sorry for breaking the threading, due to some misconfiguration I saw
> Michael's mail only in the web interface.)
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
