mysql怎么查找rownum'

1、准备初始数据库建表语句与插入语句；

DROP TABLE IF EXISTS `user`;CREATE TABLE `user`  (  `userId` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',  `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',  `createTime` timestamp NULL DEFAULT NULL COMMENT '录入时间',  PRIMARY KEY (`userId`) USING BTREE) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of user-- ----------------------------INSERT INTO `user` VALUES ('1111', '测试数据1', '2018-08-25 21:41:53');INSERT INTO `user` VALUES ('2222', '测试数据2', '2018-08-25 21:42:05');INSERT INTO `user` VALUES ('3333', '测试数据3', '2018-08-25 21:42:18');SET FOREIGN_KEY_CHECKS = 1;

2、在navicat工具中执行上面的语句；

3、通过变量方式实现；

SELECT @rownum:=@rownum+1 rownum,u.*

FROM  (SELECT @rownum:=0) r,`user` u

ORDER BY u.createTime DESC;