I want to update the one record from a table with 'WHERE' clause.
I have install google/cloud-bigquery using composer for php.
My Code :
$cloud = new ServiceBuilder([
'keyFilePath' => 'Path for json file'
]);
$bigQuery = $cloud->bigQuery();
$dataset = $bigQuery->dataset('mydataset');
$table = $dataset->table('mytable');
$rows = $table->update(['name'=>'abc']);
My above code are not working.
1] Is it possible with this library or not.
2] If yes, then How can i pass the WHERE Clause in above $table->update(['name'=>'abc']); code.
3] How to set the field which i want to update.
My helping url https://googlecloudplatform.github.io/google-cloud-php/#/docs/google-cloud/v0.28.0/bigquery/table