将文件拖动至此

SQL upload ( 0 ) x-

服务器: localhost »数据库: gym »表: mbw_store_qkq_received_history"门店请客券领取记录"
页面相关设置点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 : 用时 :
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 Whether a user should be displayed a "show all (rows)" button.
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 28 行, 查询花费 0.0002 秒。) [random_code: [BLOB - 20 字节]... - [BLOB - 20 字节]...]
SELECT * FROM `mbw_store_qkq_received_history` ORDER BY `random_code` ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
|
|
|
|
行数：
过滤行:
按索引排序:

完整内容idstore_id门店idqkq_id请客券idqkq_price请客券面值orig_owner原主人owner新主人expire_day_count请客券有效期天数expire_date请客券有效期日期random_code 递增 递减 1领取记录识别码status1:未使用;2:已核销add_time数据入库时间
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 31
31 192 9 300 2f6bc69e900dd5a63c515be6c16a7cce 0 0 4Ztks4P8BDspESGaspS2 1 1708769261
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 22
22 192 7 12 2f6bc69e900dd5a63c515be6c16a7cce 2f6bc69e900dd5a63c515be6c16a7cce 30 1702396800 7rnxBE8NkNHi6zAdhPPY 2 1699843523
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 7
7 184 2 30 2f6bc69e900dd5a63c515be6c16a7cce 2 1681574400 7xSkZP8xSsnSQbsfsKer 1 1681457356
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 2
2 184 2 30 4f2553b6be3e7548b1295f9a348b8ff6 2f6bc69e900dd5a63c515be6c16a7cce 2 1680969600 aTiDHjBJHGj5ZzStSP5M 2 1680846414
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 4
4 184 3 60 3d8248dad73b3f1775865bea2dbbb69c 2f6bc69e900dd5a63c515be6c16a7cce 2 1681315200 CTaQhxNQ2BtYZyc7jCWT 1 1681197649
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 29
29 192 7 12 2f6bc69e900dd5a63c515be6c16a7cce 0 0 CyKDerbNK8MJkBAGa2ka 1 1708706345
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 11
11 184 3 60 2f6bc69e900dd5a63c515be6c16a7cce 2f6bc69e900dd5a63c515be6c16a7cce 2 1682179200 dhgielrhgle 1 1682069071
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 14
14 184 2 30 2f6bc69e900dd5a63c515be6c16a7cce 2 1686067200 FbjJFi62fw8F5j2yKAHK 1 1685928884
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 21
21 192 7 10 2f6bc69e900dd5a63c515be6c16a7cce 0 0 GQDT6XWZfjBjTnMtBwaj 1 1696496641
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 19
19 192 7 10 2f6bc69e900dd5a63c515be6c16a7cce 0 0 HHkN5t6ytZyjMDwnNeEi 1 1696495979
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 26
26 192 8 20 2f6bc69e900dd5a63c515be6c16a7cce 0 0 hJHRCfBk4SHY5KQBFBxi 1 1707109582
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 20
20 192 7 10 2f6bc69e900dd5a63c515be6c16a7cce 0 0 iFnRYYjCKkd38hXpWiQT 1 1696496234
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 15
15 192 7 10 2f6bc69e900dd5a63c515be6c16a7cce 30 1694793600 iYSjr83FAFtAAXGKGE4w 1 1692282854
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 5
5 184 3 60 3d8248dad73b3f1775865bea2dbbb69c 2f6bc69e900dd5a63c515be6c16a7cce 2 1681315200 JerAWpnmy7a6jKaMfGbn 1 1681200092
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 18
18 192 7 10 2f6bc69e900dd5a63c515be6c16a7cce 0 0 JQA2KGEAGc7Fa5pMSaAH 1 1696495800
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 30
30 192 7 12 2f6bc69e900dd5a63c515be6c16a7cce 0 0 N7EBJ43JpXxdM8zHJW4m 1 1708745960
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 3
3 184 3 60 2f6bc69e900dd5a63c515be6c16a7cce 2 1680969600 nCxAFMEWi8s3GiXeYyaf 1 1680852824
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 25
25 192 8 20 2f6bc69e900dd5a63c515be6c16a7cce 2f6bc69e900dd5a63c515be6c16a7cce 0 0 P3FMDWbPTsefWD4T4MRY 2 1707102220
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 1
1 184 1 15 2f6bc69e900dd5a63c515be6c16a7cce 2f6bc69e900dd5a63c515be6c16a7cce 2 1680969600 P3zN3f4m2bNH3DRm6tjJ 2 1680846317
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 12
12 184 3 60 2f6bc69e900dd5a63c515be6c16a7cce 2f6bc69e900dd5a63c515be6c16a7cce 2 1682179200 Q7MmZbEQFiFTXN75eMcf 1 1682071862
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 8
8 184 2 30 2f6bc69e900dd5a63c515be6c16a7cce 2 1682006400 rcbjWh3tYBFBrHQd5xAA 1 1681914813
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 28
28 192 9 300 2f6bc69e900dd5a63c515be6c16a7cce 0 0 rrHEQk85K4fhBsYy4BJb 1 1708705054
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 17
17 192 7 10 2f6bc69e900dd5a63c515be6c16a7cce 30 1696176000 rSnbFY5PaQMHtdjj8R4G 1 1693668395
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 27
27 192 8 20 2f6bc69e900dd5a63c515be6c16a7cce 0 0 T3sEdmS24DrTBWxpRiBJ 1 1708704878
编辑 编辑复制 复制删除 删除
DELETE FROM `mbw_store_qkq_received_history` WHERE `mbw_store_qkq_received_history`.`id` = 24
24 192 9 300 2f6bc69e900dd5a63c515be6c16a7cce 30 1707408000 tBYWWHaesM23razQk8Rr 1 1704887938
选中项： 选中项：

|
|
|
|
行数：
过滤行:
按索引排序:
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出 显示图表 显示图表 新建视图 新建视图

将此 SQL 查询加为书签 将此 SQL 查询加为书签
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
使用配置文件中定义的控制用户连接失败。