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)
FTI_AUTOINCREMENT bigint(20)
FTI_DOCUMENTO longtext
FTI_TIPO bigint(20)
FTI_STATUS bigint(20)
FTI_VISIBLE bigint(20)
FTI_FECHAEMISION longtext
FTI_DEPOSITOSOURCE bigint(20)
FTI_DEPOSITODESTINO bigint(20)
FTI_TOTALITEMS bigint(20)
FTI_TOTALITEMSINICIAL bigint(20)
FTI_MONEDA bigint(20)
FTI_FACTORCAMBIO double
FTI_TOTALCOSTO double
FTI_TOTALCOSTOREAL double
FTI_CLASIFICACION bigint(20)
FTI_DESCRIPCLASIFY longtext
FTI_USER bigint(20)
FTI_AUTORIZADOPOR longtext
FTI_PROPOSITO longtext
FTI_RESPONSABLE longtext
FTI_DETALLE longtext
FTI_TIENELOTES bigint(20)
FTI_UPDATEITEMS bigint(20)
FTI_TOTALBRUTO double
FTI_DESCUENTO1PORCENT double
FTI_DESCUENTO1MONTO double
FTI_DESCUENTO1ORIGEN bigint(20)
FTI_DESCUENTO2PORCENT double
FTI_DESCUENTO2MONTO double
FTI_DESCUENTO2ORIGEN bigint(20)
FTI_DESCUENTOPARCIAL double
FTI_FLETEPORCENT double
FTI_FLETEMONEDA double
FTI_FLETEORIGEN bigint(20)
FTI_BASEIMPONIBLE double
FTI_BASEIMPONIBLE2 double
FTI_IMPUESTO1PORCENT double
FTI_IMPUESTO1MONTO double
FTI_IMPUESTO2PORCENT double
FTI_IMPUESTO2MONTO double
FTI_DESCUENTOCUADRE double
FTI_TOTALNETO double
FTI_FECHAVENCIDO longtext
FTI_DIASVENCIMIENTO bigint(20)
FTI_RIFCLIENTE longtext
FTI_NITCLIENTE longtext
FTI_PERSONACONTACTO longtext
FTI_TELEFONOCONTACTO longtext
FTI_DIRECCIONDESPACHO longtext
FTI_DETALLECOMENTARIO longtext
FTI_ORDENCOMPRA longtext
FTI_PLANILLAIMPORTACION longtext
FTI_EXISTEPLANILLAIMPORTACION bigint(20)
FTI_PORCENTFLETESINASIGNAR double
FTI_SALDOOPERACION double
FTI_MONEDAPAGO bigint(20)
FTI_FORMADEPAGO longtext
FTI_TOTALPRECIO double
FTI_VUELTO double
FTI_AUTORIZADOS bigint(20)
FTI_EXCENTO bigint(20)
FTI_COSTODEVENTA double
FTI_TIPOOPERACIONORIGEN bigint(20)
FTI_DOCUMENTOORIGEN longtext
FTI_FROMCOMPUESTOS bigint(20)
FTI_VENDEDORASIGNADO longtext
FTI_ZONAVENTA longtext
FTI_PENDINGFORPRINT bigint(20)
FTI_COBRADORASIGNADO longtext
FTI_COMISIONCOBROS double
FTI_COMISIONCOBROSBLOQUEADA bigint(20)
FTI_FACTURASLOTERANDOM longtext
FTI_MULTIPLEVENDEDOR bigint(20)
FTI_MULTIPLEDEPOSITO bigint(20)
FTI_TIMESAVED bigint(20)
FTI_TIPOPRECIO bigint(20)
BASE_AUTOINCREMENT bigint(20)
FTI_SERIE longtext
FTI_NAMEFORMATO longtext
FTI_MACHINENAME longtext
FTI_COMISIONVENTA double
FTI_MONTOPAGADO double
FTI_MONTOPERIODO double
FTI_PORCENTPERIODO double
FTI_HORA longtext
FTI_GUIADESPACHO longtext
FTI_NORECIBOCAJA longtext
FTI_CTOCOSTO longtext
FTI_COSTOACTUALNACIONAL double
FTI_COSTOACTUALEX double
FTI_PREFIXINVENTARIO longtext
FTI_NUMEROCONTROL longtext
FTI_COSTOAJUSTADO double
FTI_FACTORREFERENCIA double
FTI_FACTORREFERENCIA2 double
FTI_FINICIAL double
FTI_FINTERESES double
FTI_FINTERESESP double
FTI_FMANEJO double
FTI_FMANEJOP double
FTI_FEXTRAORDINARIA double
FTI_FCTDEXTRAORDINARIA bigint(20)
FTI_FINTEXTRAORDINARIA double
FTI_FMTOCUOTA double
FTI_FCTDCUOTA bigint(20)
FTI_FCOBRANZA double
FTI_TOTALFINANCIADO double
FTI_DETALLEGIROS longtext
FTI_SALDOFINANCIAR double
FTI_PRIMERACUOTA longtext
FTI_CAPITALCUOTAEXTRA double
FTI_CREDICARD longtext
FTI_MAQUINAFISCAL longtext
FTI_TOTALPAGINAS bigint(20)
FTI_SUCURSALORIGEN bigint(20)
FTI_FECHALIBRO longtext
FTI_IVAINTERESES double
FTI_REIMPRESAFISCAL bigint(20)
FTI_DCTOFISCALORIGEN longtext
FTI_FECHAFACTURA longtext
FTI_DCTOIVA double
FTI_MONEDACAMBIO longtext
FTI_TIPOFACTORCAMBIO bigint(20)
FTI_ORIGENCAMBIO bigint(20)
FTI_FACTORVUELTO double
FTI_CODECAMBIO longtext
FTI_VUELTOORG double
FTI_VTANAPAGO bigint(20)
FTI_MULTIVUELTO longtext
FTI_EXTRAFIELD01 longtext
FTI_EXTRAFIELD02 longtext
FTI_EXTRAFIELD03 longtext
FTI_EXTRAFIELD04 longtext
FTI_EXTRAFIELD05 longtext
FTI_BASEIGTF double


