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)
FC_CODIGO longtext
FC_DESCRIPCION longtext
FC_STATUS bigint(20)
FC_CLASIFICACION longtext
FC_DESCRIPCIONDETALLADA longtext
FC_NIT longtext
FC_RIF longtext
FC_TIPO bigint(20)
FC_CONTACTO longtext
FC_DIRECCION1 longtext
FC_DIRECCION2 longtext
FC_DIRECCION3 longtext
FC_TELEFONO longtext
FC_TELEFAX longtext
FC_EMAIL longtext
FC_WEBSITE longtext
FC_FORMAENVIO longtext
FC_ZONA longtext
FC_VENDEDOR longtext
FC_COBRADOR longtext
FC_LIMITECREDITO double
FC_DIASCREDITO bigint(20)
FC_MORA bigint(20)
FC_FECHAINICIO longtext
FC_MAXIMODESCUENTO double
FC_SALDO double
FC_PAGOSADELANTADOS double
FC_SALDOMONEDA2 double
FC_PAGOSADELMONEDA2 double
FC_TOTALVENTA double
FC_MAXIMOCREDITO double
FC_PROMEDIOPAGOSDIAS bigint(20)
FC_TOTALIVARETENIDO double
FC_DESCTOPRONTOPAGO bigint(20)
FC_FLAGCONTABILIDAD bigint(20)
FC_FLAGULTIMASOPERACIONES bigint(20)
FC_IMAGEN longtext
FC_FOTO longtext
FC_MONEDA longtext
FC_EXENTO bigint(20)
FC_FRECUENCIA bigint(20)
FC_DIACORTE bigint(20)
FC_PRECIODEFECTO bigint(20)
FC_DESCUENTOPRONTOPAGO longtext
FC_RECORDCONTADO bigint(20)
FC_FECHANACIMIENTO longtext
BASE_AUTOINCREMENT bigint(20)
FC_RETENCION double
FC_FORMATOFACTURA longtext
FC_FORMATOAPARTADO longtext
FC_FORMATOLOTE longtext
FC_FORMATODEVOLUCION longtext
FC_FORMATOPRESUPUESTO longtext
FC_FORMATONOTAENTREGA longtext
FC_FORMATOPEDIDO longtext
FC_MONEDACARGOSFIJO longtext
FC_MONEDACONVENIO longtext
FC_ESPECIAL bigint(20)
FC_HISTORICO bigint(20)
FC_EMISION longtext
FC_TOLERANCIA bigint(20)
FC_CTOCOSTO longtext
FC_MSGTEXTO1 longtext
FC_MSGTEXTO2 longtext
FC_MSGTEXTO3 longtext
FC_MSGTEXTO4 longtext
FC_MSGTEXTO5 longtext
FC_CODERETENCION longtext


Column Type Function Null Value
_recno int(11)
FC_CODIGO longtext
FC_DESCRIPCION longtext
FC_STATUS bigint(20)
FC_CLASIFICACION longtext
FC_DESCRIPCIONDETALLADA longtext
FC_NIT longtext
FC_RIF longtext
FC_TIPO bigint(20)
FC_CONTACTO longtext
FC_DIRECCION1 longtext
FC_DIRECCION2 longtext
FC_DIRECCION3 longtext
FC_TELEFONO longtext
FC_TELEFAX longtext
FC_EMAIL longtext
FC_WEBSITE longtext
FC_FORMAENVIO longtext
FC_ZONA longtext
FC_VENDEDOR longtext
FC_COBRADOR longtext
FC_LIMITECREDITO double
FC_DIASCREDITO bigint(20)
FC_MORA bigint(20)
FC_FECHAINICIO longtext
FC_MAXIMODESCUENTO double
FC_SALDO double
FC_PAGOSADELANTADOS double
FC_SALDOMONEDA2 double
FC_PAGOSADELMONEDA2 double
FC_TOTALVENTA double
FC_MAXIMOCREDITO double
FC_PROMEDIOPAGOSDIAS bigint(20)
FC_TOTALIVARETENIDO double
FC_DESCTOPRONTOPAGO bigint(20)
FC_FLAGCONTABILIDAD bigint(20)
FC_FLAGULTIMASOPERACIONES bigint(20)
FC_IMAGEN longtext
FC_FOTO longtext
FC_MONEDA longtext
FC_EXENTO bigint(20)
FC_FRECUENCIA bigint(20)
FC_DIACORTE bigint(20)
FC_PRECIODEFECTO bigint(20)
FC_DESCUENTOPRONTOPAGO longtext
FC_RECORDCONTADO bigint(20)
FC_FECHANACIMIENTO longtext
BASE_AUTOINCREMENT bigint(20)
FC_RETENCION double
FC_FORMATOFACTURA longtext
FC_FORMATOAPARTADO longtext
FC_FORMATOLOTE longtext
FC_FORMATODEVOLUCION longtext
FC_FORMATOPRESUPUESTO longtext
FC_FORMATONOTAENTREGA longtext
FC_FORMATOPEDIDO longtext
FC_MONEDACARGOSFIJO longtext
FC_MONEDACONVENIO longtext
FC_ESPECIAL bigint(20)
FC_HISTORICO bigint(20)
FC_EMISION longtext
FC_TOLERANCIA bigint(20)
FC_CTOCOSTO longtext
FC_MSGTEXTO1 longtext
FC_MSGTEXTO2 longtext
FC_MSGTEXTO3 longtext
FC_MSGTEXTO4 longtext
FC_MSGTEXTO5 longtext
FC_CODERETENCION longtext

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

Continue insertion with rows