Questions tagged as 'mysql'

Tagged questions
2
answers

SQL - Count number of records between rows

I need help with creating a query. I have a table that ranks people by week. PessoaId | Semana | Grupo ---------------------------- 1 | 1 | 1 1 | 2 | 1 1 | 3 | 1 1 | 4 | 1...
asked by 25.01.2018 / 23:47
0
answers

Unhandled Exception: System.TypeInitializationException

MySqlConnection sqlconn; string connsqlstring = "server=localhost;user id=sql10217362;persistsecurityinfo=True;database=sql10217362 --debug"; sqlconn = new MySqlConnection(connsqlstring); sqlconn.Open();...
asked by 25.01.2018 / 16:44
0
answers

Individual Report of each record

Good morning! I have a table in the database filled with some records, then I show those records in an html table, so that's fine, except that I need to insert a download link in every record in the html table, that link has to be dynamic, ie ev...
asked by 25.01.2018 / 16:26
1
answer

This web container has not yet started

My Java Web application, using Hibernate, published on a Glassfish server and using MySql database published in Hostgator is constantly causing the following error: [2018-01-31T11:51:15.852-0200] [glassfish 4.0] [WARNING] [] [com.mchange.v2.re...
asked by 31.01.2018 / 16:14
0
answers

Simultaneous connections oracle and mysql

What is the limit of MYSQL and Oracle concurrent connections today? What are the limitations of the mysql community version?     
asked by 31.01.2018 / 13:32
1
answer

Connection error in mariadb

Today I installed lamp on my manjaro and everything was working normally, until I went to test php with mysql and typed the code: $conexao = mysqli_connect('localhost','root','','data'); I realize that after that all the rest...
asked by 27.01.2018 / 09:21
1
answer

How to check variable has values?

I have a function that performs a select in the database: function selectIdProdutos($id){ $banco = abrirBanco(); $sql = " SELECT * FROM produtos WHERE id = ".$id; $resultado = $banco->query($sql); $banco->close(); $pr...
asked by 25.01.2018 / 12:59
0
answers

Error importing bank records to chart

In my old system I had a hightcharts chart that imports the records values from my database table, however, when using the same model on another system, the following error began to appear:    Notice: Undefined index: SCJan in C: \ Program Fi...
asked by 27.01.2018 / 12:44
0
answers

Register using PDO, error 22527?

I have this PHP code below that will be executed after submitting the form to register in the database. If you pass the validation, a new user will be created and done HASH and then the insertion in the database!      if (input::exists()) {...
asked by 25.01.2018 / 14:14
1
answer

Enter a value in the SQL table for each selected checkbox

I have a form with a checkbox group (same as below) and I would like that when I select the values, insert a row in the SQL table for each selected checkbox: <form> <input type="hidden" id="id_pedido" value="123"> <div>...
asked by 24.01.2018 / 11:11