27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE test
(
ID INT,
Name VARCHAR(100),
Sort INT
)
INSERT INTO test
SELECT 1, 'a', 1 UNION ALL
SELECT 2, 'b', 2 UNION ALL
SELECT 3, 'c', 3 UNION ALL
SELECT 4, 'd', 4
SELECT * FROM TEST
--插入时(在前台获取你的新的sort编号,插入在第3行)
UPDATE test SET sort = sort + 1 WHERE sort >= 3
INSERT INTO test VALUES(5, 'F', 3)
--追加时
INSERT INTO test SELECT 6, 'G', (SELECT COUNT(*)+1 FROM test)
--显示
SELECT * FROM test ORDER BY [sort]