Questions tagged as 'mysql'

Tagged questions
1
answer

Problem with cursor in MySQL

Good afternoon! I am successfully creating the following cursor: declare v_cursor cursor for select idCliente, max(dataVenda) from Cliente left join Venda on idCliente = cliente_idCliente group by idCliente; But when I run th...
asked by 07.11.2014 / 20:20
1
answer

How to write MYSQL data in two tables at the same time

How to write MYSQL data in two tables at the same time, but the second table named "t_cadplots" should insert more than one record according to the number of plots so I implemented the for but I'm having compilation errors, which is the best met...
asked by 06.11.2014 / 17:31
1
answer

Filter the return of Stored Procedure

I created the following SP: -- -------------------------------------------------------------------------------- -- Routine DDL -- Note: comments before and after the routine body will not be stored by the server -- ----------------------------...
asked by 27.11.2014 / 02:31
1
answer

How to call two mysql tables on the same php page?

I'm new to web programming, and I'm having a hard time with that. I'm developing an advertisement site and need to call more than one table on the page. I made 3 Div's of advertising: Main, Free and general. I can only display the main, fr...
asked by 14.01.2015 / 18:58
1
answer

Is not the mysql start command path set?

I'm trying to connect web service to netbeans on ubuntu with mysql server, but when I click on start this image error:     
asked by 06.12.2014 / 14:42
1
answer

mysql update using array

I'm having trouble inserting an array into the database ... I tried this script but it only inserts the last id of the array; <?php $_conexao = mysqli_connect("localhost", "root", "", "vbt_posteds"); $id_ind = $_POST["inds"]; $id = "57";...
asked by 25.09.2014 / 16:07
1
answer

How to list checbox data?

My code looks like this: <!-- caixa de seleção de técnicos --> </style> <body> <p>T&eacute;cnico</p> <form method="post" action="salvar.php"> <b><select name="nome"> <option value="vazio...
asked by 13.11.2014 / 04:43
2
answers

Run SQL files inside subdirectories on Linux

I have a repository of SQL files where each represents a stored procedure . These files are inside a directory organized in other subdirectories. Example of my directory structure: stored-procedures ---d1 ------sd1 ---------sp1.sql -------...
asked by 14.11.2014 / 11:38
1
answer

Doctrine findAll method returns the same id on all lines

I'm doing a search that returns all my Entity data. It happens that it returns me all the data but with the same id, but I checked the database the ids are different. . $entityManager->clear(); print_r($entityManager->getRepo...
asked by 03.10.2014 / 16:40
1
answer

Why am I unable to do the INSERT in the database?

<?php class Connection { private $nome; private $data_nascimento; private $genero; private $rg; private $cpf; private $email; private $telefone_fixo; private $telefone_celular; private $cidade; private...
asked by 20.01.2015 / 17:41