Questions tagged as 'mysql'

Tagged questions
1
answer

I can not compare dates

Can anyone tell me what's happening in this code? The first querie works however it does not go into condition within the for. The second works and behaves normally, no problem with this. The case is that I have never seen this before my compari...
asked by 09.12.2018 / 02:03
0
answers

I'm Going Through an Error in Public Class

Technically I'm afraid there is nothing wrong, but even though I do not have much knowledge on the subject, I would like to ask for help here, when the toastr function is executed, it presents me with an error that would be something as variable...
asked by 07.12.2018 / 15:51
0
answers

Lock the timepicker button

<?php include('ligabd.php'); $id=$_GET["id"]; session_start(); if(isset($_SESSION["id_cliente"])){ }else{ header("location:login.php", true, 301 ); } $successMsg=''; $consulta = 'SELECT * FROM marcacoes'; $consulta2 = "...
asked by 29.11.2018 / 10:15
3
answers

How to convert a MySQL connection to MySQL? [duplicate]

I decided to listen to some users to make the conversion but I need your help because I have done a lot of research and nothing works. The first file is: <?php include_once("/pasta/connectserver.php"); $table = "rjpsync_tag, rjpsync_i...
asked by 17.09.2014 / 13:47
0
answers

How to unify the value of a column by making a group by of two different columns?

I'm trying to do a query that needs to bring the percent of the month of each row to this I made the query below: SELECT linhas, month(date) as 'data', round(('M3.0'*0.3),2) + round((Produtividade*0.2),2) + round((qualidade*0.3...
asked by 28.11.2018 / 18:47
0
answers

Error when registering data in the database :(

I'm trying to make a business registration system, but it does not work. I'm doing everything right to see. The bank is the same, the variables are right and the functions are as well. I do not know what's wrong. Can someone help me? (Note: I am...
asked by 28.11.2018 / 19:44
0
answers

Create MySQL trigger with input condition

Hello, I am doing a credit card system and I created a column with the types of card using ENUM ('bronze', 'silver', 'gold'), now I want to create a trigger so that when the user enters with the type, the trigger automatically drops the limit, an...
asked by 29.11.2018 / 16:07
1
answer

Problems to close communication with the Database

I have some applications consuming data from the database, but from time to time the applications are not able to close the connection, when I give a conexao.close(); Java says that it can not close because ResultSet this one up on...
asked by 05.12.2018 / 17:11
0
answers

Difficulty in doing Foreign key with two char fields in Mysql

I am not able to create a foreign key between two tables, whose type is CHAR : ALTER TABLE hardware ADD CONSTRAINT fk_INC_LOCALIDADE FOREIGN KEY ( INC_LOCALIDADE ) REFERENCES localidade (INC); The error is:    ALTER TABLE hardware...
asked by 11.12.2018 / 12:05
0
answers

Problem connecting a database

I was able to solve some of the problem. The error that I put below, in the initial part, was giving of my service of the mysql to be stopped. I do not know how, but somehow, after I started by WAMP, it stopped. After I started again,...
asked by 02.12.2018 / 03:46