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)
FCP_CODIGO longtext
FCP_FECHAEMISION longtext
FCP_CODIGOUNICO bigint(20)
FCP_CODIGOUNICO2 bigint(20)
FCP_NUMERO longtext
FCP_NUMERO2 longtext
FCP_TIPOTRANSACCION bigint(20)
FCP_TIPOOPERACION longtext
FCP_DOCUMENTOORIGEN longtext
FCP_DOCUMENTOAFECTADO longtext
FCP_DESCRIPCIONMOV longtext
FCP_FECHAVENCIMIENTO longtext
FCP_FECHAPROXIMA longtext
FCP_MONTODOCUMENTO double
FCP_SALDODOCUMENTO double
FCP_SALDOMONEDAEXT double
FCP_ULTABONODCTO longtext
FCP_ULTFECHAABONO longtext
FCP_ULTABONOMTO double
FCP_AFECTACOMPRASMES bigint(20)
FCP_AFECTALIBROCOMPRAS bigint(20)
FCP_MTOCOMISION double
FCP_COSTOOPERACION double
FCP_ESPAGO bigint(20)
FCP_ESCHEQUE bigint(20)
FCP_NROVENDEDOR longtext
FCP_ESRETENCION bigint(20)
FCP_USUARIO bigint(20)
FCP_MONTORETENCION double
FCP_CODERETENCION longtext
FCP_BASERETENCION double
FCP_BASEIMPONIBLE double
FCP_BASEIMPONIBLE2 double
FCP_MULTIPLERETENCION bigint(20)
FCP_MONTOMONEDAEXT double
FCP_FACTORCAMBIO double
FCP_IMPUESTO1 double
FCP_MTOIMPUESTO1 double
FCP_IMPUESTO1PORCENT bigint(20)
FCP_IMPUESTO2 double
FCP_MTOIMPUESTO2 double
FCP_IMPUESTO2PORCENT bigint(20)
FCP_ESCHEQUEDEVUELTO bigint(20)
FCP_VIENEDE bigint(20)
FCP_FORMAPAGO longtext
FCP_MONEDA bigint(20)
FCP_FECHARECEPCION longtext
FCP_MARKPERIODO bigint(20)
FCP_PAGOORIGINAL double
FCP_CONVERTED bigint(20)
BASE_AUTOINCREMENT bigint(20)
FCP_HORAEMISION longtext
FCP_CONTROL longtext
FCP_MONTOORIGINAL double
FCP_MONTOORIGINALEXT double
FCP_MACHINENAME longtext
FCP_ORDENPAGO longtext
FCP_CTOCOSTO longtext
FCP_FECHALIBRO longtext
FCP_SINCREDITOFISCAL bigint(20)
FCP_VTANAPAGO bigint(20)
FCP_MONEDACAMBIO longtext
FCP_ORIGENCAMBIO bigint(20)
FCP_CODECAMBIO longtext
FCP_VUELTOORG double
FCP_FACTORREFERENCIA double
FCP_FACTORVUELTO double
FCP_FACTORVUELTOTIPO longtext
FCP_ADELANTOXCAMBIO bigint(20)
FCP_FACTORREFERENCIA2 double
FCP_MULTIVUELTO longtext
FCP_BASEIGTF double


Column Type Function Null Value
_recno int(11)
FCP_CODIGO longtext
FCP_FECHAEMISION longtext
FCP_CODIGOUNICO bigint(20)
FCP_CODIGOUNICO2 bigint(20)
FCP_NUMERO longtext
FCP_NUMERO2 longtext
FCP_TIPOTRANSACCION bigint(20)
FCP_TIPOOPERACION longtext
FCP_DOCUMENTOORIGEN longtext
FCP_DOCUMENTOAFECTADO longtext
FCP_DESCRIPCIONMOV longtext
FCP_FECHAVENCIMIENTO longtext
FCP_FECHAPROXIMA longtext
FCP_MONTODOCUMENTO double
FCP_SALDODOCUMENTO double
FCP_SALDOMONEDAEXT double
FCP_ULTABONODCTO longtext
FCP_ULTFECHAABONO longtext
FCP_ULTABONOMTO double
FCP_AFECTACOMPRASMES bigint(20)
FCP_AFECTALIBROCOMPRAS bigint(20)
FCP_MTOCOMISION double
FCP_COSTOOPERACION double
FCP_ESPAGO bigint(20)
FCP_ESCHEQUE bigint(20)
FCP_NROVENDEDOR longtext
FCP_ESRETENCION bigint(20)
FCP_USUARIO bigint(20)
FCP_MONTORETENCION double
FCP_CODERETENCION longtext
FCP_BASERETENCION double
FCP_BASEIMPONIBLE double
FCP_BASEIMPONIBLE2 double
FCP_MULTIPLERETENCION bigint(20)
FCP_MONTOMONEDAEXT double
FCP_FACTORCAMBIO double
FCP_IMPUESTO1 double
FCP_MTOIMPUESTO1 double
FCP_IMPUESTO1PORCENT bigint(20)
FCP_IMPUESTO2 double
FCP_MTOIMPUESTO2 double
FCP_IMPUESTO2PORCENT bigint(20)
FCP_ESCHEQUEDEVUELTO bigint(20)
FCP_VIENEDE bigint(20)
FCP_FORMAPAGO longtext
FCP_MONEDA bigint(20)
FCP_FECHARECEPCION longtext
FCP_MARKPERIODO bigint(20)
FCP_PAGOORIGINAL double
FCP_CONVERTED bigint(20)
BASE_AUTOINCREMENT bigint(20)
FCP_HORAEMISION longtext
FCP_CONTROL longtext
FCP_MONTOORIGINAL double
FCP_MONTOORIGINALEXT double
FCP_MACHINENAME longtext
FCP_ORDENPAGO longtext
FCP_CTOCOSTO longtext
FCP_FECHALIBRO longtext
FCP_SINCREDITOFISCAL bigint(20)
FCP_VTANAPAGO bigint(20)
FCP_MONEDACAMBIO longtext
FCP_ORIGENCAMBIO bigint(20)
FCP_CODECAMBIO longtext
FCP_VUELTOORG double
FCP_FACTORREFERENCIA double
FCP_FACTORVUELTO double
FCP_FACTORVUELTOTIPO longtext
FCP_ADELANTOXCAMBIO bigint(20)
FCP_FACTORREFERENCIA2 double
FCP_MULTIVUELTO longtext
FCP_BASEIGTF double

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

Continue insertion with rows