> > >

PHP MCQs

How can you switch connection to appropriate shard and insert record of the manual partition?

mysqlnd_ms_fabric_select_global($mysqli, “test.fabrictest”); if ( !$mysqli->query(“CREATE TABLE test.fabrictest(id INT NOT NULL PRIMARY KEY)” )) { die(sprintf(“[%d] %s\n” , $mysqli->errno, $mysqli->error)); }

mysqlnd_ms_fabric_select_shard($mysqli, “test.fabrictest”, 10); if ( !$res = $mysqli->query(“SELECT id FROM test WHERE id = 10”))) { die(sprintf(“[%d] %s\n” , $mysqli->errno, $mysqli->error)); }

mysqlnd_ms_fabric_select_shard($mysqli, “test.fabrictest”, 10); if ( !$res = $mysqli->query(“INSERT INTO fabrictest (id) VALUES (10)”))) { die(sprintf(“[%d] %s\n” , $mysqli->errno, $mysqli->error)); }

mysqlnd_ms_fabric_select_shard($mysqli, “test.fabrictest”, 10); if ( !$res = $mysqli->query(“INSERT INTO fabrictest (id) VALUES (10)”))) { die(sprintf(“[$d] %s\n” , .mysqli->errno, $mysqli->error)); }

Answer

Correct Answer: mysqlnd_ms_fabric_select_shard($mysqli, “test.fabrictest”, 10); if ( !$res = $mysqli->query(“INSERT INTO fabrictest (id) VALUES (10)”))) { die(sprintf(“[%d] %s\n” , $mysqli->errno, $mysqli->error)); }

Explanation:

Note: This Question is unanswered, help us to find answer for this one

PHP Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it