Questions tagged as 'mysql'

Tagged questions
1
answer

Connect Ruby on Rails to MySQL [closed]

I was trying with the ruby on rails framework, but I have had problems with the gem devise. I made it work but only locally with SQLite. I would like to connect remotely to a database in MySQL, for the creation of the login and a dating syste...
asked by 23.06.2017 / 05:58
1
answer

Optimize a UPDATECOMMAND of mysql under vb.net!

Hello, how are you? I am working on a program under vb.net, under mysql, and when doing an extensive data update, it becomes very slow, around 2 - 15 minutes approximately. I clarify that this is not a DELETE COMMAND or INSERT COMMAND, that is,...
asked by 30.08.2017 / 21:00
1
answer

Duplicate records

I have a Ticket system, the code works 90% considering the requirements of the system, the problem is that sometimes when I make a record, it is duplicated. I have tried several things without success, it is clear that I can not have unique f...
asked by 31.08.2017 / 00:59
1
answer

How can I avoid XSS and CRFS attacks on my php page with angularjs? [closed]

On my website I want to avoid these types of attacks, I need your help because I do not know how to mitigate html injections or other ways to change the html to make requests by dea. It should be noted that the web service was created with ph...
asked by 28.06.2017 / 01:01
2
answers

Problems connecting java with mysql local network

I have a server Mysql installed and started in Raspberry pi with local address 192.xxx.0.1xx connected to the network and from another computer I try to establish a connection with a Java program with this code: public cla...
asked by 27.06.2017 / 16:56
1
answer

Fill arrayList from Database in Java

I am trying to make a didactic software, to fill a Java arrayList with the data of a database table. I have managed to fill it so it seems, because the system.out.println shows me three objects that are the three objects that are in the d...
asked by 12.06.2017 / 18:19
1
answer

Perform a query using a select in HTML

Very good, I'm trying to make a query using the selected option in HTML select, which I named "filter", I create the dynamic options and with a switch I get the selected. The case is that from there I'm stuck do not know where to put the code th...
asked by 27.03.2018 / 17:48
1
answer

Problems with JOIN MySql

Dear friends, I really have a serious problem, I have several tables that store certain information of users such as their facebook, twitter, instagram, image, email, etc ... I will show the SQL and explain the problem: SELECT IF...
asked by 25.03.2018 / 20:27
1
answer

Search engine that queries two different tables laravel 5.4

Description The search engine currently makes a query to the news table where it finds the data by ( news_program, noticiero_turno, news_date ), the question is How can you make in that same query extract data from the another table that is ca...
asked by 25.03.2018 / 01:17
1
answer

how do I make a multi delete

I have the following query DELETE Proyectos, Observaciones, Fechas_revisiones, Residentes, Revisores_anteproyectos, Validar_anteproyectos, Valid...
asked by 18.06.2017 / 15:20