SQL code to automatically populate fields...

[Tim_L]

Hi,

Is there a sql code that I could use to populate a new empty field with the data that resides in another already populated field?

Any help would be appreciated!

[LordShryku]

UPDATE table
SET emptyfield = notSoEmptyField

[Tim_L]

Thank you kindly! Worked a treat... 😃

[jweissig]

hi,

You can check out all the options here in the mysql manual.

6.4.4 UPDATE Syntax

Using "update sometable set somecolumn = 'some coumn data'"; is a really simple option. when using a database you will want to use the where limiter so that you don't update all records in the database.

Use something like "update sometable set somecolumn = 'some coumn data' where someothercolumn = 45";

thanks,
- justin