Could someone please show me how to insert data into a row that already has data. Something like this:
SETTING
`Column_4` int(3) DEFAULT NULL,
THIS IS ROW-3
col1 3 - col2 mike - col3 password - col4 is empty
I need to insert a single character (the number 1) into the empty field under column 4 for user “mike”. User name is primary I hope I worded this correctly. I’m using PHP-5.3.8 and MySQL-5.5.18 as localhost for learning.
I meant to say UPDATE and everything I tried using UPDATE did not work, that’s why I’m asking how-to. It’s easy if it has data but the field don’t have anything in it.