Questions tagged as 'mysql'

Tagged questions
1
answer

Problem inserting data with methods. Java / Mysql

I get the following error when I try to add a new data into a table in my Database. I have a class whose name is Banco de Dados , another whose name is ShowMenu and another whose name is Principal . And I get the following...
asked by 16.09.2017 / 21:53
0
answers

Exporting informix data

I'm developing an application based on data from an ERP. This ERP uses the INFORMIX database whose file export pattern is DELETED BY PIPES AND WITHOUT TEXT QUALIFICATION. I need to import the data from Informix to MySQL, but must have all fie...
asked by 14.09.2017 / 16:03
0
answers

Doubt: Web Sockets and how to use

I was seeing this question link So I did not read the answer on nodeJS and I researched, but I did not understand much. How to apply this technology (nodeJS)? I am developing a site in php / jquery and in it I have administrative panel wit...
asked by 07.04.2017 / 06:07
0
answers

Store TIME field time greater than 838: 59: 59 in MySql

Good afternoon, Can anyone help me with this? I need to store time values greater than 838: 59: 59 in TIME-type field in MySql. Is there an alternative for TIME type to store value greater than 838: 59: 59? Thank you in advance for helping...
asked by 16.03.2017 / 18:37
1
answer

Publish something on my site and automatically post to facebook

Good afternoon, I have a question that I am pondering to understand. I saw in a system something very interesting that is when the person publishes some content on her site, there is a button that you select to also publish on facebook. It's lik...
asked by 22.03.2017 / 17:19
1
answer

Open a Modal with the result of MySql

And the beauty galley? I'm studying Dev Web and I'm creating a pro-boot system with customer records and reports. Let's doubt it. I have a report page and there I have an input type="date" inside a form that will do the fetching from a date i...
asked by 01.08.2017 / 23:48
0
answers

Selet of all records of an IN clause in Mysql

I would like your help because I made a simple query that would need to return all the records specified in the IN clause. In this clause IN (TF.CodTreina IN) is coming from a select. The problem is that it is returning some employees who have s...
asked by 15.03.2017 / 14:58
0
answers

Engine with less RAM than InnoDB / XtraDB in MariaDB?

InnoDB allows you to make multiple INSERT and also UPDATE without creating LOCKING , while in MyISAM it is not possible to make multiple INSERTs at the same time and to make matters worse MyISAM does not support TRANSACTIO...
asked by 13.01.2017 / 22:31
1
answer

PHP find addresses up to 5km away [duplicate]

Hello. I'm setting up a system to find the nearest service provider on the zip. For this I used the script below to convert zip into coordinate. $cep = "01238010"; $geocode = file_get_contents('http://maps.google.com/maps/api/geocode/j...
asked by 25.05.2017 / 15:43
1
answer

Search in different tables knowing which came the result

I am trying to search for a term in 4 different tables in MySQL, using like , but I need to retrieve the id of each one and identify which table came to do the listing and direct with link. This is a search system where the result...
asked by 04.11.2016 / 16:22