Questions tagged as 'mysql'

Tagged questions
1
answer

Error Code: 1064 - MySQL

Hello, everyone! When constructing a simple inclusion procedure gave this message!    Error Code: 1064. You have an error in your SQL syntax; nac_res, cpf_res, cin_res, est_civ, data_mat, 'at line 89 Warning gives the natural variab...
asked by 17.07.2014 / 00:50
2
answers

Entry point location error in MYSQL

What could this error be? I tried everything and could not solve it ...     
asked by 12.07.2014 / 18:15
3
answers

Date format incompatible when importing data from Excel to MySQL (00-00-0000 VS 0000-00-00)

I'm trying to import data from an Excel spreadsheet to MySQL, the problem is that I have a column in Excel that the dates are in dd-mm-yyyy format and the format accepted by MySQL is yyyy-mm-dd . I want to know how to convert the da...
asked by 14.03.2014 / 21:00
2
answers

Convert date format to MySql

I am developing software in C# and in this software I asked to inform the date of birth of the client in dd/mm/aaaa format, but only in the database the data type is only accepted in aaaa-mm-dd format, I wanted to know if th...
asked by 25.04.2016 / 17:38
2
answers

How to keep a $ _POST on page

I have a question system, and I've implemented a form where people choose which area to respond to: <form class="form-horizontal" method="POST" action="perguntas.php"> <fieldset> <legend>SELECIONE O QUESTIONÁRIO</leg...
asked by 15.04.2016 / 22:01
1
answer

I'm trying to list data from my bank, more precisely from column cpf, but I can only bring a given

List < VarUnica > list = new ArrayList < VarUnica > (); String queri = "select cpf from funcionario"; VarUnica alt = new VarUnica(); Statement ttpa; try { ttpa = Conexao.getConexao().createStatement();...
asked by 06.05.2016 / 20:50
2
answers

PHP and Mysql Percentage

I have a MySQL table where stored product type. I would like to see the percentage of each product registered in the table. I did this: // Verifico o total de produtos cadastrados $sqlTotal = mysqli_query($conexao,"SELECT * FROM produtos"); $t...
asked by 26.05.2015 / 20:18
2
answers

sql query does not work with date in Delphi

I'm doing the following query in Delphi, using MySQL: QueryExtraiDados.Close; QueryExtraiDados.SQL.Clear; QueryExtraiDados.SQL.Add('Select * from clientes where nascimento='+QuotedStr('%'+antecedencia+'%')+' '); QueryExtraiDados.Open;...
asked by 14.05.2015 / 15:27
2
answers

SQL does not return all results it should return

I have the following tables in my bank: I want to select all the products of a certain site (this site marked by the user through a checkbox ) with the following sql : SELECT Eletrodomestico FROM Produtos WHERE URL LIKE (SELECT...
asked by 04.05.2015 / 18:58
3
answers

How to View SQL Query in an Array

I have a question. When I run a Select Count in the database it displays everything right. But how to display the same way using PHP? select country, count(*) as quantidade from customer group by country $sql=mysql_query("select country, co...
asked by 30.04.2015 / 01:33