brucegregory Posted June 19, 2012 Share Posted June 19, 2012 I have a very populated MYSQL database and I need to make it so that when a input field in a form is left blank it has N/A in the database. So my solution is to change all of the default fields to N/A, but I have well over 500 rows. If I change this will it change my already populated rows with data in them? Thanks Quote Link to comment Share on other sites More sharing options...
Jessica Posted June 19, 2012 Share Posted June 19, 2012 If you change the default it will not change existing rows. You can run an update on them however. Quote Link to comment Share on other sites More sharing options...
scootstah Posted June 19, 2012 Share Posted June 19, 2012 Something like this: UPDATE table SET column='N/A' WHERE column='' Quote Link to comment Share on other sites More sharing options...
brucegregory Posted June 19, 2012 Author Share Posted June 19, 2012 Thank you for your help. I have fix my error with your advice! 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.