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;