Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: ipd_nurse_notes
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Table structure

Settings for the table structure (list of columns).

Documentation Whether the table structure actions should be hidden.
# Name Type Collation Attributes Null Default Extra Action
1 int(11) No None AUTO_INCREMENT
2 varchar(20) latin1_swedish_ci Yes NULL
3 varchar(50) latin1_swedish_ci Yes NULL
4 date Yes NULL
5 int(15) Yes NULL
6 int(10) Yes NULL
7 varchar(50) latin1_swedish_ci Yes NULL
8 varchar(50) latin1_swedish_ci Yes NULL
9 varchar(50) latin1_swedish_ci Yes NULL
10 varchar(50) latin1_swedish_ci Yes NULL
11 varchar(50) latin1_swedish_ci Yes NULL
12 varchar(50) latin1_swedish_ci Yes NULL
13 varchar(50) latin1_swedish_ci Yes NULL
14 int(10) Yes NULL
15 date Yes NULL
16 int(10) Yes NULL
17 int(10) Yes NULL
18 int(10) Yes NULL
19 varchar(50) latin1_swedish_ci Yes NULL
20 varchar(50) latin1_swedish_ci Yes NULL
21 text latin1_swedish_ci Yes NULL
22 datetime Yes NULL
23 datetime Yes NULL
24 varchar(11) latin1_swedish_ci Yes NULL
25 varchar(11) latin1_swedish_ci Yes NULL
26 varchar(100) latin1_swedish_ci Yes NULL
27 varchar(100) latin1_swedish_ci Yes NULL
28 varchar(100) latin1_swedish_ci Yes NULL
29 varchar(100) latin1_swedish_ci Yes NULL
30 varchar(100) latin1_swedish_ci Yes NULL
31 varchar(100) latin1_swedish_ci Yes NULL
32 varchar(100) latin1_swedish_ci Yes NULL
33 varchar(100) latin1_swedish_ci Yes NULL
34 varchar(100) latin1_swedish_ci Yes NULL
35 varchar(100) latin1_swedish_ci Yes NULL
36 varchar(20) latin1_swedish_ci Yes NULL

Add column  Add column(s)  
Information
Space usage
Data 16 KiB
Index 0 B
Total 16 KiB
Row statistics
Format Compact
Collation latin1_swedish_ci
Next autoindex 1
Creation Aug 28, 2024 at 12:35 PM