Re: Editing table data

[Michael G. Zinner]

Please make sure you _always_ have a primary key column in each table. When there is no primary key, it is impossible to say which row has been edited. And therefore Query Browser cannot write back the data you entered.

A good practice is, to _always_ have a primary key in each table. I usually make the first column in a table the primary key and I name it "id<tablename>".

And I always make it an INTEGER column. This gains me a lot more speed than to use a VARCHAR column or whatever when I join with other tables later on.

Mike

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification