Questions tagged as 'mysql'

Tagged questions
1
answer

How to make an ip counter using php and mySQL?

What about colleagues, I wanted to make a visit counter for a website (it is not advanced and it is only prototype) in which for every time a new user visits the page the counter increments by 1 and adds the ip of the user to the database, only...
asked by 18.08.2016 / 00:10
1
answer

generate excel in java and download it from jsp

What I'm grabbing is generating an Excel file in java from a query in sql the file is generated by clicking on a generate report button that I made in jsp and the idea is that when the Excel is generated I get the option of downloading that file...
asked by 09.02.2017 / 19:41
1
answer

Upload images to a mysql database from android

I use these two methods to try to insert an image to a database from an Android application, my problem is that the images are not inserted in the database, the webservices if it works because I use it to do tests in HTML, the one that does not...
asked by 27.10.2016 / 21:56
1
answer

How is this JSON created? [closed]

I want to create a JSON in php with mysql data only that I do not know how to create the table or the php code so that in the end the json looks like this, I hope your advice, thanks. [{ "nombre": "Ejemplo", "url": { "small": "imagen1.jpg"...
asked by 31.10.2016 / 20:40
2
answers

MySql nested query

I have to consult 4 tables of a database in mysql From 3 tables I need to take all the information with a where Of the fourth only take the last record that was entered in the column. I have the following code SELECT convenio.nit_Fuent...
asked by 12.08.2016 / 02:21
1
answer

how to get mysql data from one table and pass it to another by php

USE THE LAST PHP VERSION, Hello, how are you! I have a question! ... how do I get certain values from one table, to put it in another? ... example: I have a table products in this table I have ... "ID", "product", "description" and "value of the...
asked by 16.11.2017 / 05:37
1
answer

How to create this Mysql Database [closed]

I have no idea of MySQL and I have an image of what I need, I would like some help or some tutorial to follow. What I'm doing is calling from Xcode images located on a server, but this type of organization is what I need, more exactly...
asked by 02.02.2016 / 05:41
1
answer

Check other mysql records

I have the following data in a pivot table, estado| tipo libre | moto libre | camioneta libre | furgón en uso| moto libre | bicicleta en uso| camioneta So far I have only the basic query, I've tried anyway but I can not find the result, I'm...
asked by 04.09.2017 / 19:57
3
answers

How to get the purchases of each user with 1 query [closed]

my question is this: I have a table called "buyers" and another "purchases", I would like to list the purchases made by each buyer, that is to say that for each user that I have in the table "buyers" show me their respective purchases that I...
asked by 04.05.2017 / 17:08
2
answers

Relate 2 databases [closed]

I hope you can help me: I have 2 databases and I need to link a data from BD1 to BD2 . I am currently working with mysql workbench , will it be possible to do the relationship from one BD to another?     
asked by 06.05.2017 / 06:48