将文件拖动至此

SQL upload ( 0 ) x-

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





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

表结构

表结构(字段列表)的设置。

文档 是否隐藏对表结构的相关操作。
# 名字 类型 排序规则 属性 默认 额外 操作
1 int(11) AUTO_INCREMENT
2 int(11)
3 varchar(255) latin1_swedish_ci
4 varchar(20) latin1_swedish_ci
5 varchar(30) latin1_swedish_ci NULL
6 varchar(20) latin1_swedish_ci
7 varchar(20) latin1_swedish_ci NULL
8 varchar(20) latin1_swedish_ci
9 varchar(255) latin1_swedish_ci
10 varchar(20) latin1_swedish_ci NULL
11 varchar(20) latin1_swedish_ci NULL
12 varchar(20) latin1_swedish_ci NULL
13 varchar(50) latin1_swedish_ci
14 varchar(20) latin1_swedish_ci NULL
15 varchar(5) latin1_swedish_ci
16 varchar(10) latin1_swedish_ci NULL
17 varchar(10) latin1_swedish_ci NULL
18 varchar(6) latin1_swedish_ci NULL
19 varchar(50) latin1_swedish_ci NULL
20 varchar(255) latin1_swedish_ci NULL
21 varchar(1) latin1_swedish_ci
22 varchar(10) latin1_swedish_ci NULL
23 varchar(15) latin1_swedish_ci NULL
24 varchar(20) latin1_swedish_ci NULL
25 varchar(10) latin1_swedish_ci NULL
26 varchar(20) latin1_swedish_ci NULL
27 varchar(20) latin1_swedish_ci NULL
28 varchar(20) latin1_swedish_ci NULL
29 varchar(20) latin1_swedish_ci NULL
30 varchar(20) latin1_swedish_ci NULL
31 varchar(20) latin1_swedish_ci NULL
32 varchar(50) latin1_swedish_ci NULL
33 varchar(20) latin1_swedish_ci NULL
34 varchar(30) latin1_swedish_ci NULL
35 varchar(20) latin1_swedish_ci NULL
36 varchar(20) latin1_swedish_ci NULL
37 varchar(20) latin1_swedish_ci NULL
38 varchar(20) latin1_swedish_ci NULL
39 varchar(20) latin1_swedish_ci NULL
40 varchar(500) latin1_swedish_ci NULL
41 text latin1_swedish_ci NULL
42 varchar(20) latin1_swedish_ci NULL
43 int(11)
44 varchar(10) latin1_swedish_ci NULL
45 varchar(50) latin1_swedish_ci NULL
46 varchar(20) latin1_swedish_ci
47 int(11)
48 varchar(12) latin1_swedish_ci NULL
49 varchar(50) latin1_swedish_ci NULL
50 int(11)
51 varchar(20) latin1_swedish_ci
52 varchar(20) latin1_swedish_ci NULL
53 varchar(20) latin1_swedish_ci NULL
54 varchar(50) latin1_swedish_ci NULL
55 datetime
56 varchar(20) latin1_swedish_ci NULL
57 datetime NULL
58 varchar(20) latin1_swedish_ci NULL
59 varchar(20) latin1_swedish_ci NULL
60 varchar(20) latin1_swedish_ci NULL
61 varchar(20) latin1_swedish_ci NULL
62 enum('paid', 'unpaid') latin1_swedish_ci unpaid
63 int(11) NULL
64 varchar(50) latin1_swedish_ci NULL
65 varchar(10) latin1_swedish_ci NULL
66 varchar(10) latin1_swedish_ci NULL
67 varchar(20) latin1_swedish_ci NULL
68 int(11) 0
69 varchar(100) latin1_swedish_ci
70 varchar(100) latin1_swedish_ci
71 varchar(100) latin1_swedish_ci
72 varchar(100) latin1_swedish_ci
73 varchar(5) latin1_swedish_ci
74 varchar(20) latin1_swedish_ci
75 text latin1_swedish_ci

添加字段  添加 个字段  
信息
已用空间
数据 24.6 MB
索引 16.1 MB
总计 40.7 MB
Row statistics
格式 Compact
排序规则 latin1_swedish_ci
下一个自增值 93,340
创建时间 2024-08-28 12:35:07