Questions tagged as 'mysql'

Tagged questions
2
answers

How to leave negative number according to condition - Mysql Trigger

I have a lc_movimento table with the fields: id , tipo and valor . I need the valor field to have the minus sign if is equal to tipo every time I enter and update. How can I do this?     
asked by 22.04.2017 / 06:41
1
answer

Identify 3 equal results in 3 different mysql BDs

I have an application in php that I created that clever several ips, in some sites I use, I would like to list the same ips in 3 sites in a single list! How do I do it? Biggest Problem: The tables in the databases have the same name, only the...
asked by 13.04.2017 / 19:10
2
answers

What is the best option for auxiliary tables?

Let's say that in a registration form I have several fields whose values are selectable and for each field the list of values is different from the others, the conventional would be to create a table for each field with the options and to displa...
asked by 19.04.2017 / 20:38
0
answers

MySQL - Value limit for mathematical operations

I have a question regarding the following situation: I have two values not stored in a table. Valor 1: 9223372036854775806 (Onde este é o valor máximo de um tipo de dado BIGINT) Valor 2: 99999999999999999999999999999999999999999999999999999...
asked by 19.04.2017 / 21:35
0
answers

How to RECORD android data in MySQL using webservices (AsyncTask)?

I have an android application that has several buttons on different screens, I should attach the clicked buttons and send to MySQL. li about webservices ( link ) and you need an AsyncTask to make that connection. banco_mysql.java...
asked by 25.04.2017 / 15:23
1
answer

How to import CSV file to MySQL? error 1295

How to import a CSV file into MySQL? I get error code 1295:    ERROR 1295: 1295: This command is not supported in the prepared   statement statement yet SQL Statement I sent the command: LOAD DATA LOCAL INFILE 'caminho_do_arquivo' INTO...
asked by 25.04.2017 / 19:31
0
answers

How to import large databases using Mysql in Lampp?

I can not import very large databases using Lampp's Mysql. Since the "mysql" command does not work on the Linux terminal when we are using Lampp instead of installing the Mysql server on the Operating System. The default way would be to use t...
asked by 06.04.2018 / 14:44
0
answers

Value sent to the database becomes zero after return from sql

Good afternoon guys from stack overflow. I have the following situation. I need to calculate how many days a status takes to change. For example, my partner's registration has the status of "Registration Started", then passes to "Waiting for...
asked by 10.04.2017 / 18:50
1
answer

How to assign the value of an Excel column in an SQL statement

I was able to connect to my MySQL Database via ODBC, and display the information I need via SQL command, but I would like the contents of a particular cell in my worksheet to be in that SQL query, I get this: Showonlythenameoftheclientaccord...
asked by 10.04.2017 / 17:03
2
answers

Range of dates in another date range

I have two columns of type DATETIME : one is called dataHoraSaida and another dataHoraRetorno in a table called trip. I would like to enter with two dates (a break) and know if there is any record already in that date range. Example: I would li...
asked by 10.04.2017 / 08:04