Questions tagged as 'mysql'

Tagged questions
0
answers

How can I stop the process and restart the same process if in case the power goes off, web service or the database goes down?

I explain I have an Executable (query) made in c # and mysql what it does is consume 2 services of shipment and another one of consultation of state (details) of what was sent but behind that I register all the operations sent and the queries of...
asked by 24.12.2018 / 06:38
1
answer

Search Record by php and mysql date

I have a bd of a newspaper which has a fairly large flow of articles which I want to filter by a specific date. the input is configured as date that same value I save it in a variable to make the query but it does not bring me the date that I sp...
asked by 23.12.2018 / 00:39
1
answer

Problem with a record working with 2 tables, in mysql

I have a problem in this query, it consists of 3 sheets, one where I enter an email from a table to find a specific student, another where I change the course and another that modifies the course of the student table. The problem is that I ha...
asked by 03.01.2019 / 04:41
0
answers

Query works in mysql but datatables does not recognize it

I have the following query: $consulta = " select t.id, t.nombre_mes, t.valor, t.ano, t.procedimiento, t.folio, t.fecha_envio, t.etapa from( SELECT meses.id, meses.nombre_mes, hijos.valor AS valor, hijos.opcion AS procedimiento, pedidos.correl...
asked by 03.01.2019 / 23:05
0
answers

Phone data handling in MySQL and PHP

I need to save the phones and then validate it by SMS and serve as a method of recovering your account. According to my approach, I decided to use 3 fields in MySQL phone BIGINT(20) // Guardar el # como tal code_phone VARCHAR(8) // Guardar...
asked by 03.01.2019 / 21:02
0
answers

how to filter data with json and php

I need someone to help me, I have a structure that receives data from a mysql database, I would like to show the data in the app but filtering the data that matches a variable I defined when loading the app, I have the following structure : fu...
asked by 20.12.2018 / 13:36
2
answers

How to create a JSON file from PHP

I need to build a JSON file from PHP with a specific sequence, but I do not know how to build it. The sequence is as follows: [{"jornada":"A","colegios":["Salle","Belemitas"]}, {"jornada":"B","colegios":["Nazaret","Comfama","jega"]}]...
asked by 20.12.2018 / 03:59
0
answers

Error calling the attribute "name" in BD and Java web

In web java when I call the procedure list of the bd, I get the name "Juan Luis" (as it was created in the bd) but when I select edit I get only "Juan" drop procedure if exists actu_alumno; delimiter $$ create procedure actu_alumno(in nombre...
asked by 20.12.2018 / 17:43
0
answers

Help range field hour_date Mysql, AJAX

Good morning maybe someone can help me, I have the following problem: I'm running this query that allows me to get the value of the accuracy of the inventory, So far everything works well the query traps the data, but what I want is that by chan...
asked by 17.12.2018 / 14:05
1
answer

Query that inherits twice from a table

Select v.id_user, uv.nombre_nacion as PaisEnvia, up.nombre_nacion as PaisRecibe From solicituds as v INNER JOIN pais as uv on v.id_pais_envia = uv.id_nacion INNER JOIN pais as up on v.id_pais_recibe =up.id_nacion; It would be...
asked by 17.12.2018 / 14:27