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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling 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
codigo char(5)
nombre char(50)
codcon char(20)
cedula char(15)
apel_pater char(15)
apel_mater char(15)
nombres char(20)
razon char(50)
ruc char(15)
sexo bit(1) 0
estado char(10)
empresa char(35)
pais char(10)
ocupacion char(15)
conyuge char(36)
cedula_con char(15)
ciudad char(20)
zona char(5)
direcc char(36)
direcc2 char(36)
telefono char(20)
fax char(10)
observ char(60)
observ2 char(60)
limite double(8,5) 0.00000
plazo double(8,5) 0.00000
forma_pago char(12)
saldo double(8,5) 0.00000
activo bit(1) 0
chepro double(8,5) 0.00000
tipo char(1)
cargo char(15)
direcc_emp char(35)
telefo_emp char(10)
fecha_insc date
tarifa double(8,5) 0.00000
afiliado bit(1) 0
tarjeta char(10)
integrado bit(1) 0
enviado bit(1) 0
gafsa bit(1) 0
notinfpro double(8,5) 0.00000
clinica bit(1) 0
pordesadi double(8,5) 0.00000
fecha_ingr date
circuito double(8,5) 0.00000
cupo double(8,5) 0.00000
casa date
transporte bit(1) 0
genero char(1)
fecha_naci date
nombre_par char(36)
pariente char(15)
direcc_par char(36)
telefo_par char(15)
iess char(15)
consultas double(8,5) 0.00000
emplidjef char(10)
jefe char(5)
lide char(5)
refe char(5)
des_lide double(8,5) 0.00000
des_jefe double(8,5) 0.00000
des_refe double(8,5) 0.00000
celular char(9)
email char(245)
contacto char(36)
plazo_real double(8,5) 0.00000
direcc3 char(50)
direcc4 char(50)
direcc5 char(50)
matricula double(8,5) 0.00000
fecha_nac date
transp bit(1) 0
lejano bit(1) 0
con_vive char(36)
pad_viajan bit(1) 0
env_sino bit(1) 0
opera char(5)
digitado date
lugar_nac char(15)
barrio char(15)
religion char(15)
par_vive char(10)
per_financ char(36)
cua_tiempo double(8,5) 0.00000
cuanto double(8,5) 0.00000
siglas char(15)
vendedor char(5)
mens_pen_c char(15)
mens_tra_c char(15)
mens_ali_c char(15)
mens_var_c char(15)
mens_pen_p double(8,5) 0.00000
mens_tra_p double(8,5) 0.00000
mens_ali_p double(8,5) 0.00000
mens_var_p double(8,5) 0.00000
mens_pen_d double(8,5) 0.00000
mens_tra_d double(8,5) 0.00000
mens_ali_d double(8,5) 0.00000
mens_var_d double(8,5) 0.00000
tarc_num double(8,5) 0.00000
tarc_fec char(6)
tarc_emi char(15)
tarc_cod double(8,5) 0.00000
cecorcli char(60)
pag1cod char(13)
pag1por double(8,5) 0.00000
pag2cod char(13)
pag2por double(8,5) 0.00000
ret1_ced char(10)
ret1_nom char(45)
ret2_ced char(10)
ret2_nom char(45)
ret3_ced char(10)
ret3_nom char(45)
ret4_ced char(10)
ret4_nom char(45)
ret5_ced char(10)
ret5_nom char(45)


Column Type Function Null Value
codigo char(5)
nombre char(50)
codcon char(20)
cedula char(15)
apel_pater char(15)
apel_mater char(15)
nombres char(20)
razon char(50)
ruc char(15)
sexo bit(1) 0
estado char(10)
empresa char(35)
pais char(10)
ocupacion char(15)
conyuge char(36)
cedula_con char(15)
ciudad char(20)
zona char(5)
direcc char(36)
direcc2 char(36)
telefono char(20)
fax char(10)
observ char(60)
observ2 char(60)
limite double(8,5) 0.00000
plazo double(8,5) 0.00000
forma_pago char(12)
saldo double(8,5) 0.00000
activo bit(1) 0
chepro double(8,5) 0.00000
tipo char(1)
cargo char(15)
direcc_emp char(35)
telefo_emp char(10)
fecha_insc date
tarifa double(8,5) 0.00000
afiliado bit(1) 0
tarjeta char(10)
integrado bit(1) 0
enviado bit(1) 0
gafsa bit(1) 0
notinfpro double(8,5) 0.00000
clinica bit(1) 0
pordesadi double(8,5) 0.00000
fecha_ingr date
circuito double(8,5) 0.00000
cupo double(8,5) 0.00000
casa date
transporte bit(1) 0
genero char(1)
fecha_naci date
nombre_par char(36)
pariente char(15)
direcc_par char(36)
telefo_par char(15)
iess char(15)
consultas double(8,5) 0.00000
emplidjef char(10)
jefe char(5)
lide char(5)
refe char(5)
des_lide double(8,5) 0.00000
des_jefe double(8,5) 0.00000
des_refe double(8,5) 0.00000
celular char(9)
email char(245)
contacto char(36)
plazo_real double(8,5) 0.00000
direcc3 char(50)
direcc4 char(50)
direcc5 char(50)
matricula double(8,5) 0.00000
fecha_nac date
transp bit(1) 0
lejano bit(1) 0
con_vive char(36)
pad_viajan bit(1) 0
env_sino bit(1) 0
opera char(5)
digitado date
lugar_nac char(15)
barrio char(15)
religion char(15)
par_vive char(10)
per_financ char(36)
cua_tiempo double(8,5) 0.00000
cuanto double(8,5) 0.00000
siglas char(15)
vendedor char(5)
mens_pen_c char(15)
mens_tra_c char(15)
mens_ali_c char(15)
mens_var_c char(15)
mens_pen_p double(8,5) 0.00000
mens_tra_p double(8,5) 0.00000
mens_ali_p double(8,5) 0.00000
mens_var_p double(8,5) 0.00000
mens_pen_d double(8,5) 0.00000
mens_tra_d double(8,5) 0.00000
mens_ali_d double(8,5) 0.00000
mens_var_d double(8,5) 0.00000
tarc_num double(8,5) 0.00000
tarc_fec char(6)
tarc_emi char(15)
tarc_cod double(8,5) 0.00000
cecorcli char(60)
pag1cod char(13)
pag1por double(8,5) 0.00000
pag2cod char(13)
pag2por double(8,5) 0.00000
ret1_ced char(10)
ret1_nom char(45)
ret2_ced char(10)
ret2_nom char(45)
ret3_ced char(10)
ret3_nom char(45)
ret4_ced char(10)
ret4_nom char(45)
ret5_ced char(10)
ret5_nom char(45)

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

Continue insertion with rows