Questions tagged as 'mysql'

Tagged questions
1
answer

Group Mysql result in PHP

I have two tables in my database, the cad_usuario and the cad_automovel . The user registered in the first table can have several vehicles registered in the second table. SELECT aut.usuario_id, aut.marca, aut.modelo, aut.ano, usr....
asked by 11.04.2017 / 00:57
0
answers

Add days in mysql using column value

I have two tables: person (with email and name) and person_line_online (with a course start date and another with valid days). Well, I want to filter people with the expired date, so I did the following SQL: SELECT now() as agora, p.nom...
asked by 07.03.2018 / 15:42
0
answers

Add MySQL Subquery

I have the following query to get% Note% as_% as I can in the same query get the% Note% with% I'm trying so, but I get the same value for NotePT and NoteMT, below code and output image: select u.firstname as Aluno, u.lastname as escola, userid...
asked by 13.03.2018 / 15:30
0
answers

How to ignore a "Duplicate entry error" in MYSQL and insert the remainder not duplicate

How to ignore a exception and insert the rest of the fields when I get this error in MYSQL using mysql .NET connector? My try catch is as follows: try { conexao.Open(); MySqlDataReader reader = comm.ExecuteRea...
asked by 12.03.2018 / 16:50
3
answers

Split the database to multiple clients or create one for each? [closed]

I'm developing an app for enterprise management. It will consume data from a MySQL database through a Web Server. My question is: What strategy do you follow to store each customer's data? Save all data from all clients in a single datab...
asked by 24.01.2017 / 13:36
1
answer

How do I configure a MySQL database that is on my machine to be accessed in moodle hosted on the web?

I hired hosting services from Uol Host, however I can not change the database provided by them. I would like to know how do I connect a database from my machine to moodle that is installed on the host. In the moodle installation this appears....
asked by 09.03.2018 / 22:09
0
answers

Select location from the status

I have the following (fictitious) structure Status table: id | name | status Location table: id | title | estado_id On my front end I have a navbar that will list the states and in each state the locations. I'm using...
asked by 10.03.2018 / 02:07
1
answer

PHP and Mysql Division without rest in PHP division of tasks

Everyone needs to assign tasks to a variable number of participants. EX: Through a select I get 49 tasks to be executed and I have to distribute to 4 employees. In other words, the division would be 1st employee would have 12 tasks the 2nd em...
asked by 01.03.2018 / 17:56
0
answers

Doubt on an error node.js

I'm starting to do projects with node.js, but I do not understand why my code is not generating the view, and I'm not even storing the data in sql. function Funcionarios (connection) { this._connection = connection; } Funcionarios.prototype.g...
asked by 01.03.2018 / 20:41
1
answer

MySQL stopped working in XAMPP [pending]

17:48:20 [mysql] Error: MySQL shutdown unexpectedly. 17:48:20 [mysql] This may be due to a blocked port, missing dependencies, 17:48:20 [mysql] improper privileges, a crash, or a shutdown by another method. 17:48:20 [mysql] Press th...
asked by 06.03.2018 / 21:52