DROP TABLE if EXISTS test;
CREATE TEMPORARY TABLE test (
	id INT PRIMARY KEY AUTO_INCREMENT,
	fullName VARCHAR(100),
	isDumb CHAR(1));
	
	
	INSERT INTO test (fullName, isDumb) VALUES ('Joe', 'Y'), ('Jack', 'Y'), ('William', 'Y'), ('Avrell', 'Y');
	
	
SELECT id, isDumb FROM test;

UPDATE `test` SET `id`=1, `isDumb`='Y' WHERE;
UPDATE `test` SET `id`=2, `isDumb`='Y' WHERE;
UPDATE `test` SET `id`=3, `isDumb`='Y' WHERE;
UPDATE `test` SET `id`=4, `isDumb`='Y' WHERE;