Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: generics
Page-related settingsClick on the bar to scroll to top of page
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
xxxxxxxxxx
 
Options
Set default





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

Edit mode

Customize edit mode.

Documentation Disallow BLOB and BINARY columns from editing.
Documentation Display the function fields in edit/insert mode.
Documentation Defines whether or not type fields should be initially displayed in edit/insert mode.
Documentation How many rows can be inserted at one time.
Documentation Sort order for items in a foreign-key dropdown box; content is the referenced data, id is the key value.
Documentation A dropdown will be used if fewer items are present.
ColumnTypeFunctionNullValue
idint(11)
major_idint(11)
major_codevarchar(25)
major_descvarchar(60)
generic_codevarchar(20)
generic_descvarchar(50)
spe_instvarchar(1000)
dosagevarchar(1000)
drug_instvarchar(1000)
contensvarchar(1000)
spec_prevarchar(1000)
spe_effectvarchar(1000)
contra_indvarchar(1000)
contra_effectvarchar(1000)
created_datetimestamp CURRENT_TIMESTAMP ...
created_byint(11)
modified_datetimestamp 0000-00-00 00:00:00.000000 ...
modified_byint(11)
locationnamevarchar(20)


ColumnTypeFunctionNullValue
idint(11)
major_idint(11)
major_codevarchar(25)
major_descvarchar(60)
generic_codevarchar(20)
generic_descvarchar(50)
spe_instvarchar(1000)
dosagevarchar(1000)
drug_instvarchar(1000)
contensvarchar(1000)
spec_prevarchar(1000)
spe_effectvarchar(1000)
contra_indvarchar(1000)
contra_effectvarchar(1000)
created_datetimestamp CURRENT_TIMESTAMP ...
created_byint(11)
modified_datetimestamp 0000-00-00 00:00:00.000000 ...
modified_byint(11)
locationnamevarchar(20)

   and then   
Use TAB key to move from value to value, or CTRL+arrows to move anywhere

Continue insertion with rows