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)
FI_CODIGO longtext
FI_DESCRIPCION longtext
FI_CATEGORIA longtext
FI_DESCRIPCIONDETALLADA longtext
FI_VENDEDOR longtext
FI_STATUS bigint(20)
FI_UNIDAD longtext
FI_TIPOCODIGOBARRA bigint(20)
FI_IMAGEN longtext
FI_SUSTITUTO1 longtext
FI_SUSTITUTO2 longtext
FI_SUSTITUTO3 longtext
FI_REFERENCIA longtext
FI_MARCA longtext
FI_MONEDA longtext
FI_FACTORCONVERSION double
FI_UNDEXISTENCIA2 longtext
FI_PUESTO longtext
FI_SUJETOACOMISION bigint(20)
FI_MONTOCOMISION double
FI_CUENTASCONTABLES bigint(20)
FI_PESOPRODUCTO double
FI_DIASDEREPOSICION bigint(20)
FI_PRESENTACION bigint(20)
FI_GARANTIA bigint(20)
FI_SUSTITUTO4 longtext
FI_SUSTITUTO5 longtext
FI_MONTOCOMISIONP bigint(20)
FI_DEPOSITOS bigint(20)
FI_OFERTAS bigint(20)
FI_VENCIMIENTOS bigint(20)
FI_CLASIFICACION bigint(20)
FI_MANEJOINVENTARIO bigint(20)
FI_SERIALES bigint(20)
FI_CREACION longtext
FI_INVENTARIOINICIALUNIDADES double
FI_INVENTARIOINICIALCOSTO double
FI_CAPACIDAD double
FI_EXISTDECIMAL bigint(20)
FI_COMPUESTOSERIALES bigint(20)
FI_VENDEDORFIJO longtext
FI_VENDEDORFIJOACTIVO bigint(20)
FI_MODELO longtext
FI_SUBCATEGORIA longtext
FI_PESOAFECTACOSTO bigint(20)
FI_IMPRESORA longtext
BASE_AUTOINCREMENT bigint(20)
FI_ZEXTRA1 double
FI_ZEXTRA2 double
FI_ZEXTRA3 double
FI_ZEXTRA4 double
FI_ZEXTRA5 double
FI_ZEXTRA6 double
FI_ZEXTRA1VENTA bigint(20)
FI_ZEXTRA2VENTA bigint(20)
FI_ZEXTRA3VENTA bigint(20)
FI_ZEXTRA4VENTA bigint(20)
FI_ZEXTRA5VENTA bigint(20)
FI_ZEXTRA6VENTA bigint(20)
FI_ZEXTRA1VENTAMOD bigint(20)
FI_ZEXTRA2VENTAMOD bigint(20)
FI_ZEXTRA3VENTAMOD bigint(20)
FI_ZEXTRA4VENTAMOD bigint(20)
FI_ZEXTRA5VENTAMOD bigint(20)
FI_ZEXTRA6VENTAMOD bigint(20)
FI_INTERNET bigint(20)
FI_BALANZA bigint(20)
FI_CODIGOBARRA bigint(20)
FI_PRECIOLISTA bigint(20)
FI_APROVECHAPORC double
FI_ARANCEL longtext
FI_POSENTREGA bigint(20)


Column Type Function Null Value
_recno int(11)
FI_CODIGO longtext
FI_DESCRIPCION longtext
FI_CATEGORIA longtext
FI_DESCRIPCIONDETALLADA longtext
FI_VENDEDOR longtext
FI_STATUS bigint(20)
FI_UNIDAD longtext
FI_TIPOCODIGOBARRA bigint(20)
FI_IMAGEN longtext
FI_SUSTITUTO1 longtext
FI_SUSTITUTO2 longtext
FI_SUSTITUTO3 longtext
FI_REFERENCIA longtext
FI_MARCA longtext
FI_MONEDA longtext
FI_FACTORCONVERSION double
FI_UNDEXISTENCIA2 longtext
FI_PUESTO longtext
FI_SUJETOACOMISION bigint(20)
FI_MONTOCOMISION double
FI_CUENTASCONTABLES bigint(20)
FI_PESOPRODUCTO double
FI_DIASDEREPOSICION bigint(20)
FI_PRESENTACION bigint(20)
FI_GARANTIA bigint(20)
FI_SUSTITUTO4 longtext
FI_SUSTITUTO5 longtext
FI_MONTOCOMISIONP bigint(20)
FI_DEPOSITOS bigint(20)
FI_OFERTAS bigint(20)
FI_VENCIMIENTOS bigint(20)
FI_CLASIFICACION bigint(20)
FI_MANEJOINVENTARIO bigint(20)
FI_SERIALES bigint(20)
FI_CREACION longtext
FI_INVENTARIOINICIALUNIDADES double
FI_INVENTARIOINICIALCOSTO double
FI_CAPACIDAD double
FI_EXISTDECIMAL bigint(20)
FI_COMPUESTOSERIALES bigint(20)
FI_VENDEDORFIJO longtext
FI_VENDEDORFIJOACTIVO bigint(20)
FI_MODELO longtext
FI_SUBCATEGORIA longtext
FI_PESOAFECTACOSTO bigint(20)
FI_IMPRESORA longtext
BASE_AUTOINCREMENT bigint(20)
FI_ZEXTRA1 double
FI_ZEXTRA2 double
FI_ZEXTRA3 double
FI_ZEXTRA4 double
FI_ZEXTRA5 double
FI_ZEXTRA6 double
FI_ZEXTRA1VENTA bigint(20)
FI_ZEXTRA2VENTA bigint(20)
FI_ZEXTRA3VENTA bigint(20)
FI_ZEXTRA4VENTA bigint(20)
FI_ZEXTRA5VENTA bigint(20)
FI_ZEXTRA6VENTA bigint(20)
FI_ZEXTRA1VENTAMOD bigint(20)
FI_ZEXTRA2VENTAMOD bigint(20)
FI_ZEXTRA3VENTAMOD bigint(20)
FI_ZEXTRA4VENTAMOD bigint(20)
FI_ZEXTRA5VENTAMOD bigint(20)
FI_ZEXTRA6VENTAMOD bigint(20)
FI_INTERNET bigint(20)
FI_BALANZA bigint(20)
FI_CODIGOBARRA bigint(20)
FI_PRECIOLISTA bigint(20)
FI_APROVECHAPORC double
FI_ARANCEL longtext
FI_POSENTREGA bigint(20)

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

Continue insertion with rows