SQLTicTacToe

CREATE PROCEDURE doturn(PLAYER INT, BRoW INT, BColumn INT)
BEGIN
  DECLARE CellBuffer INT;
  IF BColumn = 1 THEN
    SELECT BColumn1 INTO CellBuffer FROM tictactoe WHERE Row = BRoW;
    IF CellBuffer = 0 THEN
      UPDATE tictactoe
      SET BColumn1=PLAYER
      WHERE Row = BRoW;
    END IF;
  END IF;
  IF BColumn = 2 THEN
    SELECT BColumn2 INTO CellBuffer FROM tictactoe WHERE Row = BRoW;
    IF CellBuffer = 0 THEN
      UPDATE tictactoe
      SET BColumn2=PLAYER
      WHERE Row = BRoW;
    END IF;
  END IF;
  IF BColumn = 3 THEN
    SELECT BColumn3 INTO CellBuffer FROM tictactoe WHERE Row = BRoW;
    IF CellBuffer = 0 THEN
      UPDATE tictactoe
      SET BColumn3=PLAYER
      WHERE Row = BRoW;
    END IF;
  END IF;
END;