jacomus Posted April 7, 2008 Share Posted April 7, 2008 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); Quote Link to comment Share on other sites More sharing options...
fenway Posted April 7, 2008 Share Posted April 7, 2008 "ignore blank entires'/ Quote Link to comment Share on other sites More sharing options...
jacomus Posted April 9, 2008 Author Share Posted April 9, 2008 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. Quote Link to comment Share on other sites More sharing options...
gluck Posted April 9, 2008 Share Posted April 9, 2008 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? Quote Link to comment Share on other sites More sharing options...
jacomus Posted April 9, 2008 Author Share Posted April 9, 2008 Thank you. Also, I mean when a blank entry is present in a text box, that it will not be entered into the database. Quote Link to comment Share on other sites More sharing options...
gluck Posted April 9, 2008 Share Posted April 9, 2008 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.