Questions tagged as 'mysql'

0
answers

Reportviewer C # with parameters using MySQL

I'm starting to develop reports in Visual Studio 2013, using C # with MySQL. I've been able to do a report without parameters, but when I enter parameters in the query, it returns an error. The query that I put in dataset is as follows...
asked by 08.06.2016 / 16:04
1
answer

How to add a view dynamically to android as registered in mysql

I would like to know how to add a view (RelativeLayout) dynamically in my xml, as records are being found in my BD Mysql ... (My connection is made via the Volley lib)     
asked by 12.07.2016 / 02:23
0
answers

sql problems with disntinct

I have a table in my database with: horarioId horarioParagemId horarioLinhaId horarioHora I make INNER JOIN of the table rows: linhaId linhaNome I do INNER JOIN of the...
asked by 01.06.2016 / 13:43
0
answers

Automate insertion of records in the database [closed]

Hello, I'm developing a system in which I need a list with all the football teams in the world and their respective championships. I have the following structure in my database: tb_time (id, name, tb_campeonato_id) tb_campeonado (id, f...
asked by 23.07.2016 / 00:22
0
answers

User deletion system by the user [closed]

For some time now I've been trying to develop a system of account deletion on the part of the user, like what we witnessed on facebook and twitter where in the user settings, the same can opt can delete your account. But my temptations were frus...
asked by 22.07.2016 / 01:15
1
answer

"top" with MAX in mysql [closed]

I need to make an appointment that returns the top 3 salaries of public employees, by state. example that should return: fulano 850 RJ ciclano 800 RJ beltrano 700 RJ joao 1000 SP maria 900 SP pedro 200 SP I used M...
asked by 20.07.2016 / 13:23
0
answers

Groupby doing query gets too slow

Good afternoon people, I'm doing a query in the bank where everything happens well, however when I make use of "groupby" this query gets very slow, very slow even, example, just take the groupby line that the query returns me in less than 1 seco...
asked by 04.08.2016 / 22:01
1
answer

Show how the $ query got

People already saw this running somewhere but I can not remember where. and the following I want to give a echo in my code and to display as it was the insert in Mysql type $query1 = $conn->query("INSERT INTO dados1 VALUES (NULL, '"....
asked by 11.05.2016 / 05:28
0
answers

send hashtags to different columns in the mysql database

I would like to insert each hashtag word into a table column, I am using this example: <form name="formulario" method="post" enctype="multipart/form-data" action=""> <input name="hashtag'" type="text"/> <input type...
asked by 01.05.2016 / 09:57
0
answers

Access to different modules of a department

I'm having a question about building a small project. A user has access to a module from a department, so far so good. My question is if the user needs to access another module from the same department. The login is being done automatically, I c...
asked by 21.04.2016 / 04:28