Questions tagged as 'mysql'

Tagged questions
0
answers

Permissions in the views of django admin

I am doing a web based system for several transport companies in django the issue is that it must be multi user but I am having a problem to display the data fix in the image that I put all good that I display the data that way but this...
asked by 29.09.2018 / 19:22
1
answer

case within select mysql

Following the migration of SYBASE to MySQL I have found the following case, a case within the select. I leave the example in case you could guide me how to do it. Thank you!! select mvfg_cantidad * case mvfg_tipo_origen when 'P' then 1 else -1...
asked by 28.09.2018 / 10:17
0
answers

Problem when printing a table with JSPDF

Greetings developer friends, I am using jspdf to print a div that contains my table generated by PHP, I bring the table of a MySQL database, the point is that when I click on a button I generate a PDF with jspdf of the div that contains the tabl...
asked by 06.10.2018 / 22:08
0
answers

Make transfer access to mysql, optimized

If I have an access database on computer A and I want to implement a mysql server on a B machine, how do I make the access transfers to MMYSQL faster? 1) I make a public in (// A / publish) and change the data storage path of my MYSQL server...
asked by 01.10.2018 / 22:50
1
answer

Login with user privileges

I log in with privileges, that is, if it is an administrator that redirects it to another page, but I have a problem with my code since what I need to compare is my field username (username == administrator) If it is equal to administrator t...
asked by 03.10.2018 / 01:54
0
answers

How to implement a dialog in html?

Hello good afternoon, I am making a website made with html php and mysql I currently set the title attribute of some HTML if I want to provide more information but when I'm going to show it on an ipad you can not show someone would help me solve...
asked by 02.10.2018 / 20:32
0
answers

How to update the following records of a selected record? MySQL

I have a movement table and I want you to re-calculate when you update a past record: I have these records in this table (the black line closes a data that does not have to see): I am editing the first regitro. In the form I would be...
asked by 28.09.2018 / 23:25
0
answers

Error Code 1241. Operand should contain 1 column (s) function MYSQL

Create a function in mysql to work with a sequence the code of the function is as follows: FUNCTION 'fn_nextValue'(SEQNAME varchar(50)) RETURNS bigint(20) BEGIN DECLARE EXIST_SEQ INT; DECLARE CUR_VALUE BIGINT(20); SET EXIST_SEQ = (SELECT COU...
asked by 24.09.2018 / 17:24
1
answer

How is a trigger that adds a row and that is assigned in a column?

Well the fact is that I want to make a sum of a row and that this is saved in a field here of how I carry the table: the case is that when entering: UPDATE enero SET totalgastos= enero.alimentacion+enero.transporte+enero.ser...
asked by 24.09.2018 / 01:03
0
answers

Call to a member function result () on a non-object

I have the following error: Call to a member function result() on a non-object the error only appears in the 2 "if" if they analyze it in the second "if" there are only 2 extra lines, if I remove those extra lines it is the same as the fi...
asked by 28.09.2018 / 17:27