CREATE DATABASE i;
USE i;
CREATE TABLE t (name VARCHAR(20),owner VARCHAR(20), who VARCHAR(20), pol CHAR(1), birth DATE, free DATE);
INSERT INTO t VALUES ('Ivanov88', 'Ivanova88', 'student', 'M', '2000-01-01', NULL);
INSERT INTO t VALUES ('Petrova88', 'Petrova88', 'vahtersha', 'F', '2000-01-01', NULL);
INSERT INTO t VALUES ('Sidorov88', 'Sidorova88', 'buhgalter', 'M', '2008-08-08', NULL);
SELECT * FROM t;
UPDATE t SET owner = 'B99' WHERE owner = 'Petrova88';
SELECT * FROM t;