Questions tagged as 'mysql'

Tagged questions
1
answer

Problem in MySQL Connector

I'm using MVC 3, EntityFrameWork 4 and MySQL database. I hosted my application on Locaweb. Unfortunately I can not do the same connect to the database. Running the application on my local machine and connecting to the bank hosted on Locaweb work...
asked by 14.07.2015 / 19:12
2
answers

Pass table field as parameter in a procedure

I made this procedure to bring records of a table between dates, but I need to pass the date field of the table to the command between function, follow the code: DELIMITER // CREATE PROCEDURE pro_get_gastos(nome_tabela VARCHAR(20), data_ini DA...
asked by 18.06.2015 / 18:07
1
answer

Error in update "Call to undefined function mysqli_sql ()"

update returns the following error in the 1st result: Error:    Fatal error: Call to undefined function mysqli_sql () in F: \ XAMPP \ htdocs \ PAPBRUNO \ PAPBRUNO \ alter_cli_exe.php on line 21 My code: <?php $link = mysqli...
asked by 14.06.2015 / 21:21
1
answer

Select subcategory by category

Having the following tables in the category and subcategory database: CREATE TABLE categories ( id INT AUTO_INCREMENT PRIMARY KEY, category_name VARCHAR(255) NOT NULL, created DATETIME, modified DATETIME ); CREATE TABLE sub_categories...
asked by 27.07.2015 / 19:31
1
answer

I can not bring all records from the table

Hello, I'm not able to show all the records in a DB table row, I can only bring the first record. Here is my table: CREATE TABLE IF NOT EXISTS 'tbnoticiasrel' ( 'id' bigint(20) NOT NULL AUTO_INCREMENT, 'id_noticia' bigint(20) NOT NULL, 'id_...
asked by 27.07.2015 / 15:16
1
answer

Concatenation of a Select field in the ADDTIME

"SELECT at.codigoTurma, " "ADDTIME(t.horaInicioCurso, '00:01:00'), " "t.toleranciaCurso, " "t.horaFinalCurso " "FROM AlunosTurmas at " "INNER JOIN Turmas t " "ON t.codigoTurma = at.codigoTurma "...
asked by 27.07.2015 / 19:10
1
answer

Take time to access a page and write to DB

I need to take the time that the user was on a particular page, and the user to leave the page, this time be registered in the database. Would anyone have any idea how to do it? [Edited] The time I was able to catch using javascript. Th...
asked by 16.07.2015 / 15:51
1
answer

Problem loading data with Entity Framework using Include

I'm using the Entity Framework with MySql on my system and I need to do a specific query that includes a list of a Model ( ApplicationUser ), in this list each returned object has in its properties another Model . That is, each...
asked by 06.06.2015 / 01:40
1
answer

Adding values from the database column

I'm doing a reporting system and the bank will have, for example: > - visualizacoes | 300 > - clicks | 20 > - data | 2015-06-03 > - visualizacoes | 230 > - clicks | 3 > - data | 2015-06-03 > - visualizacoes | 340 > -...
asked by 04.06.2015 / 17:10
1
answer

MySQL - Returning some records only if grouped

I have a simple form system that registers in the bank the amount of daily benefits of a person in the company. The database does not return this data in most cases. The problem began to happen after last week's server's HD's burned out. We w...
asked by 20.07.2015 / 16:34