Forums » General Discussion

Thread: Tables without a Primary Key

This question is not answered. Helpful answers available: 2. Answered answers available: 1.

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List Point your RSS reader here for a feed of the latest messages in all forums

Permlink Replies: 0 - Pages: 1 Threads: [ Previous | Next ]
x21_921

Posts: 5
Registered: 6/1/10
Tables without a Primary Key
Posted: Nov 22, 2010 4:19 PM 		 
  Click to reply to this thread Reply

Previously toad allowed you to edit rows in a table that do not have a primary key for the table. Now however it does not and it throws an error that basically means you need a primary key for every table in your database.

Can't you just do the update statement based on the full contents of the row, since MYSQL doesn't support ROWID instead of throwing this error?

Thanks!


Pages: 1
Back to Thread List Back to Thread List
Threads: [ Previous | Next ]
Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums