Questions tagged as 'mysql'

Tagged questions
1
answer

MYSQL - Select is not working properly

Good evening, I have below the search in the database, but it returns me error or does not work on line 4 where it says "JOIN contracts co ON c.email! = co.email", has how to do otherwise, or improve the search? Thanks SELECT os.osID, c.nom...
asked by 27.09.2015 / 00:29
2
answers

Get MySQL data with PHP and go to JavaScript

I'm trying to use jquery to do an auto complete in my search field. The connection to the bank is correct and I use the following code to save the files: <?php INCLUDE "conexao.php"; $sql = "SELECT * FROM consulta"; $result = mysqli_que...
asked by 26.09.2015 / 21:58
0
answers

Creating EF Designer from a database

When I click on NEXT it closes, when I use a sqlserver it works normally, but in this case I'm trying with mysql and I'm having this problem, Has anything like this ever happened to you?     
asked by 15.11.2016 / 19:14
1
answer

Position search response on inputs

I'm doing a search on my BD and trying to position the results in some inputs , I'm able to search and get the data I need, but when I position the result in my inputs they are getting tripled and not respecting the defined p...
asked by 21.11.2016 / 15:55
1
answer

Error: Array to string conversion - Select multiple Laravel 5

In my View I have: <select multiple="multiple" name="carga_mental[]" class="form-control select2"> @foreach($cadastros->where('key', 'carga_mental') as $carga_mental) <option value="{{ $carga_mental->title }}"> {{...
asked by 22.11.2016 / 18:42
0
answers

Hibernate does not update information

My problem is that an unsuccessful update follows the code below. EntityManager manager=JpaUtil.getEntityManager(); EntityTransaction trx= manager.getTransaction(); trx.begin(); TypedQuery<Tipi> query = manager.cr...
asked by 03.11.2016 / 14:28
0
answers

How do I display the areas in each category? [closed]

Good evening guys, I need a little help I ended up here in PHP, it's the following, I created two tables category and area, each category has several areas, each area can only have one category, the relationship I was able to do , the problem is...
asked by 02.11.2016 / 05:03
0
answers

Error setting up Mysql on xampp

I am setting XAMPP v3.2.2 and my MySQL is not working, follow the error :    Error: MySQL shutdown unexpectedly.       5:54:11 PM [mysql] This may be due to a blocked port, missing dependencies,       5:46:11 PM [mysq...
asked by 01.11.2016 / 20:56
1
answer

Save contents of a Listbox in the mysql database

Good morning, I have a listbox and am having trouble storing the contents of this list in the Mysql database. Can anybody help me. I followed the code and error below: def SaveVariosCodBr(self): db=self.conexaoBanco() cursor=db....
asked by 13.11.2016 / 15:44
0
answers

What better MySql index [closed]

Hello, I have a question about explain, index in mysql Real Estate Table 47.240 Order of Service Table 1,887,421 SELECT SQL_NO_CACHE COUNT(*) FROM imoveis I INNER JOIN situacao_cod_venda SCV ON SCV.flag_mostra_site = 1...
asked by 13.11.2016 / 15:36