Questions tagged as 'mysql'

Tagged questions
0
answers

How do I access an OpenShift MySql database via Jdbc via the Google Spreadsheet?

I want to access a MySql bank hosted on OpenShift via Jdbc from the Google Spreadsheet. Is it possible? In Google Spreadsheet, in Ferramentas -> Editor de Scripts , I'm having problems with the connection string that is in this forma...
asked by 13.04.2015 / 19:28
0
answers

Mysql Lost Tables?

I just had a strange experience with mysql, I have a database with 8 tables in my local server. From time to time my system did not want to log in anymore, I checked in phpmyadmin and it showed the tables, but when I gave select it received the...
asked by 31.03.2015 / 01:03
2
answers

Condition (WHERE) with IF

I have two tables (posts and posts_promovidos). Both are related and the "normal" search works without problems. However, I need to do a search that returns all posts and, if the post belongs to posts_promovidos, bring me only the posts_promovid...
asked by 28.01.2015 / 16:05
1
answer

Change user data without logout / login

Good people, I think a lot of people working with PHP have already encountered this question of mine: When I edit something in the user, it does not edit soon, that is, it has to logout and log in to session .. Here's an example: I...
asked by 03.02.2015 / 00:29
2
answers

Problem with while loop in PDO

I'm not sure what to do, but I do not know how to do it. Code $result = $conexao->prepare("SELECT * FROM colecoes WHERE menu = :menu AND activo = :activo ORDER BY pos ASC "); $result->execute(array(':menu' => 'Comer', 'activo' =...
asked by 06.03.2015 / 23:05
0
answers

Problems deleting in MySQL via MVC 4

I have a problem that does not steel the least idea of why it is happening and also I can not solve. I developed a WEB application in MVC 4. I can add and edit new records. But you do not want to delete it at all. It does not make any mistake. H...
asked by 04.03.2015 / 17:48
2
answers

How to store a pdf file in a MySQL database?

I'm developing a project and one of my tables in MySQL will contain .pdf files. The table ' arquivopdf ': + - - - - - - - - - - - - - - - - - - - - + | numerocotacao | arquivopdf | + - - - - - - - - - - - - - - - - -...
asked by 03.01.2015 / 20:25
2
answers

Query assembly query with INNER JOIN

Hello ... I have the following query: $conexao = connect(); $consulta3 = mysql_query("SELECT meu.id, f.idfollowed, eu_sigo.fname, eu_sigo.id, eu_sigo.profile, eu_sigo.photoperf, p.id, p.title, p.link, p.description, p.descr, p.url, p.photo...
asked by 29.12.2014 / 19:46
0
answers

MySQL For Excel and options to import Excel table into MySQL

I'm trying to import a database that is in the format of Excel to MySQL. I was trying with MySQL for Excel, launched the same company. As you can see in the image below it is already installed: InmyExcelnothingappears,intheexamplethatha...
asked by 07.01.2015 / 12:27
0
answers

Inserting value of type double in the mysql database

I have a WindowsForm with a value field and I need to enter the value of it in the database. Do I need some examples of how to do this? Query file //Cadastrar Gastos public void cadastroGasto(Gasto gasto) { tr...
asked by 08.01.2015 / 01:25