Questions tagged as 'mysql'

Tagged questions
0
answers

Error configuration socket phpMyAdmin - Kali linux

SYSTEM INFORMATION: -GNU LINUX / KALI -amd64 Hello. I have a problem trying to enter phpMyAdmin, and what I see is about the socket configuration. However, I tried to repair this address (which is what I found in most forums)....
asked by 24.05.2018 / 23:27
1
answer

Save articles / post with format and images

I have searched some courses or google but I have not succeeded or suddenly I have eaten my head alone. If I have a blog page, information articles with nice text with a typeface, in italics and with nose styles and some images inside. How can I...
asked by 20.05.2018 / 12:14
0
answers

Hello, I get this error

void eliminar_producto(int id){ for(producto1 p:listaproducto){ if (p.getId()==id) { listaproducto.remove(id); } } } C when I run this case in the public static void main()...
asked by 20.05.2018 / 15:51
0
answers

404 error when trying to insert using ajax

I am trying to implement inserts via ajax on my web page. I have a .js with the following method: function meterCancion(idUsuario, idCancion) { $.ajax({ url: "insertarCancion.php", data: {idusuario:idUsuario, idcancion:idC...
asked by 20.05.2018 / 10:18
0
answers

Deadlocks without transactions in MySQL (MariaDB)

I'm having a very strange problem. I'm working on a project with PHP 7.1.17 and MariaDB 5.5.56. The tables use the InnoDB engine. The dynamic is as follows. A user will place an order with an X number of items. When they make this request, th...
asked by 22.05.2018 / 09:53
1
answer

I'm doing a table creation in SQL and at the time of execution, I get an error "Foreign Key constraint is incorrectly formed"

CREATE TABLE doctor_schedule ( doctor_id int(11) NOT NULL, attention_time_slot_id int(11) NOT NULL, available tinyint(1) NOT NULL DEFAULT '1', date date NOT NULL, PRIMARY KEY (doctor_id,attention_time_slot_id,date), FOREIGN KEY (doctor_id)...
asked by 19.05.2018 / 21:59
1
answer

How can I get the data and sectioned by month from a range of dates in MYsql?

I have a problem, I have a series of data that I must obtain but these I must section by month, for example I have 5 items that were sold in May, and 10 in the month of April, but this must be sectioned for months according to the date specified...
asked by 22.05.2018 / 04:31
0
answers

how to bring a record of a table if and only if a state is fulfilled in records of another table refererda to the id of the first?

What I seek to obtain is that if the subject has correlatives, that all are in state 1, approved, and if it has any not approved or is not in the record that does not bring the subject. I have three tables:    subject (id, description)   cor...
asked by 22.05.2018 / 04:26
1
answer

Because I get this error

   ERROR: duplicate key violates uniqueness restriction «matricula_pkey»   DETAIL: The key already exists (cod_est, cod_asig) = (1085, 1080). SQL   state: 23505 At the time of entering the data of a table this error appears, and my database...
asked by 20.05.2018 / 21:43
1
answer

Avg for null with left join

I have two tables (answers and answer_points) related by response_id. There are answers that do not have punctuation. I need to get all the answers with your average scores. I use this query: SELECT 'respuestas'.'id_respuesta', 'respuestas'.'t...
asked by 19.05.2018 / 19:19