将文件拖动至此

SQL 上传 ( 0 ) x -

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





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头，要禁止此功能请设为 0。 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值 
SELECT * FROM `btw_football_matches`
[ 编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
|
|
|
过滤行:
按索引排序：
完整内容 id external_id source_system sport_id league_id league_name region_code region_name home_id home_name away_id away_name kickoff_at status minute_label home_score away_score first_half_home first_half_away last_seen_live_at finished_at raw_updated_at created_at updated_at
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 1
 		1 api-football:1508569 api-football 1 254 NWSL Women NULL USA 3003 NJ/NY Gotham FC W 18450 Angel City W 2026-10-05 00:00:00 finished FT 1 1 0 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 2
 		2 api-football:1534100 api-football 1 1182 Northern Super League NULL Canada 25896 AFC Toronto W 25901 Vancouver Rise W 2026-10-05 00:00:00 finished FT 1 1 1 1 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 3
 		3 api-football:1572986 api-football 1 878 Segunda División RFEF - Group 4 NULL Spain 9756 Ciudad de Lucena 9764 Puente Genil 2026-10-05 00:00:00 finished FT 1 0 1 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 4
 		4 api-football:1573600 api-football 1 142 Primera División Femenina NULL Spain 1918 Barcelona W 15224 Real Madrid W 2026-10-05 00:00:00 finished FT 7 0 5 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 5
 		5 api-football:1601450 api-football 1 163 Liga de Ascenso NULL Costa-Rica 2056 Aserri FC 821 Guadalupe FC 2026-10-05 00:00:00 finished FT 2 3 1 2 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 6
 		6 api-football:1601451 api-football 1 163 Liga de Ascenso NULL Costa-Rica 2043 ADR Jicaral 2055 AD Cofutpa 2026-10-05 00:00:00 finished FT 3 1 2 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 7
 		7 api-football:1601456 api-football 1 163 Liga de Ascenso NULL Costa-Rica 2057 Santa Ana 2052 Cariari Pococi 2026-10-05 00:00:00 finished FT 1 0 0 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 8
 		8 api-football:1615188 api-football 1 447 Tercera División RFEF - Group 9 NULL Spain 7523 Atlético Porcuna 26547 Churriana Vega 2026-10-05 00:00:00 finished FT 2 3 1 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 9
 		9 api-football:1615500 api-football 1 448 Tercera División RFEF - Group 10 NULL Spain 9767 San Roque Lepe 28109 Betis C 2026-10-05 00:00:00 finished FT 1 0 1 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 10
 		10 api-football:1617331 api-football 1 454 Tercera División RFEF - Group 16 NULL Spain 9865 Calasancio 9866 Casalarreina 2026-10-05 00:00:00 finished FT 2 1 2 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 11
 		11 api-football:1638757 api-football 1 1103 Premiership Women NULL Northern-Ireland 21486 Cliftonville W 16840 Glentoran BU W 2026-10-05 00:00:00 finished FT 4 1 0 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 12
 		12 api-football:1638758 api-football 1 1103 Premiership Women NULL Northern-Ireland 21488 Crusaders Strikers W 23632 Derry City W 2026-10-05 00:00:00 finished FT 2 3 1 1 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 13
 		13 api-football:1638759 api-football 1 1103 Premiership Women NULL Northern-Ireland 23629 Larne W 23261 Lisburn Ladies W 2026-10-05 00:00:00 finished FT 1 0 1 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 14
 		14 api-football:1638760 api-football 1 1103 Premiership Women NULL Northern-Ireland 23261 Lisburn Ladies W 10918 Linfield W 2026-10-05 00:00:00 finished FT 2 3 1 2 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 15
 		15 api-football:1561671 api-football 1 109 II Liga - East NULL Poland 13843 Zawisza Bydgoszcz 4247 Olimpia Grudziądz 2026-10-05 00:30:00 finished FT 1 2 0 2 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 16
 		16 api-football:1573607 api-football 1 142 Primera División Femenina NULL Spain 1909 Valencia W 1912 Real Sociedad W 2026-10-05 00:30:00 finished FT 0 1 0 1 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 17
 		17 api-football:1617028 api-football 1 453 Tercera División RFEF - Group 15 NULL Spain 28121 Gazte Berriak 28120 Doneztebe FT 2026-10-05 00:30:00 finished FT 1 0 1 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 18
 		18 api-football:1493160 api-football 1 128 Liga Profesional Argentina NULL Argentina 445 Huracan 463 Aldosivi 2026-10-05 00:45:00 finished FT 1 0 1 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 19
 		19 api-football:1498848 api-football 1 129 Primera Nacional NULL Argentina 462 Agropecuario 1963 Midland 2026-10-05 01:00:00 finished FT 0 0 0 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 20
 		20 api-football:1499661 api-football 1 131 Primera B Metropolitana NULL Argentina 8008 Comunicaciones 471 Flandria 2026-10-05 01:00:00 finished FT 1 1 1 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 21
 		21 api-football:1499669 api-football 1 131 Primera B Metropolitana NULL Argentina 8388 Sportivo Italiano 1927 Talleres Remedios 2026-10-05 01:00:00 finished FT 2 0 0 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 22
 		22 api-football:1500137 api-football 1 132 Primera C NULL Argentina 790 Central Cordoba 8398 Yupanqui 2026-10-05 01:00:00 finished FT 1 0 0 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 23
 		23 api-football:1500146 api-football 1 132 Primera C NULL Argentina 8396 Lugano 8389 Argentino Rosario 2026-10-05 01:00:00 finished FT 2 3 1 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 24
 		24 api-football:1500147 api-football 1 132 Primera C NULL Argentina 8397 Puerto Nuevo 8378 JJ Urquiza 2026-10-05 01:00:00 finished FT 1 4 0 2 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
编辑 编辑 复制 复制 删除 删除
DELETE FROM btw_football_matches WHERE `btw_football_matches`.`id` = 25
 		25 api-football:1500148 api-football 1 132 Primera C NULL Argentina 1942 Sacachispas 23099 Estrella Del Sur 2026-10-05 01:00:00 finished FT 0 0 0 0 NULL 2026-10-05 23:56:01 2026-10-05 23:56:01 2026-10-05 21:51:05 2026-10-05 23:56:01
选中项： 选中项：
|
|
|
过滤行:
按索引排序：
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签