Questions tagged as 'mysql'

Tagged questions
0
answers

Help to fix error 1054 Unknown column '...' in 'field list' in mysql workbench

I would like to ask your help to solve the error:    1054 Unknown column '...' in 'field list' The column that marks me as unknown Has the name Age and the mark as unknown even though it is in the table and written as is. This is the w...
asked by 12.06.2018 / 06:28
0
answers

How to implement roles in my web application

Good I am new here I have a doubt with an authentication system that requires roles, I have a users table related to the other types of users but I do not know how to implement it if a table for each type of user (driver, passenger) as shows the...
asked by 10.06.2018 / 01:42
3
answers

MySQL storage engine (MyISAM to INNODB)

I have a hosting on GoDaddy, I was testing, perform some tests with (begin, rollback, commit) transactions, which had no effect. I was investigating and I realized that "MyISAM" does not allow transactions, so I assumed that the storage e...
asked by 09.06.2018 / 06:14
2
answers

How to access a Connection type variable from another claSe?

you can have a class from: Conection cn; cn=DriverManager.getConnection("jdbc:mysql://localhot:3306/BD","root","pass"); // and from another class, which is the one that inserts a record, call the connection variable "cn"? The idea is to...
asked by 15.06.2018 / 04:11
1
answer

Modify query mysql script datatables

I am trying to edit the following code without success. If no date filter is selected or a character is written in the imput seach, all the records in the table are displayed. What I am trying to do is that by default it does not show all the...
asked by 23.05.2018 / 21:22
1
answer

php error Catchable fatal error when making query

I have this doubt, it is probably very simple answer but I have very little doing this because I still do not soak up the logic hehehehe. Good to the question: This part of the code marks me the error: "Catchable fatal error: Object of class...
asked by 06.06.2018 / 21:03
1
answer

Connection problem mysql database with asp.net core 2.0 on server Ubuntu 16.04

I have a problem I am working on a site in asp.net core 2.0, locally everything works fine the connection of the BD does not give any problem, now the site I uploaded to Ubuntu 16.04 server, until then everything is fine, yesterday I went up the...
asked by 06.06.2018 / 23:30
1
answer

I have to enter the username and password twice to enter the system

I have a page index.php for user login and password that validated its fields with jquery.validate and with this information I get access to the system, but I must always type twice the user and password to access and that generates problems wit...
asked by 06.06.2018 / 20:53
1
answer

It helps the unset () function, it does not eliminate the variables of $ _SESSION

hello I hope you can help me I want to delete specific session variables, but it does not, I'm using the unset function, but my code does not delete the session variables I have two buttons by which depending on which one they choose me to a fil...
asked by 27.05.2018 / 12:12
1
answer

Problem installing flask-mysqldb on linux 16.04

I was trying to install the flask-mysqldb on my Linux 16.04 device but I found a problem, even with a virtual environment: _mysql.c: 32: 20: error fatal: Python.h: No existe ese archivo o directorio . (myFlaskAppenv) mike@mike-thinks:~/P...
asked by 02.06.2018 / 14:48