By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable (
id int AUTO_INCREMENT NOT NULL,
title varchar(80),
owner varchar(30), -- record owner
PRIMARY KEY (id)
);
INSERT INTO `mytable` VALUES (1,'created by root','root'),(4,'created by helen','helen'),(6,'created by helen1','helen'),(7,'123','lina');
select * from mytable;
id | title | owner |
---|---|---|
1 | created by root | root |
4 | created by helen | helen |
6 | created by helen1 | helen |
7 | 123 | lina |