Questions tagged as 'mysql'

Tagged questions
0
answers

SELECT in MYSQL grouped by month but showing all

I have the following table in MYSQL: cavalo - 2016-01-15 cachorro - 2016-01-16 gato - 2016-02-23 coelho - 2016-02-24 ovelha - 2016-03-21 tatu - 2016-03-22 I wanted to give a SELECT and show it this way: JANEIRO - 2016: cavalo cachorro FE...
asked by 29.01.2016 / 15:51
1
answer

What is this code possibly doing?

index.xhtml : ui:repeat value="#{produtoService.listaProdutos}" var="prod" Note: I know that the tags are missing. But what does this code doing ('' assuming the tags are closed properly)? "     
asked by 25.04.2016 / 04:22
1
answer

Receiving Database Search with SQL Reader

Facebook is a class where I store user information, but I do not know how to use ExecuteReader to get the information. Can anyone help me with this? (I'm new to C # language) public Usuario buscarUsuario(int id){ Usuario usuario...
asked by 10.03.2016 / 10:55
0
answers

How to make a query in mysql using ignore index with group_concat?

I have a query that does inner join of heavy tables with the filter where coluna = 'valor da coluna' , it runs until reasonable but it would need to run this query without the filter. Only the query loaded until it lost the connecti...
asked by 22.03.2016 / 19:43
1
answer

Problems in PHP [closed]

Hi everyone! I'm new to PHP and MySQL Database. For several days I've been breaking my head with a code and I can not find the error at all. : I have an index.php page, with a form calling the file "cep.php". In this file, I need the comma...
asked by 22.03.2016 / 23:44
1
answer

How to perform a CRUD in C # with MySQL and ADO [closed]

I need to do the relationship between tables 1: N and N: N. Table produto : public int id {get; set;} public string produto {get; set;} public list<tamanhos> tamanhos {get; set;} Table tamanhos : public int produto_id...
asked by 23.03.2016 / 04:39
1
answer

MYSQL - Error code 1644

I have two databases, when a trigger is triggered it generates an insert in another database, it is a device to generate log: The schema is this: local name database has a table called tab_manifest and an insert is made in it and the trigger...
asked by 28.01.2016 / 11:28
2
answers

How to write data from two columns of a table using select?

Hello, I'm using a Select to get data from the Tags table, and save the code and the brand name when I register the product, but I'm not able to save the data of the two simultaneously, ie I can only write the code or the brand name, if you chang...
asked by 07.04.2016 / 00:45
1
answer

Direct image upload in MySQL DB using C #

I'm creating a WEB application using C # and a MySQL DB. I need to upload an image to the Bank and then retrieve it. I am a beginner in this world, but what I have so far: IhaveafupCPFfieldthatreceivestheimage,thenIexecutetheInsertbelow:s...
asked by 08.04.2016 / 15:55
0
answers

Insert in mysql database with java

I'm trying to give 6 insert in 6 tables, but I did not succeed that way, can anyone help me with a better idea? private void salvarActionPerformed(java.awt.event.ActionEvent evt) { DadosFunc...
asked by 19.01.2016 / 20:10