Questions tagged as 'mysql'

Tagged questions
0
answers

I can not list with ajax php and jquery

When trying to list the products I get an error, the funny thing is that locally it works very well but when doing the deploy it shows me the error "DataTables warning: table id = datatable - Ajax error For more information about this error, ple...
asked by 30.09.2018 / 06:59
0
answers

Laravel-How can I insert in tables with many-to-many relationship when I have foreign keys created in mysql through migrations?

When I submit the form, it shows me this: error: Integrity constraint violation: 1452 Can not add or update to child row: a foreign key constraint fails (bolsa_empleo.aplicante_empleo, CONSTRAINT aplicantes_empleo_aplicante_usuario_id_foreign FO...
asked by 02.10.2018 / 14:08
0
answers

Remote access in shared server

I am using a shared server, for which I planned to access the files on my website (Via WinSCP) and its database (Via Mysql-Workbench). In Workbench I get the access error:    Can not connect to MySQL server on 's985.tmd.cloud' (10061) In...
asked by 17.08.2018 / 17:37
1
answer

Problems to perform a massive load on mysql

It turns out that I have created the following table: cabtm char (3) not null, cabdoc char(8) not null, cabdat date, cabven char (3) not null, cabcli char (12) not null, primary key (cabtm,cabdoc), index cabecera_fkindex1(cabven), foreign key(...
asked by 16.08.2018 / 21:17
1
answer

Bring categories with multiple levels

I have in database a table of categories of up to three levels. In this I keep their subcategories recursively. The structure is this: categoria ------------------ (pk) | id | nombre | slug | icono (fk) | padre <--...
asked by 02.08.2018 / 00:56
1
answer

How to list records with subrecords in mysql and php

What I want to do is the following, I have the following tables in the mysql database manager Tabla - comentarios id_foro int (11) id_comentarios int(11) id_user_comment int(11) file_comment text date_comment Tabla - respuestas_comentarios...
asked by 30.07.2018 / 16:35
0
answers

Validate select in registration form

I'm doing a fill-in-registration form where everything was fine except for the select, the code is as follows: Database: CREATE TABLE usuarios( id INT NOT NULL UNIQUE AUTO_INCREMENT, tipo_de_usuario VARCHAR(100) NOT NULL, nombre VARCHAR(2...
asked by 20.07.2018 / 00:07
1
answer

Intentions when uploading some images to the server with PHP

SOLVED THE PROBLEM. The problem is already solved and I explain it to you next in case someone else happens the same. The code initially worked without any problem but when uploading the images some of them failed and were uploaded in a c...
asked by 04.08.2018 / 19:04
1
answer

MySQL table creation methodology for repeated values

I want to ask you about what is most effective in a particular case. For example, I have these tables: The turn values would be "TOMORROW, EVENING AND NIGHT" my question goes in this sense, it is necessary to create a separate table (as...
asked by 04.08.2018 / 04:58
0
answers

Problem with group by in mysql and slowness in the query

I have the following situation with a MYSQL query. What happens to me is that I have two tables, that I'm joining by LEFT JOIN to bring all the records that are in the first table that is table3 . In the second table pay_amb where the...
asked by 10.09.2018 / 17:10