Questions tagged as 'mysql'

Tagged questions
1
answer

Create a three-table Viewer

How to create a mysql view with 3 tables the following structure being cliente |id_cliente |nome_cliente produto |id_produto |nome_produto |valor_produto pedido |id_pedido |id_produto |id_cliente I would like to create...
asked by 07.06.2016 / 21:15
1
answer

Mysql with android

I looked in various forums on how to integrate mysql with android, a very simple thing, like to list data from a saved table on an external mysql server. Using normal java I was able to do it using jdbc. I tried using the same with android bu...
asked by 01.06.2016 / 22:33
2
answers

How Select SUM works (IF ('' , '', ''))

I'm just having a question about how select mysql works. Select SUM(IF('','','')) I'm using it but I do not know exactly how it works     
asked by 02.06.2016 / 15:19
1
answer

how to do an update on the bank using checkbox

I would like to know how I can do an update with checkbox , with the system I developed I can get normal all checkbox that will be changed but I can not get the id from them how can I do this? below is the part of html...
asked by 23.10.2016 / 23:34
1
answer

If inside if inside while while inside (slow)

I have a question about loop while: I have the following query : $sql = "SELECT id,cod,nome,cnpj,insc_estadual,tributacao FROM empresas_base WHERE tributacao = '$filtro_regime_nome' AND responsavel = '$user' GROUP BY id ORDER BY id";...
asked by 13.04.2017 / 18:18
1
answer

MySQL - installation problems with linux

Problems with installing MySQL on a linux.  Every time I put the command in the terminal: sudo apt-get install mysql-server I get this message back: Reading package lists... Done Building dependency tree Reading state information.....
asked by 23.04.2017 / 18:17
3
answers

Get a single record for equal columns

I have an example table: produto | supermercado ---------------------------- 1 | 1 4 | 2 6 | 1 5 | 1 8 | 2 7 | 3 I want to get all the exis...
asked by 11.05.2016 / 19:16
3
answers

Correct SQL database data [closed]

I want to correct a table field, as I have values like this: 123456789 and want to change to 1234567.89     
asked by 04.05.2016 / 15:49
1
answer

BETWEEN with field type DATETIME

Using BETWEEN with DATETIME database fields it does not return any records with date equal to datei and dataf. Using DATE_FORMAT to search by date by ignoring TIME Considering the search $ dtai = '01 / 06/2016 'and $ dtaf = '06 / 05/2016', re...
asked by 06.05.2016 / 23:52
2
answers

Error inserting data into table

Opening Connection: private static final String USUARIO = "root"; private static final String SENHA = "123456"; private static final String URL = "jdbc:mysql://127.0.0.1:3306/escolabd"; private static final String DRIVER = "com.mysql.jdbc.Driv...
asked by 24.05.2016 / 18:35