[SOLVED] Insert help

[Zergman]

I had a column in a table that was there since the beginning, but never used.  Since then, i've decided to use it.  It is just a varchar column, but currently was just NULL in all the entries.

 

I need a way to change the NULL in each record to another value but would rather not have to go one by one and change each record.

 

Im using phpmyadmin but couldn't find a way to do it easily.  Would there be any issues if I just remove the column, add it back with the same name and just put "*" in the default value field?  Would that work?

 

Suggestions?

[fenway]

Sure, why not a simple update statement?

[Zergman]

kk, so if my table name was data and my column name was action, this should do the trick right?

 

UPDATE data

SET action = %

WHERE action = NULL

[Zergman]

That didn't seem to do the trick.  Column is still empty.

 

Looking through syntax and even using quotes didn't help.

 

Only thing thats changed is the value NULL is gone.  Column is not empty

[Zergman]

Got it.

 

Just realized I didn't need the WHERE part.

 

Good to go, thanks fenway!