Questions tagged as 'mysql'

Tagged questions
0
answers

Accentuation problem when doing mysql Dump in C # (latin1 and utf8)

I made a program in C # that does dump in mysql, it's very nice, it selects the database and dumps it alone, making an sql file on my computer, and I just need to move up the bank later where I want it. BUT I'm having a problem uploading the b...
asked by 16.10.2018 / 14:53
1
answer

Graph bars in red when value below stipulated average

Use this script to generate average chart of questions, such as how to make bars change color (red for example) when media is less than 8 (for example) <script type="text/javascript"> //carregando modulo visualization google.load(...
asked by 09.10.2018 / 06:37
0
answers

How to add multiple checkboxes to a table with php?

I've seen many questions answered similar to mine but so far nothing like it! It is as follows: I have the codes below and I do not know how to insert the checkbox into the table. Form Code <?php require "../config.php"; ?...
asked by 06.10.2018 / 02:43
0
answers

Add two ranges in a search

I need to create a query that looks up a call according to the time interval. Example: An employee opens a call on the system, but it will only be shown if it is open for 2 to 4 hours. I'm using this code, but I did not get results. SELE...
asked by 13.10.2018 / 22:59
1
answer

insert only one field with pdo

Hey guys, my problem is the following I'm using the PDO object of php to insert records in the database, the problem is when I try to insert only one field in a table example: $query = 'INSERT INTO alunos (nome) VALUES(:nome)'; $stmt= $...
asked by 04.10.2018 / 16:54
1
answer

VB.NET - How to sort a DataGridView by color

I have a DataGridView, where I do a document review. The DataGridView is populated by a file, I use OpenFileDialog to select the file and populate the DataGridView. Then I call a function where it is made a criticism by the CNPJ / CPF fie...
asked by 13.10.2018 / 22:17
1
answer

"No suitable driver found" in Java database connection

Well, I use eclipse and I'm trying to connect to a MySQL database with my project, my code, compared to other tutorials I found, is perfect, and that's it: package pack; import java.sql.*; import javax.swing.JOptionPane; public class Banco...
asked by 10.06.2014 / 01:49
1
answer

How to Put Two Like in the same condition Mysql and PHP

I'm in the struggle of a system in php and mysql system sales etc ... it is all working, however accurate at the time of sale, the person can search for either (idCode or Description). without having two tabs of search. wanted to put two LIKE to...
asked by 06.10.2018 / 19:38
1
answer

Group SQL results by date

So, I have a table that registers the login of the players, all the values in unix timestamp, and I wanted to know how I can know the day when there were more records, and adding the total, the day that there were more SEG_Online , AJ_Envadas an...
asked by 07.10.2018 / 20:47
1
answer

Do I need in a select to add and multiply columns with variables? Mysql

I need to add and multiply variables with columns and show the result with a select will look like the encoding below but because it needs strings, such as "user", and variables of the decimal type select will not work, the coding? Or if the onl...
asked by 07.10.2018 / 02:56