Questions tagged as 'mysql'

Tagged questions
1
answer

Filter system by category

I wanted to do a search system where I would search for data typed according to the selected category, but I do not know where to start. I'd like to add the filter option to category followed by a _<input type="text">_ for th...
asked by 13.07.2018 / 14:00
1
answer

Error connecting to MySQL with PHP and Docker

I'm running Docker and in the settings correctly step the credentials for the connection to MySQL (MariaDB), however it always returns the following error: http://localhost/error.php?err=Unable%20to%20connect%20to%20MySQL That is, 'Unable t...
asked by 13.07.2018 / 18:43
1
answer

How to transfer data from one table to another on different servers

I need to copy the records of a table that is in a MySQL linked server to SQL Server, ie transfer the records from one server to the other. Could someone give me a way to do this through a query ?     
asked by 17.07.2018 / 19:29
1
answer

Problems connecting Node Express in Mysql

I know that my project is correct that there is nothing wrong, I think the problem is my newly installed bank, how can I solve this problem? Unhandled rejection SequelizeConnectionError: Client does not support authentication protocol requeste...
asked by 30.07.2018 / 12:48
2
answers

Problem inserting data into a table containing foreign keys

Hello, everyone! Well ... My problem is this: I have a MySQL database that has 3 tables (Client, Event, Equipment). The event table has two foreign keys, the first one referencing the id of the Customer table (customer_id) and the second re...
asked by 30.07.2018 / 03:46
2
answers

Problem in the Controller JSP class

Hello, I need help, I have the problem on my system when I send an edit command. When I click the button to edit the table row I want, the screen turns white and does not show the options to edit. In the URL it shows that the fields are passing...
asked by 30.07.2018 / 18:40
1
answer

User connection location in MySQL or MariaDB

Is it recommended for me to change a user's connection location from the mysql.user table? For example, I create a user 'danilo'@'localhost' but then I want it to connect from any machine, is there another way I can do this with...
asked by 29.07.2018 / 17:43
1
answer

Connection being refused

Following this tutorial of Vedovelli on node with restify and mysql, implemented on the server with pm2. Only after a few days the connection started to be refused You're showing this message: errno: 'ECONNREFUSED', code: 'ECNNREFUSE...
asked by 03.08.2018 / 13:14
2
answers

Pass database txt to mysql

Hello, I have a txt file where I wanted to get your content to put in a database, but I'm having trouble following an example of how the file is: [03471] Nome=fulano Idade=20 Sexo=Masculino [05232] Nome=fulana Idade=17 Sexo=feminino I wante...
asked by 05.08.2018 / 12:00
1
answer

Help with ORDER BY clause by string

I have the following select command: select nome, case grau when 0 then 'QS' when 1 then 'CI' when 2 then 'CDC' when 3 then 'QM' end grau, case faixa when 0 then 'NÃO' when 1 then 'SIM' end faixa, mensalidade from socio order by grau, nome...
asked by 04.08.2018 / 05:55