Quick question, altering a table to ignore blank entries?

[jacomus]

This is probably something quite basic with a quick answer, but what I want to do is alter a table to ignore blank entries.

 

I assume the syntax is similar to this statement below, which ignores duplicate entries (abc being the name of the table):

 

 

ALTER IGNORE TABLE abc

    -> ADD PRIMARY KEY (abc);

 

 

[fenway]

"ignore blank entires'/

[jacomus]

I tried fitting this all over the place into the syntax and I can't seem to get it to work. Sorry, I am fairly new to this program.

[gluck]

Heres is how you do it:

ALTER TABLE T ADD F NOT NULL , ADD PRIMARY KEY (F);

 

What do you mean by ignore blank entries? Why do you want to add a primary key?

[jacomus]

Thank you.

 

Also,

 

I mean when a blank entry is present in a text box, that it will not be entered into the database.

[gluck]

Thank you.

 

Also,

 

I mean when a blank entry is present in a text box, that it will not be entered into the database.

 

You'll have to check it on the php side because the moment you enter a duplicate it will generate a mysql error