So, no idea why this isn't working for me...

Code is as follows:

insert into test (unique,Bathrooms,Bedrooms,City,County,Number,Rid) values ('1','3.00','5.00','San Francisco','San Francisco','34','2729')

But, when I take out the "unique" and the "1" out of the key/values, as below, it works:

insert into test (Bathrooms,Bedrooms,City,County,Number,Rid) values ('3.00','5.00','San Francisco','San Francisco','34','2729')

The error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unique,Bathrooms,Bedrooms,City,County,Number,Rid) values ('1',' at line 1

What am I overlooking?

Thanks for the help in advance.