Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: simpedak_db »Table: local_quality_indicator_result_recapitulation
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press 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 :

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.
Text fields

Customize text input fields.

Documentation Defines which type of editing controls should be used for CHAR and VARCHAR columns; input - allows limiting of input length, textarea - allows newlines in columns.
Documentation Defines the minimum size for input fields generated for CHAR and VARCHAR columns.
Documentation Defines the maximum size for input fields generated for CHAR and VARCHAR columns.
Documentation Number of columns for CHAR/VARCHAR textareas.
Documentation Number of rows for CHAR/VARCHAR textareas.
Documentation Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2).
Documentation Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2).
Documentation Double size of textarea for LONGTEXT columns.
ColumnTypeFunctionNullValue
recapitulation_idint
recapitulation_indicator_idint
recapitulation_institution_codevarchar(11)
recapitulation_department_idvarchar(5)
recapitulation_periodyear
recapitulation_jan_numeratorint
recapitulation_jan_denumeratorint
recapitulation_jan_post_datedate
recapitulation_feb_numeratorint
recapitulation_feb_denumeratorint
recapitulation_feb_post_datedate
recapitulation_mar_numeratorint
recapitulation_mar_denumeratorint
recapitulation_mar_post_datedate
recapitulation_apr_numeratorint
recapitulation_apr_denumeratorint
recapitulation_apr_post_datedate
recapitulation_may_numeratorint
recapitulation_may_denumeratorint
recapitulation_may_post_datedate
recapitulation_jun_numeratorint
recapitulation_jun_denumeratorint
recapitulation_jun_post_datedate
recapitulation_jul_numeratorint
recapitulation_jul_denumeratorint
recapitulation_jul_post_datedate
recapitulation_aug_numeratorint
recapitulation_aug_denumeratorint
recapitulation_aug_post_datedate
recapitulation_sep_numeratorint
recapitulation_sep_denumeratorint
recapitulation_sep_post_datedate
recapitulation_oct_numeratorint
recapitulation_oct_denumeratorint
recapitulation_oct_post_datedate
recapitulation_nov_numeratorint
recapitulation_nov_denumeratorint
recapitulation_nov_post_datedate
recapitulation_dec_numeratorint
recapitulation_dec_denumeratorint
recapitulation_dec_post_datedate
recapitulation_post_datedatetime
recapitulation_record_statuschar(1) A


ColumnTypeFunctionNullValue
recapitulation_idint
recapitulation_indicator_idint
recapitulation_institution_codevarchar(11)
recapitulation_department_idvarchar(5)
recapitulation_periodyear
recapitulation_jan_numeratorint
recapitulation_jan_denumeratorint
recapitulation_jan_post_datedate
recapitulation_feb_numeratorint
recapitulation_feb_denumeratorint
recapitulation_feb_post_datedate
recapitulation_mar_numeratorint
recapitulation_mar_denumeratorint
recapitulation_mar_post_datedate
recapitulation_apr_numeratorint
recapitulation_apr_denumeratorint
recapitulation_apr_post_datedate
recapitulation_may_numeratorint
recapitulation_may_denumeratorint
recapitulation_may_post_datedate
recapitulation_jun_numeratorint
recapitulation_jun_denumeratorint
recapitulation_jun_post_datedate
recapitulation_jul_numeratorint
recapitulation_jul_denumeratorint
recapitulation_jul_post_datedate
recapitulation_aug_numeratorint
recapitulation_aug_denumeratorint
recapitulation_aug_post_datedate
recapitulation_sep_numeratorint
recapitulation_sep_denumeratorint
recapitulation_sep_post_datedate
recapitulation_oct_numeratorint
recapitulation_oct_denumeratorint
recapitulation_oct_post_datedate
recapitulation_nov_numeratorint
recapitulation_nov_denumeratorint
recapitulation_nov_post_datedate
recapitulation_dec_numeratorint
recapitulation_dec_denumeratorint
recapitulation_dec_post_datedate
recapitulation_post_datedatetime
recapitulation_record_statuschar(1) A

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

Continue insertion with rows