Questions tagged as 'mysql'

Tagged questions
2
answers

SQL Clear table with foreign key

Good day, I'm starting with SQL and during the development of the project my question arose. The issue is that I have a Detail table And a product table The problem arises when I want to delete a product, due to the reference t...
asked by 18.11.2018 / 01:15
1
answer

MySQL Inner Join with null Id columns

I have a table where there are several related ids and using inner join I get the data the problem is that some records do not keep an id and I put value Null and when ago the select with inner join does not show me the data with null value T...
asked by 09.10.2018 / 19:49
2
answers

I want to make a query using WHERE id_user = 53 [closed]

My code: SELECT numero_empleado, nombre, paterno, materno, fec_nac, estado, genero, edociv, hijos, id_contact FROM grl_usuarios INNER JOIN grl_usuarios_contacto ON grl_usuarios.id_usuario = grl_usuarios_contacto.id_usuario WHERE id_usuario...
asked by 17.03.2017 / 21:40
1
answer

problem when creating a table in mysql

I want to create a table in MySQL to make it work as the postfix validation: create table virtual ( address varchar(255) not null primary key unique, goto varchar(255) not null ); I want to make this simple table but I miss the f...
asked by 15.05.2017 / 04:39
2
answers

Get values with like mysql

I need to make a query that returns only one result, it is the following: among my records I have a field called name and I want the query to return the name that contains cumla with the following: If I say "hello" and in the registers I ha...
asked by 09.05.2017 / 19:34
2
answers

count data from one table with parameters from another

It may not be very clear in the question but I hope to make it clear by the example I am exposing. I have three tables from which I need to take an account table A |ciudad_cod |correlativo |fecha |estado_cod |detalle | |-------...
asked by 03.10.2018 / 14:32
1
answer

Synchronize sql

Good morning, I'm doing a project in which I need to synchronize a mysql database locahost, with a mysql mounted on a server, so that if the internet is going to continue working on the php web application. What would be the proper way to perfor...
asked by 01.10.2018 / 22:50
1
answer

Do not insert data in my database from PHP

Do not insert the data I leave you photo of the structure of my table and the code for which you can help me thanks. The code is as follows. <?php $con = mysqli_connect("localhost","root","","ufree") or die("conexion exito...
asked by 16.10.2018 / 07:42
2
answers

Help with database structure

I have a system for sending files and I have control in two tables, one to save file names and status of sending and processing, and another in which I keep the details as error messages when sending or success when processing. Now I have the...
asked by 15.09.2018 / 18:21
1
answer

mysql php registration form does not work correctly

I am working with a simple user registration form, they are already inserted, the code HTML <?php include '../includes/insert/insert_usuario.php'; ?> <form class="form-horizontal style-form" method="post"> <div clas...
asked by 28.09.2018 / 18:21