This topic is locked

PHPmyadmin

10/29/2007 11:54:54 AM
PHPRunner General questions
O
osluk author

Can I use a MySql query to populate each field with a figure in this case 2005 which should be in a given field but the excel source file has the column removed?
This is a once only initail validation process.
Cheers Chris

J
Jane 10/30/2007

Chris,
sure you can use your query to update database.

But this question has nothing to do with PHPRunner.

T
thesofa 10/30/2007

Can I use a MySql query to populate each field with a figure in this case 2005 which should be in a given field but the excel source file has the column removed?

This is a once only initail validation process.
Cheers Chris



Try looking here update queries

Or you could export the data to an Excel file add the column and re-import?