SELECT VERSION();

DROP TABLE IF EXISTS test.temp;

CREATE TABLE test.temp (
    ColA CHAR(36) NOT NULL PRIMARY KEY,
    ColB INT NOT NULL
);

SET @a = UUID(),
    @b = 1;

INSERT INTO test.temp VALUES(@a, @b);

SELECT *
FROM   test.temp;

SELECT *
FROM   test.temp T1
WHERE  T1.ColA = @a;

UPDATE test.temp T1
SET    T1.ColB = 2
WHERE  T1.ColA = @a;

SELECT ROW_COUNT();

SELECT *
FROM   test.temp;

DROP TABLE IF EXISTS test.temp;

CREATE TABLE test.temp
SELECT UUID();

DESC test.temp;