¡@

Home 

php Programming Glossary: col_values

Update MySql Field (if field is not empty, go to next one)

http://stackoverflow.com/questions/11176410/update-mysql-field-if-field-is-not-empty-go-to-next-one

null then 9 else col1 end Example Table mysql create table col_values id INT col1 INT col2 INT col3 INT Query OK 0 rows affected 0.06.. INT Query OK 0 rows affected 0.06 sec mysql insert into col_values values 1 1 1 NULL 2 1 NULL NULL 3 NULL NULL NULL Query OK 3.. sec Records 3 Duplicates 0 Warnings 0 mysql select from col_values id col1 col2 col3 1 1 1 NULL 2 1 NULL NULL 3 NULL NULL NULL..