unique

[filipel]

How can i define in mysql table that a field is unique??

 

[feherke]

Hi

[gray]-- each has to be unique in its own[/gray]
[b]create[/b] [b]table[/b] first (
  one integer [b]unique[/b] [b]key[/b],
  two integer [b]unique[/b] [b]key[/b]
);

[gray]-- must be unique together[/gray]
[b]create[/b] [b]table[/b] second (
  one integer,
  two integer,
  [b]unique[/b] [b]key[/b] (one,two)
);

Feherke.

http://rootshell.be/~feherke/

 

[filipel]

yes but on mysql table editor doesnt work?

 

[feherke]

Hi

I do not know what "mysql table editor" is. I use the [tt]mysql[/tt] command line tool and the above examples work.

Feherke.

http://rootshell.be/~feherke/

 

[filipel]

ok