--查询语句
select * from person;
--插入语句
INSERT into person VALUES(uuid(),'张三',20,'男');
--修改
UPDATE person set name='李四' where id='9cd44e82-af0f-1036-8ccd-1ae42a253dc0';
--删除
delete from person where id='9cd44e82-af0f-1036-8ccd-1ae42a253dc0';--插入数据
INSERT into person VALUES(uuid(),'张三',20,'男'),
(uuid(),'张三1',20,'男'),
(uuid(),'张三2',20,'男'),
(uuid(),'张三3',20,'男'),
(uuid(),'张三4',20,'男'),
(uuid(),'张三5',20,'男'),
set @name1=CONCAT('select * from person limit ',(3-1)*5,',',5,'');
PREPARE n from @name1;EXECUTE n;