Questions tagged as 'mysql'

Tagged questions
0
answers

Upload image to servicor with web service made in php [closed]

I'm making an application for android, and in it I want the user that registers can upload images, when I create a web application in php, the upload of the images I do by placing the image in a folder and the name of the image in the database b...
asked by 16.08.2017 / 21:31
1
answer

help java.lang.String can not be cast to java.util.Date I do report with dates

I want to make a report with Java and iReport where the user provides the start and end dates of the output of products in a report dates provided from widgets DateTimes and pass them to a variable String and then that variable parses for that I...
asked by 17.08.2017 / 00:13
0
answers

Foreign key empty (no data) PHP

I have a query regarding database and forms in PHP: I have the following user table CREATE TABLE IF NOT EXISTS 'login'.'usuarios' ( 'nombres' VARCHAR(30) NULL, 'apellidos' VARCHAR(30) NULL, 'dni' VARCHAR(13) NOT NULL, 'telefono' VARCH...
asked by 19.07.2017 / 03:57
1
answer

Return Boolean in SELECT

I have an entity called "Period" with a boolean attribute called "processing". I want to make a function for a repository that returns "true" if there is at least one record in the DB with the attribute "processing in true", however I'm not sure...
asked by 12.06.2017 / 18:40
0
answers

Connect Mysql Workbench to mysql on ubuntu server 16.04 virtual machine

Good afternoon, I have a system on ubuntu server 16.04.02 LTS with a Mysql database, all VMware fusion virtual machine and NAT connection in which I can see the application and access through phpmyadmin. But I want to see the database wi...
asked by 09.06.2017 / 23:03
1
answer

like I think page in an entry in wordpress

I would like to make a page in the wordpress entry search the web trying with < - nextpage - > in the editor and adding the function in the sinple.php file but it does not work for me They know some plugin in which you can only page...
asked by 04.06.2017 / 20:22
2
answers

Mysql query that shows matches and then the rest of the rows

I have a MySql database in which I keep activities with the following structure. id (int) | nombre(varchar) | descripcion(text) | mes(tinyint) What I'm trying to get is to show in php a list of them from the current month. Until...
asked by 05.06.2017 / 01:49
1
answer

Group by similar strings in MySQL

I am normalizing a database in MySQL and I have to convert a field that was entered manually to an FK field that is related to a new table that should have that manual income but without repeating it. The problem I have is that, being manual...
asked by 08.06.2017 / 00:48
1
answer

Error generating users in SQL file

I receive the following error:    ERROR 1396 (HY000) at line 11: Operation DROP USER failed for 'garen' @ 'localhost' When I run this code: -- DATABASE -- Creamos la base de datos DROP DATABASE IF EXISTS janitza511; CREATE DATABASE jan...
asked by 01.06.2017 / 10:15
1
answer

mySQL Subtract table result of JOINS to an original table

It turns out that after using a SELECT * FROM + several JOINS such that ... SELECT * FROM EMBARCACION RIGHT JOIN (SELECT * FROM EMBARCACION LEFT JOIN POSICION ON EMBARCACION.matricula=POSICION.matricula JOIN VENTA ON VENTA.matricula=EMBAR...
asked by 23.05.2017 / 13:54