Questions tagged as 'mysql'

Tagged questions
2
answers

Select first Null record in query LEFT JOIN

I am doing a system to carry out courses. I have 2 tables, one of name "Index" and another "Completed", in "Index", I keep the index of the course (ie the curriculum, units, exams, etc) and "Completed" the id of the user and the id...
asked by 02.05.2017 / 17:50
1
answer

MySQL Equivalent Configuration in Linux (Ubuntu)

Good afternoon. Sorry for my ignorance in MySQL. In Windows there are 3 types of configurations (See Image): Development, Server and Dedicated. How can I reflect those same configurations in a linux environment, for my ubuntu case.    ...
asked by 19.07.2018 / 16:53
1
answer

Concatenate Wheres in a Stored Procedures

Could you help me create a query through a Stored Procedure? to select Sales with: pClient (only when it is not null) pProduct (only when it is not null) pSeller (only when it is not null) List of Sales (p From, PHase, Customer,...
asked by 18.04.2018 / 17:56
1
answer

What are the conditions in mysql

I have a question, I do not remember the conditions in Mysql, I'm doing consultations with Inner join and reserved words. SELECT (Nombre_empresa) FROM (empresa) INNER JOIN (lucha) ON (id_empresa=id_lucha) WHERE condiciones_para_cualquier_camp...
asked by 10.07.2018 / 00:08
2
answers

Delete and / or update data massively [closed]

How can I remove data massively from my database (since I need to delete more than 10 thousand data that are stored, and then delete the data one by one would not be appropriate) Basic Consultation $deletePersona = "DELETE FROM persona...
asked by 07.11.2017 / 16:09
1
answer

how to fill the field of a form from a Mysql query?

<?php include("conexion.php"); $idUsu=$_POST["id"]; $sql="SELECT Nombre FROM usuario where idUsuario=$idUsu"; $result=mysqli_query($conexion,$sql); ?> and here the form where I want to show the name <f...
asked by 05.10.2018 / 23:30
2
answers

Execution of a client program in the background every certain period of time

I need to make a client program in java so that I send "X" information to a database, every few seconds (1-3 seconds) and it is running second time since the system starts up until it shuts down. I do not know how I can make several lines of cod...
asked by 25.09.2018 / 12:59
2
answers

How can you get data from a table 1 that is not in table2?

As I can do to obtain the data from a table1 that is not in another table2 and that is different from an id (idmodselection) that is in table2, I am working on 2 tables that are related, which are: Tabla 1: requisitos idrequisito int (Clave pr...
asked by 18.09.2018 / 16:12
1
answer

error when making a query so that I do not repeat the data

Hello, good morning, I'm doing a system which in a select appears some cedulas and filled some questions and with a button I send the data but I do not want the data to be repeated many times when I hit the send button and I got this error < a h...
asked by 01.10.2018 / 14:30
1
answer

because my code duplicates mysql records?

I have a problem when I make this query in mysql select count(carne) TOTAL_ESTUDIANTES, profesor.nombre PROFESOR, cursos.asignatura CURSO from profesor, cursos, matricula; I only have 4 students but when I do the consultation, everything is...
asked by 03.05.2018 / 20:33