Drop files here

SQL upload ( 0 ) x -

Page-related settings Click 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.
Edit mode
Documentation Disallow BLOB and BINARY columns from editing. Restore default value
Documentation Display the function fields in edit/insert mode. Restore default value
Documentation Defines whether or not type fields should be initially displayed in edit/insert mode. Restore default value
Documentation How many rows can be inserted at one time. Restore default value
Documentation Sort order for items in a foreign-key dropdown box; content is the referenced data, id is the key value. Restore default value
Documentation A dropdown will be used if fewer items are present. Restore default value
Text fields
Customize text input fields.
Text 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. Restore default value
Documentation Defines the minimum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Defines the maximum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Number of columns for CHAR/VARCHAR textareas. Restore default value
Documentation Number of rows for CHAR/VARCHAR textareas. Restore default value
Documentation Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Double size of textarea for LONGTEXT columns. Restore default value
Column Type Function Null Value
_recno int(11)
FP_CODIGO longtext
FP_DESCRIPCION longtext
FP_CLASIFICACION longtext
FP_MONEDA longtext
FP_STATUS bigint(20)
FP_DESCRIPCIONDETALLADA longtext
FP_DIRECCION1 longtext
FP_DIRECCION2 longtext
FP_DIRECCION3 longtext
FP_TELEFONO longtext
FP_TELEFAX longtext
FP_EMAIL longtext
FP_CONTACTO longtext
FP_WEBSITE longtext
FP_FORMAENVIO longtext
FP_NIT longtext
FP_RIF longtext
FP_LOGO longtext
FP_IMAGE longtext
FP_LIMITECREDITO double
FP_DIASCREDITO bigint(20)
FP_FECHAINICIO longtext
FP_TIPOCARGO bigint(20)
FP_FECHACARGO longtext
FP_ULTIMOCARGO longtext
FP_SALDO double
FP_PAGOSADELANTADOS double
FP_SALDOMONEDA2 double
FP_PAGOSADELMONEDA2 double
FP_TOTALCOMPRAS double
FP_MAXIMOCREDITO double
FP_PROMEDIOPAGODIAS bigint(20)
FP_DESCTOPRONTOPAGO bigint(20)
FP_TOTALIVAPAGADO double
FP_PORCRETENCION double
FP_DESCUENTOPRONTOPAGO longtext
FP_FECHANACIMIENTO longtext
BASE_AUTOINCREMENT bigint(20)
FP_FORMATOORDEN longtext
FP_FORMATOCOMPRA longtext
FP_FORMATODEVOLUCION longtext
FP_FORMATONOTAENTREGA longtext
FP_ESPECIAL bigint(20)
FP_CTOCOSTO longtext
FP_RETENCIONIVA double
FP_MSGTEXTO1 longtext
FP_MSGTEXTO2 longtext
FP_MSGTEXTO3 longtext
FP_MSGTEXTO4 longtext
FP_MSGTEXTO5 longtext
FP_TIPORETENCION longtext
FP_CODERETENCION longtext


Column Type Function Null Value
_recno int(11)
FP_CODIGO longtext
FP_DESCRIPCION longtext
FP_CLASIFICACION longtext
FP_MONEDA longtext
FP_STATUS bigint(20)
FP_DESCRIPCIONDETALLADA longtext
FP_DIRECCION1 longtext
FP_DIRECCION2 longtext
FP_DIRECCION3 longtext
FP_TELEFONO longtext
FP_TELEFAX longtext
FP_EMAIL longtext
FP_CONTACTO longtext
FP_WEBSITE longtext
FP_FORMAENVIO longtext
FP_NIT longtext
FP_RIF longtext
FP_LOGO longtext
FP_IMAGE longtext
FP_LIMITECREDITO double
FP_DIASCREDITO bigint(20)
FP_FECHAINICIO longtext
FP_TIPOCARGO bigint(20)
FP_FECHACARGO longtext
FP_ULTIMOCARGO longtext
FP_SALDO double
FP_PAGOSADELANTADOS double
FP_SALDOMONEDA2 double
FP_PAGOSADELMONEDA2 double
FP_TOTALCOMPRAS double
FP_MAXIMOCREDITO double
FP_PROMEDIOPAGODIAS bigint(20)
FP_DESCTOPRONTOPAGO bigint(20)
FP_TOTALIVAPAGADO double
FP_PORCRETENCION double
FP_DESCUENTOPRONTOPAGO longtext
FP_FECHANACIMIENTO longtext
BASE_AUTOINCREMENT bigint(20)
FP_FORMATOORDEN longtext
FP_FORMATOCOMPRA longtext
FP_FORMATODEVOLUCION longtext
FP_FORMATONOTAENTREGA longtext
FP_ESPECIAL bigint(20)
FP_CTOCOSTO longtext
FP_RETENCIONIVA double
FP_MSGTEXTO1 longtext
FP_MSGTEXTO2 longtext
FP_MSGTEXTO3 longtext
FP_MSGTEXTO4 longtext
FP_MSGTEXTO5 longtext
FP_TIPORETENCION longtext
FP_CODERETENCION longtext

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

Continue insertion with rows