alter ignore table <tablename> add unique key (field1,field2,....);

how to delete duplicate rows in sql server 2005?

Question Posted / balaji

Answer Posted / balaji

alter ignore table <tablename> add unique key
(field1,field2,....);

Is This Answer Correct ?

1 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is innodb_buffer_pool_size?

912

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

891

how to display nth highest salary from a table in a mysql query? : Mysql dba

1000

How do I start mysql manually?

864

What is field in mysql?

860

What are the disadvantages of mysql?

1006

How do you create a schema?

882

Can we create table in stored procedure?

901

What is 'mysqlcheck'?

963

all the queries used in sql

2589

What is join in mysql? What are the different types of join?

889

How do I import database through command line?

932

Is mysql and sql are same?

985

How many ways we can retrieve the date in result set of mysql using php?

1046

What does the file with the extension: frm, myd, and myi contain?

872