Questions tagged as 'mysql'

Tagged questions
1
answer

How to check the occurrence of a string in a line and get x characters to its left and y to the right?

I have a problem with a MySQL query and I'm looking for help. Suppose I have many rows in the PROCESS column and one of them looks like this: IBAMAPROCUR: DF00025372 ADRIANA MAIA VENTURINIAPDO: JOSE DOS I want to check if there are 25372 ch...
asked by 22.05.2015 / 15:11
1
answer

Bug on PDO? Table Disappears After INSERT Command, Like Debug?

Introduction I'm creating a library with some "magic methods" on the PDO , already I did this with MySQLi and it worked beautifully. The intention is to use it in a Framework that I am building , finally it comes from soap. Problem...
asked by 23.09.2015 / 22:52
1
answer

What is the difference between long polling and normal ajax?

I'm trying to understand more about long polling to "manipulate" a site in real time, I've seen some videos and I'm thinking so far: Let's say I have an old date that is in the sql and I echo it. How will long polling know if the old dat...
asked by 15.05.2015 / 07:48
1
answer

C # MySQL transaction in different classes and methods

How do I interact with a transaction between two methods that are in different classes? In my method where I open the transaction it is as follows: public string InserirFuncionarioM(FuncionariosDTO Funcionario) { MySqlTransacti...
asked by 19.04.2015 / 14:54
1
answer

Adding values to existing tables with RMySQL

I had previously asked a question about Mysql database in using the RODBC library and due to an error in the types, I saw in one of the answers told me about the RMySQL library and I decided to try it. But I'm not able to add data.frame table...
asked by 19.04.2015 / 15:55
1
answer

Mysql query intervals

I need to mount a select, where I need to display the results outside of a range of code. For example: I have code 2 as a start and code 6 as an end, how could I not display codes 3, 4 and 5 and only display code 1 and from 5 onwards? Only with...
asked by 01.12.2015 / 14:40
2
answers

Select dates

I need to make a select that brings me instances that the start date of a license is less than 3 years from an employee's date of admission Below is an excerpt from my code. SELECT * FROM jmh_licenca l INNER JOIN jmh_servidor s...
asked by 02.12.2015 / 13:35
1
answer

Recover Mysql data and save to a vector

Reformulating the question .. I have a MySQL database, inside it contains a table named map, inside the map table I have the fields idmapa (auto_increment), lat (which stores the latitude of a map position), lng ( which stores the length of a ma...
asked by 25.11.2015 / 02:02
1
answer

Problem concatenating query in PDO

Good evening, I have a search that contains multiple choices for checkbox and Selects and I'm trying to concatenate the query to search according to the user's choice but give me error I do not know what I can be doing wr...
asked by 25.03.2015 / 23:22
2
answers

How to create an executable in java + MySQL database?

I created a java desktop application that connects to a MySQL database, how can I generate this application to run on any machine along with my database? Thanks!     
asked by 08.04.2015 / 20:28