Exam Code: 1Z0-883
Exam Name: MySQL 5.6 Database Administrator
A simple master-to-slave replication is currently https://www.lead4pass.com/1z0-883.html being used. The following information is extracted from the
SHOW SLAVE STATUS output:
Last_SQL_Error: Error ‘Duplicate entry ‘8’ for key ‘PRIMARY’ ‘ on query. Default database:’mydb’. Query: ‘insert into mytable VALUES (‘8’ , ‘George’) ‘ Skip_Counter: 0
Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1
You execute a “SHOW CREATE TABLE mytable” on the slave:
CREATE TABLE `mytable’ (`ID’ int(11) NOT NULL DEFAULT `0′, `name’ char(10) DEFAULT NULL, PRIMARY KEY (`ID’))
The table mytable on the 1Z0-883 slave contains the following:
You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error.
Which statement should be used?