Questions tagged as 'mysql'

Tagged questions
1
answer

Comparison between mysql fields

I have a Mysql table where I store the years I get from a record, however I'm creating a search where the user selects from one date to another. In Mysql I did it this way: SELECT * FROM tabela WHERE AnoEmpresa BETWEEN 1970 and 2014; It doe...
asked by 17.05.2015 / 21:44
1
answer

Windows 7 Server with Mysql 4.1

Can anyone tell me what the performance limitations and maximum number of users will be to use a Windows 7 server with MYSQL 4.1? Does it support a system used by about 50 people simultaneously?     
asked by 21.05.2015 / 21:18
1
answer

Java project with Oracle and MySQL at the same time?

Given an Oracle Database and a MySQL DB, and the impossibility of integrating both databases: Would it be possible, for example, to class my application 'look' at the mysql table and update an oracle table?     
asked by 04.05.2015 / 19:15
1
answer

Bank connection error. Java + Workbench

Bank connection error. Can anyone help me? package conexaoprojeto; import java.sql.*; import javax.swing.JOptionPane; public class ConexaoProjeto { private final String Driver = "com.mysql.jdbc.Driver"; private final String Url = "j...
asked by 24.05.2015 / 05:54
1
answer

Upload error [function.move-uploaded-file]: failed to open stream: Permission denied [duplicate]

I'm trying to make a record where I have uploads of images and need to save all this content in different tables. The text part is saving perfectly however the photo part is still not saving. Here is the PHP code that saves the data...
asked by 26.06.2015 / 18:14
2
answers

Problem with PDO connection and mysql_query

Hello, I created the connection.php file as follows: <? $conn= new PDO("mysql:host=localhost;dbname=site", "root", ""); $count = ('SELECT * FROM conteudo'); $stmt = $conn->prepare($count); $stmt->execute(); $result...
asked by 08.05.2015 / 05:21
1
answer

Select Distinct

tbl_protocolos id_protocolo | protocolo | assunto 1;ra001;vazamentos 2;ra002;incendios 3;ra003;inundacoes tbl_prot_tramitacoes id_tram | id_protocolo | pdf | id_setor_origem 1;1;001.pdf;70 2;1;001.pdf;100 - **rejeitar por causa do id_set...
asked by 31.05.2015 / 00:16
1
answer

Problem with code

Okay, here's what I have: <form style="" name="form"> <input placeholder="Search..." name="name" id="fn" type="text"> <input style="display: none ! important;" value="Search" id="search-btn" type="submit">...
asked by 02.05.2015 / 03:06
1
answer

Breaking query fields

I'm doing a search with mysql, where the return is a DATE field, I need to break this field into DAY, MONTH, TIME, SECONDS and put each one within a variable, I'm not able to do this, a query but it is returning    Resource id # 18   ...
asked by 02.07.2015 / 22:58
1
answer

MYSQL - Return occurrences closer to REGEXP

I need to return the number of occurrences closest to REGEXP, see the example below: SELECT * FROM tabela WHERE nome_produto REGEXP 'vestido|longo|manga|curta' The idea is that this query returns me like this Long sleeves with short sle...
asked by 28.04.2015 / 00:36