Questions tagged as 'mysql'

Tagged questions
0
answers

Can database overload this way? [closed]

This explanation does not need code, it's more a matter of the same database logic. What's happening: I have an application using CodeIgniter and MySql, and it has 4 actors, but in one of these actors, the more you loga , the longer it takes...
asked by 07.08.2015 / 16:06
1
answer

Filling tables with multiple foreign keys [closed]

I have a database with the following tables: Airport Airport Cause_Cancelation (CodeCanceling PK , description) Manufacturer (ManufacturerName PK , manufacturername) Template (Template ID PK , template_name, FK...
asked by 09.08.2015 / 19:25
1
answer

Search for Modules according to the Permissions

I've built a function that lists all modules and submodules within the system. But I need it to be different, I need that in this same listing, just come the modules and submodules that the client has access to, rather than checking whether he h...
asked by 23.07.2015 / 20:08
0
answers

Doubts on PHP pagination [closed]

I'm working on a system and I'm having doubts about paging, I know I may have some grotesque mistakes because I do not "handle" much. <?php include("cabecalho.php"); include("conexao.php"); include("banco-dados.php"); $totalReg = 11;...
asked by 29.07.2015 / 15:59
0
answers

Create Trigger / Stored Procedure Mysql to change characteristics of a column

I'm trying to create a Trigger / Stored Function for when the user changes the value of a column from 0 to 1 it changes the characteristic of another column CREATE TABLE 'aluno' ( 'CPF_ALU' varchar(11) NOT NULL, 'PRIORIDADE' tinyint(1) NOT...
asked by 17.06.2016 / 04:42
1
answer

Chat with nodejs and mysql [closed]

I created a chat with nodejs and MySQL to fetch information from the user ... but I have a following problem: when the connection drops or restart the nodejs server, back logging in username and password. Does anyone have a clue how to do th...
asked by 30.06.2015 / 17:15
1
answer

How to list result of the database count

I want to list a table record and display the sum of reported times, but I can not. The reports table has the field registration and duration registration duration 2501 00:40:00(timestamp) 2501 01:20:00(timestamp...
asked by 09.11.2015 / 23:25
2
answers

Log off when logging in

Good morning everyone! Gentlemen, I need guidance and I also need to know if I can do it. It is the following: I have a table in my database that registers the users that are logged in, it follows: What I want to do is, every time a log...
asked by 11.11.2015 / 13:52
0
answers

Enable federated [closed]

I need to enable the federated plugin in mysql. I'm adding federated to my my.cnf file, when I check for show engines; says it is not enabled. I'm using Mac OSX 10.11 and mysql 5.2.26. Any solutions to this?     
asked by 08.10.2015 / 16:57
0
answers

Is it possible to delete a file if there is no reference to it in the database using mySQL

I would like to know if anyone knows of any way to create a "trigger" in MySQL that deletes a value from the table, delete a file together on the server, for example: Exclude the item from tbl_imagens whose name is imagem_1001.jpg...
asked by 15.04.2015 / 15:38