Questions tagged as 'mysql'

Tagged questions
0
answers

Return data from table parameters, even if result $ query is 0

Good night: I'm developing a project that consists of the parameters all in a parameter table ... However, in my SQL it only works if it has registers above 0: Follow the code public function getAcompanhantes($tipo) { $consulta = $this->...
asked by 16.07.2015 / 04:22
0
answers

Export MySQL users and permissions to another server

I am making another server with the same databases of the previous server (I have already migrated the databases) and would like to migrate the users and permissions of this previous server to the new server at one time, is it possible? How do y...
asked by 16.07.2015 / 20:20
0
answers

Search for custom fields and tags in Wordpress with delay of results

I have a Wordpress website that has custom fields related to "Photo Albums", which I am now creating a search engine for. The problem is that because it uses Tags in its albums and custom_fields in the photos, when I perform a search where al...
asked by 14.08.2015 / 18:44
1
answer

How to count the number of comma-separated items in MySQL?

I have a field in a table with data separated by a comma: condicao_pagamento: 20,25,35,45,50 . How do I count the number of comma-separated items using MySQL only?     
asked by 06.07.2015 / 06:13
0
answers

Different Date Format

Sirs, I have the following code: $funcionario_blocodcon_novo = array(); for($i=0;$i<count($funcionario_blocodcon['localtrabalho']);$i++){ foreach($funcionario_blocodcon as $key=>$val){...
asked by 02.07.2015 / 15:27
0
answers

Add option in field "sex" of Magento

I need to add an option in the field "gender" written "neutral." I know where these attributes in the database are in the table: eav_attribute_option_value But how do I add a new attribute there to appear in the gender option?     
asked by 03.07.2015 / 09:36
0
answers

MySql - Performance with 0% efficiency

My MySql is very slow in queries, but these same queries on the production server are quick. So moving here I found this screen as circled in red says efficiency is at 0% and production is at 99.8%. Can you increase the efficiency of my machine?...
asked by 02.07.2015 / 21:19
1
answer

Error fetching data from type Time from database

I am making a query but it is giving error when I try to get values of type Time. This is the error:    java.sql.SQLException: java.sql.SQLException: Bad format for Time   '13: 00: 00.000 'in column 5 The line that is firing the exception...
asked by 09.07.2015 / 20:40
1
answer

Only displays a record in php [closed]

I have a list showing the records in php, and a hidden div that when clicking the link in each record opens this hidden div with a map. But when I add a record with the map link, it only shows one record. My code is as follows: jquery:...
asked by 22.06.2015 / 20:52
1
answer

MySql with entity framework Code First ID jumping 10

I'm setting up a MySql in Azure for an application I'm working on, however saving my records to identity column is increasing by 10. Would this be an entity-adjustable setting or an adjustment made for all tables directly in the da...
asked by 29.07.2015 / 22:09