Questions tagged as 'mysql'

Tagged questions
1
answer

Connection Entity Framework with Mysql

I have done the procedures pointed out in these questions: Entity Framework - Bank Compatibility MySQL Connection Error asp.net MVC I installed MySQL.Data.Entities. My web.config looks like this: <connectionStrings>...
asked by 07.11.2014 / 02:54
1
answer

How to download a DB from the console?

I need to download a database on my machine, but it can not handle the MySQL Workbench. Is there a program lighter than the Workbench or what commands do I need to download the DB that I want?     
asked by 29.10.2014 / 17:53
1
answer

Error: mysql_fetch_assoc within function

function retornaStatusPesquisa($numeroStatus,$nomePessoa, $nomeTabela){ $query = mysql_query("SELECT COUNT(status) AS valorStatus FROM $nomeTabela WHERE status=$numeroStatus AND nomePessoa='$nomePessoa'"); $contador=mysql_fetch_assoc($que...
asked by 30.06.2015 / 00:38
1
answer

how to make a query that the user can generate?

Is there any material to learn? For example: I have a pet shop: Let's say that in my HTML I have several select boxes (animal, breed, sex, age, etc.), in it I can select the dog or select puppy > race or select puppy > rac...
asked by 01.07.2015 / 03:42
1
answer

Relation between 3 tables mysql

I'm trying to make a relationship between three tables. I have the tbl_eventos table that will be a table where you will save the event and its date. The tbl_servicos_extra table will save extra services that can be added to the ev...
asked by 24.07.2014 / 12:47
2
answers

Sorting by date in MySQL

I have a table with two fields: dh_premium_expires and score .    dh_premium_expires - the date / time the user's premium will expire.       score - in-game user score. On my site I have a list where I can list these users,...
asked by 01.04.2014 / 13:17
1
answer

How to compare the value of numbers saved as VARCHAR in mySQL?

I have a table named coordenadas_cache , with 6 fields: codigo (int, auto increment), latitude_sul (VARCHAR(10)), latitude_norte (VARCHAR(10)), longitude_oeste (VARCHAR(11)), longitude_leste (VARCHAR(11)), endereco (VARCHAR(80)) In it...
asked by 04.04.2014 / 03:35
3
answers

Calculation of percentage of growth

I have three columns that would be month , revenue and expenses . For example: Mês | Receita | Despesas Janeiro | 2500 | 1000 Fevereiro | 1000 | 500 I would like to demonstrate the percentage growth using PHP and MySQL....
asked by 04.04.2014 / 00:43
2
answers

Display MySQL PHP Errors Correctly

Hello, I have a simple registration form, where repeated records can not exist in the cpf field and also in the resposta(cupom) field. The validation of cpf is ok and the data does not duplicate in MySQL, but the verificatio...
asked by 26.09.2014 / 19:18
2
answers

Add a fixed word to a friendly URL

Good evening, I'm doing a search and I'm having a problem passing the value that is written in input to another page where the result will be displayed. Url example I'm trying to pass the values http://exemplo.com/locais/pesquis...
asked by 18.03.2015 / 02:35