Unsupported Screen Size: The viewport size is too small for the theme to render properly.

how do i set a field as unique with SQLyog 3.11

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › how do i set a field as unique with SQLyog 3.11

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • July 10, 2003 at 5:37 pm #8093
      terrymechan
      Member

      How do I set a field as unique with SQLyog 3.11

      I want to import data from an Excel csv file but if the data in any of the fileds already exits in the table, I wnat to skip it and import the next field

      Any Ideas?

      I can't find anywhere I can make a field (not the PKID field) unique to prevent duplicate data.

      regards

      terry mechan

      [email protected]

      http://www.morgle.com

    • July 11, 2003 at 6:48 am #14678
      Shadow
      Member

      Create a unique index on the given field. Import will fail if you want to import into an existing table (known flaw in v3.11)! After selecting wich table you want to import click transform, then click Edit SQL. Add a unique index on the given field. Run the import. SQLyog is going to give you a warning each time it encounters a duplicate entry and whether you want to proceed with the import.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.