Questions tagged as 'mysql'

Tagged questions
2
answers

Calculate total orders and total orders for the current month with MySQL

I have this order table, I need to count the total requests of each user and the total requests of each user in the current month. | id | id_user | name | data_criacao | | 1 | 10 |Pedro | 2018-05-01 | | 2 | 10 |Pedro | 2018-05-03...
asked by 12.07.2018 / 15:40
0
answers

Remove quotation marks when uploading csv

I made the following statement to upload a csv to the database: public void importarBaseBruta(File arquivo) { try { this.limparBaseBruta(); this.con.conectar(); this.stm = this.con.getStm(); System.out.print...
asked by 10.07.2018 / 20:41
1
answer

MMN Rank Query

Hello, I have the following problem: I made a micro-social network for managers, where initially the registration is done only by invitation, thus "measuring" the influence of each one. My problem is in the ranking that currently counts the invi...
asked by 10.07.2018 / 19:40
0
answers

Errors when trying to update mysql script for mysqli [duplicate]

<?php Class mysql { public $query; public $data; public $result; public $rows; public $page = 0; public $perpage = 10; public $current = 1; public $url; public $link = ''; public $total = ''; pu...
asked by 10.07.2018 / 19:37
1
answer

date + 2 working days

I have a date ( fatura.baixaboleto , "%d%m%y" ) and in this query I want to add another 2 working days, eg: Day 16/07/18 + 2 working days = 18/07/18 (Monday through Wednesday) thursday to Monday) Day 20/07/18 + 2 worki...
asked by 20.07.2018 / 05:13
0
answers

Save a JSON in the database or create an intermediate table?

Good evening! I'm in a small Dilemma, I'm building an application for event control, in this application I have an event that can have multiple guests in the Front end I'm thinking of using a component equal to this: Anyway,whatwouldbethebes...
asked by 09.07.2018 / 03:20
1
answer

Consolidate all columns in only one row MYSQL

I'm trying to make a query that aggregates all the results in a single line, ie, does not bring duplicate results. I've already used distinct and group by but none of the two returned me what I need. My query is as follows:...
asked by 18.07.2018 / 01:27
3
answers

Difficulty installing SQL query

Personal oops. I'm having difficulty setting up a query in MySQL. It is as follows, I have a table with the following structure The time_array and time_azul columns store user IDs of the system. I need to look in the columns time_...
asked by 07.07.2018 / 01:08
0
answers

Automate table fill

I have a table with the following structure: id - email - activation_key I need to populate the activation_key column with a random key (I already have the script to create this key), only it's type, 200 lines, how can I go populating each on...
asked by 20.07.2018 / 20:51
1
answer

php - fetch_assoc () errors

Good, I created this code to make FETCH of all the data through a SEARCH. If I write for example "Olaaaaa", it does not give the error and shows the search, but if I give space and say for example "Olaaa Souuuuu", it shows this error. Fat...
asked by 20.07.2018 / 22:30