Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: create_vendor_quotations
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 int(11) Yes NULL
3 varchar(20) latin1_swedish_ci Yes NULL
4 varchar(20) latin1_swedish_ci Yes NULL
5 varchar(20) latin1_swedish_ci Yes NULL
6 varchar(20) latin1_swedish_ci Yes NULL
7 varchar(20) latin1_swedish_ci Yes NULL
8 varchar(200) latin1_swedish_ci Yes NULL
9 varchar(200) latin1_swedish_ci Yes NULL
10 varchar(200) latin1_swedish_ci Yes NULL
11 varchar(200) latin1_swedish_ci Yes NULL
12 float(10,2) Yes NULL
13 float(10,2) Yes NULL
14 float(10,2) Yes NULL
15 float(10,2) Yes NULL
16 float(10,2) Yes NULL
17 float(10,2) Yes NULL
18 float(10,2) Yes NULL
19 float(10,2) Yes NULL
20 float(10,2) Yes NULL
21 float(10,2) Yes NULL
22 float(10,2) Yes NULL
23 float(10,2) Yes NULL
24 float(10,2) Yes NULL
25 float(10,2) Yes NULL
26 float(10,2) Yes NULL
27 varchar(20) latin1_swedish_ci Yes NULL
28 varchar(500) latin1_swedish_ci Yes NULL
29 varchar(2) latin1_swedish_ci Yes no
30 timestamp Yes NULL
31 varchar(20) latin1_swedish_ci Yes NULL
32 datetime Yes NULL
33 varchar(20) latin1_swedish_ci Yes NULL
34 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