Bug #67447 Tools/Options needs Define Primary Key

• Submitted: 1 Nov 2012 12:33
• Reporter: Phil Olson
• Status: Open
• Category: MySQL Server: DDL
• Severity: S4 (Feature request)
• Version: 5.2
• OS: Any
• CPU Architecture: Any

[1 Nov 2012 12:33] Phil Olson

Description:
This is not a bug, But an idea for a useful needed feature.

I support several medical researchers who use Spreadsheet to capture their observations.  They constantly err by entering duplicate data into their spreadsheets.  

I then load (INSERT IGNORE) into MySQL and encounter "duplicate row error messages"

It would be wonderful if OpenOffice included a new feature in their spreadsheet

Tools/Options/Define Primary Key Columns

Then, when the researcher - in error - enters a new row which violates thevprimary key defintion an informative message would appear.

Somethings like
"Row nn has the same primary values as this row.

How to repeat:
Load a spreadsheet (with Sid, Date in columns A and B where A = Bill and B = 1999-12-31) Put that data into rows 1 and 2.

CREATE a TABLE where A and B are the primary key.

I recognize this is not a bug.  But, simply sending what I think is a great idea (and one that is not in EXCEL)

Suggested fix:
See above.