In MySQL, how do you perform data normalization?

Answer by  gigo (1706)

The first normalisation step is easy: if you have the same fields in different tables put them out in a separate table. In mysql you can do that with the standard command create table and alter table to remove the old column.

Answer by  gigo (1706)

With ALTER TABLE tablename create unique index you can reduce the redundant values in your Database. you just have to define the columns that should not be redundant. With that, you should be able to reach the normal forms 1 to 3. Keep in mind, that you can not influence, which line is not deleted.