mysql 上一条 下一条

1.创建表

CREATE TABLE `user` (
`userId`  int(20) NOT NULL ,
`userName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`nickName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`passWord`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
)

INSERT INTO `user` VALUES (1, 'admin1', 'admin', 'admin');
INSERT INTO `user` VALUES (2, 'admin2', 'admin', 'admin');
INSERT INTO `user` VALUES (3, 'admin3', 'admin', 'admin');
INSERT INTO `user` VALUES (4, 'admin4', 'admin', 'admin');

2.查询

SELECT * FROM `user` where userId>3 ORDER BY userId ASC LIMIT 0,1;

SELECT * FROM `user` where userId<3 ORDER BY userId desc LIMIT 0,1;