Questions tagged as 'mysql'

Tagged questions
2
answers

problem when updating data from a java table after inserting, No operations allowed after connection closed.?

I have a class where I insert data in the db then I update the table but this error appears to me No operations allowed after connection closed. Here I leave the class connection and the class where I insert. //===============clase conexion===...
asked by 08.02.2017 / 22:59
1
answer

Syntax of this query [closed]

I have this query $CeanLibre = "SELECT min('3') + 1 as prox_ean_libre FROM (SELECT 0 AS '3' union all SELECT '3' FROM 'Direcciones&Codigos' WHERE '3' BETWEEN '".$CCodEan[2].$CCodEan[3].$CCodEan[4]."' AND '".$CCodEan[2].$CCodEan[3].$CCodE...
asked by 15.02.2017 / 23:11
1
answer

Delete registration 24hrs after created

As I do so that the records of a table in my MySql database are deleted every 24 hours automatically without using cronjobs. Pd: use php. Greetings.     
asked by 21.02.2017 / 22:40
2
answers

Constraint or trigger greater than 18 SQL

I need to check when adding a "voter" in the database if it is over 18 years old, I have tried it with a constraint and a check, but it does not support functions for the current date. What other options are there? ALTER TABLE votantes ADD CON...
asked by 30.01.2017 / 11:04
1
answer

Update fields of a Form using php and mysql

I have been writing a small script to update fields in mysql from a form with php. But I have a problem, when I try to update the field from php using mysqli, there are no changes in the database. The field I try to use as a parameter to upda...
asked by 31.01.2017 / 15:16
2
answers

How to subtract 2 columns derived from a MySQL function

I have 2 columns both generated by means of 2 different functions, as there is a lot of data the query takes 190 seconds. Example of what I do not want to do: I want to subtract the result of both columns but I do not want it to take anot...
asked by 28.03.2017 / 17:30
2
answers

Two values in the same column

Hello everyone, I have the following program: SELECT "resource"."name" "EMPLEAT", "attendance"."name" "DATA", "attendance"."action" "ACCIO", "hr_action_reason"."name" "MOTIU", "hr_timesheet_sheet_sheet"."date_to" "FULL" FROM "public"."hr_a...
asked by 29.03.2017 / 22:41
2
answers

Perform join on a table depending on the value of a field

I'm trying to make a query in Mysql and according to the column type of my table reports, make a JOIN to one table or another. Reports: In type the type of the item to which it is reported is stored, whi...
asked by 03.02.2017 / 23:24
4
answers

Installer when downloading MYSQL [closed]

download mysql from your website but the downloaded zip file only shows several folders with files, but not an installer, I ask for help for the installation process; try to copy it to c but it does not work either thanks     
asked by 01.02.2017 / 17:59
1
answer

Create a JSON from a MySQL query?

function connectDB(){ $conexion = mysqli_connect("servidor", "usuario", "contraseña", "base de datos"); if($conexion){ echo 'La conexión de la base de datos se ha hecho satisfactoriamente '; }else{ echo 'Ha sucedido un...
asked by 01.02.2017 / 20:38