Questions tagged as 'mysql'

Tagged questions
1
answer

How to insert into the database with prepared statements? Problem with ID

I'm having column count problems because I do not know how to enter data by PDO when it has a id AUTO_INCREMENT that comes before the nome variable. I'm not exactly sure how to enter id along with the other data. Ther...
asked by 24.10.2014 / 17:55
2
answers

More than one table in the query - LEFT JOIN SQL

SQL Help: Query : SELECT * FROM concursos LEFT JOIN concursos_categorias ON concursos.id = concursos_categorias.idConcurso LEFT JOIN categorias_concursos ON concursos_categorias.idCategoria = categorias_concursos.id WHERE concursos...
asked by 22.10.2014 / 12:50
2
answers

I can not display my database information on page

I created my database php , I made the connection to mysql , but the data that exists in my table in PhpMyAdmin , what appears is this: " . resultado['nome'] ." ". resultado['email'] . " ". resultado['turno'] . " " . resultado['uf'] . " ";...
asked by 04.05.2015 / 15:25
1
answer

Replace content according to the search without having to submit

Good people, I have the seginte code require_once 'Connection.simple.php'; $OK = true; $db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING ); if (isset($_GET['name'])) { $data = $_GET['name']; $sql = 'SELECT * FROM channels...
asked by 29.04.2015 / 18:41
2
answers

Search for two MySQL tables in php [closed]

I have two tables that are: Registration Dorsal (id auto_increment primary key); Name; Team; Classification Location (id auto_increment primary key); Dorsal (foreign key); and the following code in PHP : $result =...
asked by 18.06.2015 / 12:40
2
answers

Perform automatic MySQL backup

I'm using MySQL as a DBMS, and while searching the internet for a way to create a backup routine I found that older versions had a tool that no longer exists in newer versions, uses MySQL was not in the old versions. I would like to know if...
asked by 19.06.2015 / 15:57
1
answer

SQL query does not work when there are accents

I have in my database a category defined as TERRENO / ÁREAS that when doing the following SQL query does not return any results from the existing 18.    SELECT * FROM property WHERE 1 = 1 AND CATEGORY IN ('LAND / AREAS') This query alre...
asked by 06.10.2014 / 23:08
3
answers

How to add two values?

while($row = mysql_fetch_assoc($result)) { if($row['level'] == '1') //COMO ADICIONO PARA OUTRO NIVEL CONSEGUIR VER ESTA PAGINA? { echo('OLAAAA'); } else { echo('NAO TENS ACESSO A ESTA PAGINA'); } } How d...
asked by 13.01.2015 / 19:26
1
answer

Export search result to .Txt

I use the MySQL Workbench. I would like to know how I can save the result of a query in a txt file. and that is separated by tabulation, I've tried everything else right.     
asked by 16.06.2015 / 19:12
1
answer

Import MySQL CSV files

I'm using Xampp as a server and MySqlWorkbench as a database, how can I import a csv file to make various experiments (file size, upload time, etc.)?     
asked by 12.06.2015 / 17:49