Questions tagged as 'mysql'

Tagged questions
2
answers

Select returning dates on object other than what is registered in MySQL database

I'm having a problem when I'm writing the contents of a table and storing it in a list so the date is one day less. I've done a lot of research on the web and I did not find a solution to the problem. Below the registration method: publi...
asked by 26.01.2018 / 22:00
2
answers

Inserting date into the American standard

I have a function to import data from a txt document, the layout I use to import this data is delimited by semicolons, I have the following columns (number, date_inclusion, sender, currency, value, situation, status). The problem is the time to...
asked by 26.01.2018 / 18:43
1
answer

Check if foreign key is being used

I have 2 tables: Officer Employee_id Name Address Profession Profession idProfession NameProfession Being that profession of the official table is a foreign key of ProfessionProfession table id. I wanted a...
asked by 26.01.2018 / 19:25
1
answer

Count how many databases there are

In the system that I am putting together, the dashboard of adm shows the total number of requests, which are created for each user and within them, the requests are recorded by the tables. Ex: User 75, has its db pedidos_75 and inside...
asked by 24.12.2017 / 01:23
1
answer

Product Order Sending

Well, I'm putting together a product ordering system, on the product selection page, we have the selection of them, where each one will have a input , however, indeterminate, how do I send all this inputs for base regardless of quan...
asked by 23.12.2017 / 05:36
1
answer

MySQL query in phpMyAdmin

I have already researched here and in other sites but the result of my query only returns false and I do not know why. Here is the query code <?php require_once('../_php/database_class.php'); $sql_query = "SELECT id,nome FROM '...
asked by 25.12.2017 / 21:54
2
answers

Securely deliver digital products in PHP

Personally, I'm developing a system where the customer can make the purchase and receive a download link for the product. The system has a register area in which you can upload the ZIP file to a folder inside the server. However, I would like to...
asked by 25.12.2017 / 13:33
1
answer

Do not select records that have the status = 'Off'

$query = "SELECT uf , count(*) as number FROM tab_clientes GROUP BY uf "; It is working fine however I have in the database a status field that classifies the person as Off (need to remain registered for other reports). I would like the rec...
asked by 19.01.2018 / 15:26
1
answer

How to use the "LOAD DATA INFILE" command?

I have a database and I have a table called "people" which contains "people_id" as an attribute and I want to test how to import information using this title command, I have already saved an excel file in the format ".csv" as follows: link : I...
asked by 12.12.2017 / 18:19
1
answer

Query PIVOT or SUM

My query is as follows: mysql> select product_id, presentation, price from Variant where product_id = "1604"; +------------+-------------------------+-------+ | product_id | presentation | price | +------------+-----------...
asked by 13.12.2017 / 14:36