Questions tagged as 'mysql'

Tagged questions
2
answers

Check if it already exists in the table before entering record

I need to include a record in a table, however before inclusion to avoid duplication it is necessary to do a check. As I have a ID column with property AUTO INCREMENT , I can not use INSERT IGNORE INTO . Table CREATE T...
asked by 08.12.2016 / 16:46
3
answers

Column 'column name' in where clause is ambiguous

I am trying to mount a left join where I want the results of a certain code. My SQL is: $resultado = mysql_query("SELECT CA.DAT_EHORA_EVENT, CA.TXT_NOMEX_EVENT, CA.MEM_DESCR_EVENT FROM tbl_CLIENTES C LEFT JOIN tbl_CLIENTES_AGENDA CA ON...
asked by 24.06.2015 / 21:31
6
answers

How to display php / mysql and AngularJs data?

I'm trying to do a test with PHP + MySQL + AngularJS and I was left with a question about how to handle the bank data with angular and send to screen, I have the following codes: con-bd.php <?php .... $conn = mysqli_connect($host, $us...
asked by 14.04.2015 / 14:13
3
answers

How to display all the results of a SELECT in PHP?

I've done this code all by myself, but I'm having trouble displaying all the results one below the other. <?php include 'conexao.php'; ?> <html> <head> <title>GMB Mineração e Comércio LTDA</title>...
asked by 02.01.2015 / 19:41
1
answer

Define relationship between tables in MySQL

Today I needed to create a table that had a similar purpose to Add the netflix queue where the movies that the user wants to see are saved (in the application the videos and photos will be stored), but soon I started to create table but I notice...
asked by 21.12.2014 / 11:17
2
answers

Get the number of dependents of an employee

I'm trying to do a search between 3 tables: Employee, Dependents, Employee_Dependent; I want to do the research where I show the number of dependents of each employee. I did the following: select dependente.*,funcionarios.* from fu...
asked by 02.05.2015 / 20:54
2
answers

Adding numbers from a MySQL column using PHP

I have several results in the MySQL database, I want to get the results and add all the numbers of a column in PHP. How do I?     
asked by 20.06.2015 / 19:35
3
answers

How to group by weeks using sql?

I have the following problem. I have several requests, and I want to group them for weeks. I have already seen several examples, but almost none helped me, I would like to know if there is a function that when placed in Group by the result of th...
asked by 07.03.2016 / 13:04
2
answers

check whether the day exists with if

I need to check if the day does not exist ... it does insert, if it does, it does update. I leave the practice example of what I need: if(ver se existe no banco){ .....if(){ ..........faz insert .....} }else{ .... faz updade }...
asked by 23.04.2018 / 11:47
3
answers

How to show a column, but if it has null show another sql

How to show a column, but if it has null show another sql such as a table named Task. | id | nome | nome resumido | +-----+----------+----------------+ | 1 | nome 1 | 1 | | 2 | nome 2 | 2 | | 3 | nome...
asked by 30.05.2018 / 16:36