Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Unanswered: MySQL table structure problem

    I have a mySQL table set up with three columns: "id" (autoincrement), "addy" (email address), and "zip" (zip code). The problem I am having is that for every legitimate new row I get, I also get a couple rows with a blank addy and zip. Is there something I can change in the structure of those columns, for example, make "addy" required so that if it is blank, the row is not added? I have it required on the Flash and PHP end, but I was hoping the mySQL structure itself would deny a row if "addy" was blank. Thanks in advance for your help.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I don't believe that MySQL supports CHECK constraints, so there probably isn't any declarative way to do what you've requested. If you can presume that email addresses are unique, then you could use a unique index on the address column and "salt" the table with a predefined row with a blank addy.


  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    NOT NULL might help you out here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts