Unique rows

[IWeb]

Hello,

How can I make sure that there aren't multiple rows with the same data in a table (is there a mysql command)?

e.g.

allowed (unique entries):
row1: hello | 2
row2: hello | 1
row3: buy it | 2

not allowed (double entry):
row1: hello | 2
row2: hello | 2

thanks

[hawk]

You can use UNIQUE key for the two columns and duplicated rows will be just rejected by MySQL

[[deleted]]

Remember that when you create unique indexes, you should NOT include the 'auto_increment' column, because that is already unique, it would void the 'unique' in the index.