创建Person表的SQL语句如下:

CREATE TABLE Person (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    score INT,
    birthday DATE
);

插入20条数据的SQL语句如下:

INSERT INTO Person (id, name, score, birthday) VALUES
(1, 'Tom', 80, '1990-01-01'),
(2, 'Jerry', 75, '1992-03-15'),
(3, 'Alice', 90, '1988-06-20'),
(4, 'Bob', 85, '1995-09-05'),
(5, 'John', 95, '1993-12-10'),
(6, 'Emily', 88, '1991-04-25'),
(7, 'Michael', 82, '1997-07-30'),
(8, 'Sophia', 91, '1989-10-15'),
(9, 'David', 77, '1994-02-28'),
(10, 'Emma', 84, '1996-05-05'),
(11, 'Daniel', 93, '1998-08-20'),
(12, 'Olivia', 78, '1992-11-25'),
(13, 'Matthew', 87, '1990-03-01'),
(14, 'Grace', 79, '1993-06-06'),
(15, 'Andrew', 96, '1995-09-11'),
(16, 'Jessica', 81, '1997-12-16'),
(17, 'William', 89, '1988-02-21'),
(18, 'Ava', 76, '1991-05-26'),
(19, 'James', 83, '1994-08-01'),
(20, 'Mia', 92, '1996-11-06');

对表进行CRUD操作的SQL语句如下:

  • 查询第6页的数据,每页展示3条数据:
SELECT * FROM Person ORDER BY id LIMIT 15, 3;
  • 插入一条数据:
INSERT INTO Person (id, name, score, birthday) VALUES (21, 'Liam', 90, '1991-07-05');
  • 更新一条数据:
UPDATE Person SET score = 95 WHERE id = 5;
  • 删除一条数据:
DELETE FROM Person WHERE id = 10;

最后展示第6页的数据,每页展示3条数据的SQL语句已经在前面给出

创建一个Person表有idnamescorebirthday等字段添加20条数据。然后对表进行CRUD操作最后展示第6页的数据每页展示3条数据。

原文地址: https://www.cveoy.top/t/topic/hWeX 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录