UPDATE表值，不知道列名PHP [重复]

Question

This question already has an answer here:

• MySQL query to get column names? 19 answers

Here is the situation. I just know total number of columns the table test_table has but don't know their names(sounds strange but its true). Is there any way I can write UPDATE Query for all column values on basis of some ID(auto-increment primary key)?

To add row in this table, I did following which is working but don't have idea how to do it for UPDATE:

$newCols = $_POST['newRowCols'];
$query = "INSERT INTO test_table VALUES "."("."NULL";   
foreach($newCols as $col)
{
$query .= ",'$col'";
}   
$query.=")";
mysqli_query($con,$query);

Thanks.

</div>

Answer 1

No this is not possible. But you can get the column names using the information_schema database:

SELECT 
  `ORDINAL_POSITION`,
  `COLUMN_NAME`
FROM `information_schema`.COLUMNS
WHERE
  `TABLE_SCHEMA` = $dbname
AND
  `TABLE_NAME` = $tablename
ORDER BY `ORDINAL_POSITION`