将文件拖动至此

SQL 上传 ( 0 ) x -

页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 : 用时 :
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头，要禁止此功能请设为 0。 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值 
SELECT * FROM `characters` ORDER BY `slots` DESC
[ 编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
|
|
|
过滤行:
按索引排序：
完整内容 identifier steamname charidentifier group money gold rol xp healthouter healthinner staminaouter staminainner hours LastLogin inventory slots 递减 递增 1 job joblabel meta firstname lastname character_desc gender age nickname skinPlayer compPlayer compTints jobgrade coords status isdead skills walk gunsmith ammo discordid lastjoined afk_points multijobs
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:110000103013d88' AND `characters`.`charidentifier` = 56
 		steam:110000103013d88 Retnirp 56 user 6200.00 0.00 0.00 0 600 100 1065353216 100 0 2025-12-08 {} 40.0 unemployed Unemployed {} Peter Schwarz Wanderer from far away land. Male 29 Peter {"lipsticks_tx_id":0,"ageing_tx_id":3,"NoseDis":0.... {"Skirt":-1,"Gauntlets":-1,"EyeWear":633673784,"Ho... {"Belt":{"543415123":{"tint1":0,"tint0":0,"color":... 0 {"z":119.5106201171875,"heading":209.7637786865234... {"Hunger":954,"Thirst":910,"Metabolism":-140} 0 {"Hunting":{"Level":1,"NextLevel":100,"Exp":0,"Lab... noanim 0.00 {"AMMO_REVOLVER":25} 185308974239842304 [] 0 NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001088a36dd' AND `characters`.`charidentifier` = 55
 		steam:1100001088a36dd ToeyWk 55 user 6500.00 0.00 0.00 0 149 98 1065353216 100 0 2025-12-08 {} 40.0 unemployed Unemployed {} Toey Wk Fuck off Male 40 ToeyWk {"disc_tx_id":0,"NoseAng":0.0,"foundation_palette_... {"Cloak":-1,"Buckle":-1,"Skirt":-1,"Hat":-1,"CoatC... {"Boots":{"-218859683":{"palette":0,"tint0":0,"tin... 0 {"z":118.3648681640625,"heading":93.54330444335938... {"Hunger":980,"Metabolism":-176,"Thirst":878} 0 {"Hunting":{"Level":1,"NextLevel":100,"Exp":0,"Lab... noanim 0.00 {"AMMO_REVOLVER":25,"AMMO_22":69,"AMMO_RIFLE":10} 172398385230381067 [] 0 NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000010c5aa4d5' AND `characters`.`charidentifier` = 57
 		steam:11000010c5aa4d5 Lumpung 57 user 4100.00 0.00 0.00 0 600 100 1065353216 100 0 2025-12-08 {} 40.0 unemployed Unemployed {} Rook Vandal Butcher Male 58 RookButcher {"NeckW":-0.3,"MouthCLH":0.7,"beardstabble_visibil... {"NeckWear":-1,"CoatClosed":-1,"Glove":1584930588,... {"EyeWear":{"-606842995":{"tint1":117,"index":11,"... 0 {"z":117.6402587890625,"heading":51.02362442016601... {"Hunger":984,"Thirst":968,"Metabolism":-214} 0 {"Hunting":{"Level":1,"NextLevel":100,"Exp":0,"Lab... noanim 0.00 {"AMMO_22":20} 770674837944401962 [] 0 NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001182dd642' AND `characters`.`charidentifier` = 58
 		steam:1100001182dd642 Fang Yang 58 user 10009299.00 1.00 0.00 0 600 100 1065353216 100 0 2025-12-08 {} 40.0 doctor แพทย์ผู้เชี่ยวชาญ {} Fang Yang Fang Yang Male 37 Fang Yang {"eyebrows_visibility":1,"Waist":0,"lipsticks_pale... {"CoatClosed":-1,"GunbeltAccs":-1,"Bow":-1,"Pant":... {"Satchels":[],"Pant":{"1738549663":{"tint2":15,"c... 4 {"y":-569.5516357421875,"x":1243.96484375,"heading... {"Thirst":653,"Hunger":825,"Metabolism":-350} 0 {"Farming":{"Exp":0,"MaxLevel":5,"NextLevel":100,"... noanim 0.00 {"AMMO_REVOLVER":25,"AMMO_22":100} 232375258332659712 [] 0 NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001673b2cf6' AND `characters`.`charidentifier` = 54
 		steam:1100001673b2cf6 Tikket 54 user 601728.00 1.00 0.00 0 556 100 987786404 0 0 2025-11-03 {} 40.0 unemployed Unemployed {} CASON HOLE RIN
 Male 25 CASON {"EyeDis":0.0,"lipsticks_palette_color_tertiary":0... {"Boots":-218859683,"NeckTies":-1,"Buckle":-1,"Tee... {"Boots":{"-218859683":{"tint1":0,"palette":0,"tin... 0 {"z":116.96630859375,"heading":308.97637939453127,... {"Metabolism":2120,"Thirst":768,"Hunger":260} 0 {"Crafting":{"Label":"Beginner","Level":1,"Exp":0,... noanim 0.00 {} 439320304569942017 [] 0 NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:110000172e4a9da' AND `characters`.`charidentifier` = 59
 		steam:110000172e4a9da Jefferyy 59 user 10300.00 1.00 0.00 0 600 100 1065353216 100 0 2025-12-14 {} 40.0 unemployed Unemployed {} Jeffery Bloodboyz none Male 20 Jeffery {"foundation_palette_color_tertiary":0,"Legs":1741... {"Boots":-676537530,"GunbeltAccs":-1,"Poncho":-1,"... {"Cloak":{"-1081614863":{"tint1":0,"palette":0,"ti... 0 {"x":-279.75823974609377,"heading":221.10237121582... {"Thirst":756,"Metabolism":-248,"Hunger":876} 0 {"Fishing":{"Level":1,"Exp":0,"Label":"Beginner","... noanim 0.00 {} 1348435623790514206 [] 0 NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000010b1e8beb' AND `characters`.`charidentifier` = 65
 		steam:11000010b1e8beb Jerry West 65 user 86503.00 0.00 0.00 0 500 100 500 100 0 2026-02-16 {} 35.0 unemployed Unemployed {} Tokio Rexxy Legendary Wizard Female 300 TRexs {"MouthD":0.0,"eyebrows_visibility":1,"moles_visib... {"Coat":-1,"Vest":-1,"Spurs":-1,"Skirt":-1,"Spats"... {"Boots":{"-571902733":{"palette":0,"tint2":0,"tin... 0 {"x":-282.4483642578125,"y":786.6065673828125,"z":... {"Thirst":898,"Metabolism":-102,"Hunger":949} 0 {"Fishing":{"NextLevel":100,"MaxLevel":5,"Level":1... noanim 0.00 {} 616650339344580618 [] 0 []
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000010bece2a9' AND `characters`.`charidentifier` = 6
 		steam:11000010bece2a9 AnuGreenChanWeedRah !! 6 admin 680.59 2280.00 0.00 253 600 100 1065353216 100 0 2026-03-11 {} 35.0 ValSheriff Sheriff {} Test Admin wdwad\
 Female 25 KenNy {"moles_tx_id":0,"blush_palette_id":0,"paintedmask... {"Buckle":0,"Teeth":959712255,"bow":0,"Spats":-727... {"Teeth":{"959712255":[]},"Belt":{"-2083066025":[]... 1 {"y":800.927490234375,"x":-265.8988952636719,"head... {"Metabolism":-10000,"Hunger":809,"Thirst":618} 0 {"Mining":{"NextLevel":100,"Label":"Beginner","Lev... noanim 0.00 {"AMMO_REVOLVER":3} 305456573017358357 [] 74 []
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000010bece2a9' AND `characters`.`charidentifier` = 35
 		steam:11000010bece2a9 Corazon 35 admin 46712.00 0.00 0.00 0 600 100 1065353216 100 0 2026-02-01 {} 35.0 ValSheriff ValSheriff {} KenNy Ynr dWAd
 Male 25 KenNy {"LLiphW":0.0,"foundation_palette_color_primary":0... {"Belt":-1,"Gauntlets":-1,"Accessories":-1,"Teeth"... {"Pant":{"1939930032":{"tint2":0,"palette":0,"tint... 1 {"heading":96.37794494628906,"z":73.123046875,"y":... {"Thirst":862,"Hunger":931,"Metabolism":-1164} 0 {"Fishing":{"Label":"Beginner","Exp":0,"MaxLevel":... noanim 0.00 {} 305456573017358357 [] 74 []
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000010bece2a9' AND `characters`.`charidentifier` = 62
 		steam:11000010bece2a9 AnuGreenChanWeedRah !! 62 user 49710.20 0.00 0.00 0 500 100 500 100 0 2026-02-14 {} 35.0 ValSheriff 1 {} raytier ynr 15151
 Female 25 TestNoTwo {"eyeliner_color_primary":0,"moles_visibility":0,"... {"Gunbelt":1511461630,"Belt":-1,"NeckWear":-1,"Bow... {"Boots":{"-571902733":{"tint2":0,"tint0":0,"palet... 0 {"x":1355.8154296875,"y":-1315.094482421875,"z":76... {"Hunger":664,"Metabolism":-672,"Thirst":334} 0 {"Mining":{"Exp":0,"Label":"Beginner","NextLevel":... noanim 0.00 {} 305456573017358357 [] 74 []
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000011d5dd217' AND `characters`.`charidentifier` = 63
 		steam:11000011d5dd217 Call me 911 63 user 200.00 0.00 0.00 0 500 100 500 100 0 2026-02-07 {} 35.0 unemployed Unemployed {} Soey nolol hi
 Female 44 Soey nolol {"EyeBrowW":0.0,"hair_color_primary":0,"JawD":0.0,... {"Badge":-1,"Pant":1803504493,"Gunbelt":1511461630... {"Boots":{"-571902733":{"tint1":0,"palette":0,"tin... 0 {"y":738.6857299804688,"x":-362.0703430175781,"hea... {"Thirst":958,"Hunger":979,"Metabolism":-42} 0 {"Fishing":{"NextLevel":100,"Label":"Beginner","Ex... noanim 0.00 {} 330111230280859649 [] 0 []
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001317959c0' AND `characters`.`charidentifier` = 66
 		steam:1100001317959c0 soponwitsodamook11 66 user 100.00 0.00 0.00 0 500 100 500 100 0 2026-02-17 {} 35.0 unemployed Unemployed {} Aodso So Asasda Male 19 AodSo {"EyeLidH":0.0,"EyeBrowH":0.0,"EyeAng":0.0,"MouthC... {"Chap":-2055266779,"Shirt":-1665588256,"CoatClose... {"Chap":{"-2055266779":{"tint2":89,"tint1":0,"pale... 0 {"x":2294.03076171875,"y":-1142.0966796875,"z":42.... {"Metabolism":-270,"Hunger":888,"Thirst":779} 0 {"Fishing":{"Exp":0,"NextLevel":100,"MaxLevel":5,"... noanim 0.00 {} 1250399418817974323 [] 0 []
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000013fc687f3' AND `characters`.`charidentifier` = 64
 		steam:11000013fc687f3 . 64 user 200.00 0.00 0.00 0 500 100 500 100 0 2026-02-12 {} 35.0 unemployed Unemployed {} Aroi mak คนพเนจร Male 27 Moo Yong {"foundation_opacity":0,"lipsticks_palette_color_p... {"Holster":-1,"Vest":-1,"GunbeltAccs":-1,"Satchels... {"Boots":{"-218859683":{"tint2":0,"palette":0,"tin... 0 {"z":113.19189453125,"y":255.09890747070313,"x":13... {"Hunger":965,"Thirst":930,"Metabolism":-70} 0 {"Crafting":{"MaxLevel":5,"NextLevel":100,"Level":... noanim 0.00 {} 540890485556903947 [] 0 []
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000014901628c' AND `characters`.`charidentifier` = 60
 		steam:11000014901628c otooth1/ttv 60 user 200.00 0.00 0.00 0 500 100 500 100 0 2025-12-27 {} 35.0 unemployed Unemployed {} Maria Dilon none Female 45 Maria {"ChinW":0.0,"NeckD":0.0,"grime_opacity":0,"lipsti... {"Hat":-1,"Chap":-1,"Cloak":-1,"Boots":-571902733,... {"Shirt":{"-599669674":{"palette":0,"tint0":0,"tin... 0 {"y":620.1494750976563,"x":-172.5230712890625,"hea... {"Thirst":1000,"Metabolism":0,"Hunger":1000} 0 {"Fishing":{"Level":1,"Label":"Beginner","NextLeve... noanim 0.00 {} 523786497439301641 [] 0 []
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:110000154a6c454' AND `characters`.`charidentifier` = 67
 		steam:110000154a6c454 Jon Hot Sauce 67 user 200.00 0.00 0.00 0 500 100 500 100 0 2026-02-18 {} 35.0 unemployed Unemployed {} Jon Hot Good Male 50 Jon Hot Sauce {"shadows_palette_color_primary":0,"NoseS":0.0,"To... {"Teeth":712446626,"NeckTies":-1,"Spats":567040413... {"Dress":[],"Bracelet":[],"Spats":{"567040413":{"p... 0 {"x":-4360.5361328125,"heading":0.0,"z":20.9560546... {"Hunger":962,"Thirst":930,"Metabolism":-76} 0 {"Crafting":{"MaxLevel":5,"Label":"Beginner","Leve... MP_Style_Veteran 0.00 {} 1356878317571276833 [] 0 []
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000015ba23145' AND `characters`.`charidentifier` = 53
 		steam:11000015ba23145 Dreammy2001[TH] 53 user 18357.00 0.00 0.00 34 600 100 1065353216 100 0 2025-11-03 {} 35.0 unemployed Unemployed {} Saman Intarachote Saman Intarachote Male 25 Saman {"complex_opacity":0,"MouthCRD":0.0,"scars_tx_id":... {"Satchels":-1,"Gunbelt":-1435225965,"RingLh":-133... {"Loadouts":{"1723497063":{"index":12,"tint1":15,"... 0 {"z":116.6629638671875,"heading":107.7165374755859... {"Hunger":661,"Metabolism":4544,"Thirst":690} 0 {"Crafting":{"Label":"Beginner","Level":1,"Exp":0,... noanim 0.00 {"AMMO_ARROW":25} 1098465777646043166 [] 0 NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001673b2cf6' AND `characters`.`charidentifier` = 42
 		steam:1100001673b2cf6 WIN 42 user 0.00 5.00 0.00 157 549 100 1065353215 80 0 2026-02-05 {} 35.0 headdoctor Head Doctor {} Tikket Hole Running Male 25 Tikket {"EyeD":0.0,"NoseH":0.5,"EyeBrowD":0.0,"ChinW":0.0... {"Glove":0,"Dress":0,"Bracelet":97914417,"Chap":0,... {"RingLh":{"538207337":[]},"Bracelet":{"97914417":... 1 {"x":489.0725402832031,"heading":51.02362442016601... {"Metabolism":-10000,"Hunger":922,"Thirst":844} 0 {"Fishing":{"MaxLevel":5,"Label":"Beginner","Exp":... MP_Style_EasyRider 0.00 {"AMMO_ARROW":0,"AMMO_RIFLE":100,"AMMO_REPEATER":1... 439320304569942017 [] 0 []
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001673b2cf6' AND `characters`.`charidentifier` = 51
 		steam:1100001673b2cf6 Tikket 51 user 5719.00 1.00 0.00 12 589 100 1045206927 0 0 2025-11-03 {} 35.0 police {} WILSON HOLE ผู้พิทักษ์เมือง Male 30 WILSON {"MouthCRD":0.0,"hair_color_primary":17129595,"Ear... {"Glove":-495336667,"Cloak":-1,"Poncho":-1,"Skirt"... {"Glove":{"-495336667":{"tint1":114,"index":3,"col... 1 {"z":51.7237548828125,"heading":226.77166748046876... {"Thirst":895,"Hunger":174,"Metabolism":-3058} 0 {"Crafting":{"Label":"Beginner","Level":1,"Exp":0,... noanim 0.00 {"AMMO_REVOLVER":12,"AMMO_ARROW":0} 439320304569942017 [] 0 NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:1100001673b2cf6' AND `characters`.`charidentifier` = 52
 		steam:1100001673b2cf6 Tikket 52 user 5286.00 0.00 0.00 0 500 100 500 100 0 2025-11-02 {} 35.0 unemployed Unemployed {} TEST ECONAMY TEST
 Female 22 TEST ECONAMY {"CheekBonesD":0.0,"EyeD":0.0,"CalvesS":0.0,"ChinW... {"Gauntlets":-1,"Cloak":-1,"Chap":-1,"Boots":-5719... {"Shirt":{"-599669674":{"tint2":0,"tint0":0,"palet... 0 {"y":785.88134765625,"z":118.4827880859375,"headin... {"Thirst":95,"Hunger":439,"Metabolism":-916} 0 {"Farming":{"MaxLevel":5,"Label":"Beginner","NextL... noanim 0.00 {} 439320304569942017 [] 0 NULL
编辑 编辑 复制 复制 删除 删除
DELETE FROM characters WHERE `characters`.`identifier` = 'steam:11000016abeb0c7' AND `characters`.`charidentifier` = 61
 		steam:11000016abeb0c7 asd 61 user 200.00 0.00 0.00 0 500 100 500 100 0 2025-12-28 {} 35.0 unemployed Unemployed {} Johnson Del none Male 18 none {"scars_opacity":0,"ArmsS":0.0,"Torso":-162963160,... {"Dress":-1,"Bracelet":-1,"Cloak":-1,"Mask":-1,"Ch... {"Shirt":{"-1665588256":{"palette":0,"tint0":0,"ti... 0 {"y":650.3868408203125,"x":-235.2131805419922,"hea... {"Metabolism":-42,"Thirst":958,"Hunger":979} 0 {"Fishing":{"Level":1,"Label":"Beginner","NextLeve... noanim 0.00 {} 1028685967999119411 [] 0 []
选中项： 选中项：
|
|
|
过滤行:
按索引排序：
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签