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)
FD_CODIGO longtext
FD_DESCRIPCION longtext
FD_DESCRIPCIONDETALLADA longtext
FD_STATUS bigint(20)
FD_PORCENTAJEUTILIDAD1 double
FD_PORCENTAJEUTILIDAD2 double
FD_PORCENTAJEUTILIDAD3 double
FD_PORCENTAJEUTILIDAD4 double
FD_PORCENTAJEUTILIDAD5 double
FD_PORCENTAJEUTILIDAD6 double
FD_COMVTAPRODUCTOS bigint(20)
FD_COMCOBROPRODUCTOS bigint(20)
FD_CLASIFICACION bigint(20)
FD_MANEJOINVENTARIO bigint(20)
FD_SERIALES bigint(20)
FD_VENCIMIENTO bigint(20)
FD_OFERTAS bigint(20)
FD_TALLAS_EJEX bigint(20)
FD_TALLAS_EJEY bigint(20)
FD_NROPRODUCTOS bigint(20)
FD_DEPOSITOS bigint(20)
FD_PORCENTAJEDESCUENTO1 double
FD_PORCENTAJEDESCUENTO2 double
FD_PORCENTAJEDESCUENTO3 double
FD_PORCENTAJEDESCUENTO4 double
FD_PORCENTAJEDESCUENTO5 double
FD_PORCENTAJEDESCUENTO6 double
FD_TALLAS_DESCRX longtext
FD_TALLAS_DESCRY longtext
FD_INDEXPORCENT bigint(20)
FD_COMISIONVTA1 double
FD_COMISIONVTA2 double
FD_COMISIONVTA3 double
FD_COMISIONVTA4 double
FD_COMISIONVTA5 double
FD_COMISIONVTA6 double
FD_COMISIONCOB1 double
FD_COMISIONCOB2 double
FD_COMISIONCOB3 double
FD_COMISIONCOB4 double
FD_COMISIONCOB5 double
FD_COMISIONCOB6 double
FD_COMISIONVTAMIN double
FD_COMISIONCOBMIN double
FD_TOLERANCIA longtext
FD_DETALLE_EJEX longtext
FD_DETALLE_EJEY longtext
FD_PREFIJO longtext
BASE_AUTOINCREMENT bigint(20)
FD_PSICOTROPICO bigint(20)
FD_ARANCEL longtext
FD_IMPRESORA longtext


Column Type Function Null Value
_recno int(11)
FD_CODIGO longtext
FD_DESCRIPCION longtext
FD_DESCRIPCIONDETALLADA longtext
FD_STATUS bigint(20)
FD_PORCENTAJEUTILIDAD1 double
FD_PORCENTAJEUTILIDAD2 double
FD_PORCENTAJEUTILIDAD3 double
FD_PORCENTAJEUTILIDAD4 double
FD_PORCENTAJEUTILIDAD5 double
FD_PORCENTAJEUTILIDAD6 double
FD_COMVTAPRODUCTOS bigint(20)
FD_COMCOBROPRODUCTOS bigint(20)
FD_CLASIFICACION bigint(20)
FD_MANEJOINVENTARIO bigint(20)
FD_SERIALES bigint(20)
FD_VENCIMIENTO bigint(20)
FD_OFERTAS bigint(20)
FD_TALLAS_EJEX bigint(20)
FD_TALLAS_EJEY bigint(20)
FD_NROPRODUCTOS bigint(20)
FD_DEPOSITOS bigint(20)
FD_PORCENTAJEDESCUENTO1 double
FD_PORCENTAJEDESCUENTO2 double
FD_PORCENTAJEDESCUENTO3 double
FD_PORCENTAJEDESCUENTO4 double
FD_PORCENTAJEDESCUENTO5 double
FD_PORCENTAJEDESCUENTO6 double
FD_TALLAS_DESCRX longtext
FD_TALLAS_DESCRY longtext
FD_INDEXPORCENT bigint(20)
FD_COMISIONVTA1 double
FD_COMISIONVTA2 double
FD_COMISIONVTA3 double
FD_COMISIONVTA4 double
FD_COMISIONVTA5 double
FD_COMISIONVTA6 double
FD_COMISIONCOB1 double
FD_COMISIONCOB2 double
FD_COMISIONCOB3 double
FD_COMISIONCOB4 double
FD_COMISIONCOB5 double
FD_COMISIONCOB6 double
FD_COMISIONVTAMIN double
FD_COMISIONCOBMIN double
FD_TOLERANCIA longtext
FD_DETALLE_EJEX longtext
FD_DETALLE_EJEY longtext
FD_PREFIJO longtext
BASE_AUTOINCREMENT bigint(20)
FD_PSICOTROPICO bigint(20)
FD_ARANCEL longtext
FD_IMPRESORA longtext

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

Continue insertion with rows