Column Type Function Null Value
_recno int(11)
FTI_AUTOINCREMENT bigint(20)
FTI_DOCUMENTO longtext
FTI_TIPO bigint(20)
FTI_STATUS bigint(20)
FTI_VISIBLE bigint(20)
FTI_FECHAEMISION longtext
FTI_DEPOSITOSOURCE bigint(20)
FTI_DEPOSITODESTINO bigint(20)
FTI_TOTALITEMS bigint(20)
FTI_TOTALITEMSINICIAL bigint(20)
FTI_MONEDA bigint(20)
FTI_FACTORCAMBIO double
FTI_TOTALCOSTO double
FTI_TOTALCOSTOREAL double
FTI_CLASIFICACION bigint(20)
FTI_DESCRIPCLASIFY longtext
FTI_USER bigint(20)
FTI_AUTORIZADOPOR longtext
FTI_PROPOSITO longtext
FTI_RESPONSABLE longtext
FTI_DETALLE longtext
FTI_TIENELOTES bigint(20)
FTI_UPDATEITEMS bigint(20)
FTI_TOTALBRUTO double
FTI_DESCUENTO1PORCENT double
FTI_DESCUENTO1MONTO double
FTI_DESCUENTO1ORIGEN bigint(20)
FTI_DESCUENTO2PORCENT double
FTI_DESCUENTO2MONTO double
FTI_DESCUENTO2ORIGEN bigint(20)
FTI_DESCUENTOPARCIAL double
FTI_FLETEPORCENT double
FTI_FLETEMONEDA double
FTI_FLETEORIGEN bigint(20)
FTI_BASEIMPONIBLE double
FTI_BASEIMPONIBLE2 double
FTI_IMPUESTO1PORCENT double
FTI_IMPUESTO1MONTO double
FTI_IMPUESTO2PORCENT double
FTI_IMPUESTO2MONTO double
FTI_DESCUENTOCUADRE double
FTI_TOTALNETO double
FTI_FECHAVENCIDO longtext
FTI_DIASVENCIMIENTO bigint(20)
FTI_RIFCLIENTE longtext
FTI_NITCLIENTE longtext
FTI_PERSONACONTACTO longtext
FTI_TELEFONOCONTACTO longtext
FTI_DIRECCIONDESPACHO longtext
FTI_DETALLECOMENTARIO longtext
FTI_ORDENCOMPRA longtext
FTI_PLANILLAIMPORTACION longtext
FTI_EXISTEPLANILLAIMPORTACION bigint(20)
FTI_PORCENTFLETESINASIGNAR double
FTI_SALDOOPERACION double
FTI_MONEDAPAGO bigint(20)
FTI_FORMADEPAGO longtext
FTI_TOTALPRECIO double
FTI_VUELTO double
FTI_AUTORIZADOS bigint(20)
FTI_EXCENTO bigint(20)
FTI_COSTODEVENTA double
FTI_TIPOOPERACIONORIGEN bigint(20)
FTI_DOCUMENTOORIGEN longtext
FTI_FROMCOMPUESTOS bigint(20)
FTI_VENDEDORASIGNADO longtext
FTI_ZONAVENTA longtext
FTI_PENDINGFORPRINT bigint(20)
FTI_COBRADORASIGNADO longtext
FTI_COMISIONCOBROS double
FTI_COMISIONCOBROSBLOQUEADA bigint(20)
FTI_FACTURASLOTERANDOM longtext
FTI_MULTIPLEVENDEDOR bigint(20)
FTI_MULTIPLEDEPOSITO bigint(20)
FTI_TIMESAVED bigint(20)
FTI_TIPOPRECIO bigint(20)
BASE_AUTOINCREMENT bigint(20)
FTI_SERIE longtext
FTI_NAMEFORMATO longtext
FTI_MACHINENAME longtext
FTI_COMISIONVENTA double
FTI_MONTOPAGADO double
FTI_MONTOPERIODO double
FTI_PORCENTPERIODO double
FTI_HORA longtext
FTI_GUIADESPACHO longtext
FTI_NORECIBOCAJA longtext
FTI_CTOCOSTO longtext
FTI_COSTOACTUALNACIONAL double
FTI_COSTOACTUALEX double
FTI_PREFIXINVENTARIO longtext
FTI_NUMEROCONTROL longtext
FTI_COSTOAJUSTADO double
FTI_FACTORREFERENCIA double
FTI_FACTORREFERENCIA2 double
FTI_FINICIAL double
FTI_FINTERESES double
FTI_FINTERESESP double
FTI_FMANEJO double
FTI_FMANEJOP double
FTI_FEXTRAORDINARIA double
FTI_FCTDEXTRAORDINARIA bigint(20)
FTI_FINTEXTRAORDINARIA double
FTI_FMTOCUOTA double
FTI_FCTDCUOTA bigint(20)
FTI_FCOBRANZA double
FTI_TOTALFINANCIADO double
FTI_DETALLEGIROS longtext
FTI_SALDOFINANCIAR double
FTI_PRIMERACUOTA longtext
FTI_CAPITALCUOTAEXTRA double
FTI_CREDICARD longtext
FTI_MAQUINAFISCAL longtext
FTI_TOTALPAGINAS bigint(20)
FTI_SUCURSALORIGEN bigint(20)
FTI_FECHALIBRO longtext
FTI_IVAINTERESES double
FTI_REIMPRESAFISCAL bigint(20)
FTI_DCTOFISCALORIGEN longtext
FTI_FECHAFACTURA longtext
FTI_DCTOIVA double
FTI_MONEDACAMBIO longtext
FTI_TIPOFACTORCAMBIO bigint(20)
FTI_ORIGENCAMBIO bigint(20)
FTI_FACTORVUELTO double
FTI_CODECAMBIO longtext
FTI_VUELTOORG double
FTI_VTANAPAGO bigint(20)
FTI_MULTIVUELTO longtext
FTI_EXTRAFIELD01 longtext
FTI_EXTRAFIELD02 longtext
FTI_EXTRAFIELD03 longtext
FTI_EXTRAFIELD04 longtext
FTI_EXTRAFIELD05 longtext
FTI_BASEIGTF double

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

Continue insertion with rows