Questions tagged as 'mysql'

1
answer

Error in db: create in Mac OSX Montain Lion

alexandesigner$ rails server dyld: lazy symbol binding failed: Symbol not found: _mysql_get_client_info Referenced from: /Users/alexandesigner/.rvm/gems/ruby-2.0.0-p353/extensions/x86_64-darwin-12/2.0.0-static/mysql2-0.3.15/mysql2/mysql2.bundl...
asked by 07.02.2014 / 12:50
1
answer

Google Chart's Line with While

Good afternoon,  I have the following query: SELECT DATE(o.data_fechamento) AS Data, u.nome AS Pessoa, COUNT(*) AS Total FROM ocorrencias AS o LEFT JOIN sistemas AS a ON a.sis_id = o.sistema LEFT JOIN localizacao AS l...
asked by 04.04.2017 / 20:55
1
answer

Tracking and posting system (social network type)

I am developing a new project and I am creating a system of profile followers, in which the purpose is to show only the publications of whom I follow. Like for example the one of a social network. I follow the person, so I get the person's publ...
asked by 13.12.2014 / 19:59
1
answer

File Download MySQL Blob

I need to download a .xls file that is in a MySQL database, but I need to save it with the original name. Can anyone help me? Uploading with you can be easy. I need to download it. include_once 'db.php'; $download = mysql_query("S...
asked by 05.12.2014 / 17:21
1
answer

Correct syntax for SELECT and INNER JOIN in Zend

I think it's a simple question, but because I do not know 50% of Zend I'm breaking my head, so here it goes: $sql = $db->select() ->distinct() ->from(array('cli' => 'fc_cblcli'),array('codigo','tipo','nome')) ->join...
asked by 19.11.2014 / 20:38
1
answer

Change a Select mysql to a Select PDO

I have a Select from sources listed in a table, and I currently use this code to list them so that the user can choose the desired font. <select name="tipo_font_end"> <?php $select = mysql_query("SELECT * FROM fontes");...
asked by 09.05.2015 / 20:16
1
answer

Activity has Leaked window Android

I make a connection to MySQL and it returns me a JSON that I play in a list of products. When I click on any of these items it picks up the ID (called PID in the code) of the product and sends it to another Acitivity. In this other Activity the...
asked by 12.05.2015 / 18:37
1
answer

Remove MySQL root after creating another user with all privileges

In this tutorial: link After creating a new user with the privileges that I need, they recommend that I rename the root user to further ensure access, and a hacker, in addition to discovering the password, would have to find out the user....
asked by 21.03.2015 / 21:06
2
answers

Publish application with Entity Framework + Mysql

I'm using Entity Framework to Mysql . I installed .Net Connector , and MySQL.Data.Entities . Locally is working normally. But when I go up to LocaWeb , it will not. The following error appears:    Can n...
asked by 12.11.2014 / 00:56
1
answer

Retrieve last row inserted into table with non sequential primary key - MySql

Is it possible to know which last row was inserted into a MySql table where the primary key is not sequential? I have a table where the primary key is made up of two columns that are FK, so they do not follow a sequence. When executed the...
asked by 23.08.2016 / 16:08