Questions tagged as 'mysql'

Tagged questions
0
answers

Fatal error in MySQL server

I have a situation with the MySQL server and I have to reinstall but I do not have backup of my Databases . I only have the files that are generated in:    C: \ xampp \ mysql \ data db.opt .ibd .frm Is there any way to recover m...
asked by 19.04.2018 / 23:31
0
answers

Problems moving between columns a mysql record

Good morning, who could help me with this. It is a system to take control of the agenda, for days. What happens is that when I enter a record the first one fits well. from 10 a.m. to 2 p.m., but when I enter another one, I add them agai...
asked by 07.03.2018 / 18:05
0
answers

How can I make a table that organizes preventive maintenance activities depending on the periodicity, any ideas?

I would like to ask you for an idea of how I can implement this system, to send for maintenance activities depending on the periodicity. This image represents the excel to which I must guide to do it web Until now I only have this, ad...
asked by 07.03.2018 / 20:36
1
answer

Help with this MySQL query

I would like you to help me with a problem, because I am learning and I have an urgent job: I have a table called 'vendor', another called 'invoice', they are related to a foreign key. In addition there is another table called 'product', related...
asked by 14.03.2018 / 02:30
0
answers

Problems filtering data from a form with PHP and Mysql

I expose my problem for which I write by this means. I'm creating a system in which the user lists some records that come from a database, in the frontend I show all the data in a table, above the table that shows the data is a form to filter th...
asked by 16.03.2018 / 14:59
1
answer

How can I pass a string from String to decimal?

I need to pass a String string that is in an object of type JTextField to a BigDecimal variable or any other data type that can store values of this type "785,292.90" and then store them in the DB (decimal (65, 0) )     
asked by 16.03.2018 / 00:27
2
answers

How to see data from a table when clicking?

I was already investigating and everything and I can not find how to do it, I explain what I want to do ... I have this table in PHP and MYSQL ... <table> <thead> ... </thead> <tbody class="buscar1">...
asked by 16.03.2018 / 17:04
0
answers

Obtain the second highest value

The problem I have solved, but here I expose my solution in case there is one better. (The following is an example, I will not put the actual tables) I have a table with routes and distances. It is desired to obtain the record with the second hi...
asked by 20.03.2018 / 22:18
1
answer

How to get the information in a select depending on what you have selected from another select?

I'm doing a crud of employees, in the employee creation form I have 2 select. The first selection is that of departments, therefore it displays, for example (Dpt. Audit, Informatics, Warehouse, etc). And the second select is that of posts, there...
asked by 02.03.2018 / 07:04
0
answers

Delete datetime records from a user table

I'm making a web application that takes data from a fingerprint reader. I import all the records to the BD of xampp and up there everything is fine. When I want to evaluate the assists I find that there are 2 entries. For example one is:...
asked by 05.03.2018 / 20:54