Questions tagged as 'mysql'

Tagged questions
2
answers

Seconds_Behind_Master grows constantly on MariaDB / MySQL slave server

I have a slave server configured running on Debian 9 in MariaDB 10.1. I configured it and started to work and everything was fine, what worries me is that every time the variable Seconds_Behind_Maste is delayed. He started with 1 second delay an...
asked by 05.10.2018 / 20:42
1
answer

save values in mysql zerofill table with c #

1 SucursalPrimaria int(3) UNSIGNED ZEROFILL I have a table with consecutive zerofill so I can save the zeros to the left but when I capture that data in c # and I add 1 to it and I want to save the next one, I leave it in 0, t...
asked by 08.10.2018 / 07:31
1
answer

Decimals when editing record with modal

Good morning when doing the edition of a record that is the total of the invoice I get the price as well; 1,500.00 € which is as I want, but when editing the record as I get 1,500.00, if I do not edit it becomes 1.00 € and if I edit it but leavi...
asked by 19.09.2018 / 07:32
1
answer

Show checbox already marked with jquery

I have a fullcalendar and clicking on some day will show me a form, the user enters the normal data and must select some people assigned to that event with a checkbox. (There all good). Image with created events: link Image of the regist...
asked by 19.09.2018 / 00:13
1
answer

How to upload multiple files with this code?

How can I make this code can select multiple files and print the names of the files (Incidentally the code adds digits to the file name) if(isset($_FILES['file'])){ //imagen uno $file = $_FILES['file']; // file properties $...
asked by 01.10.2018 / 05:32
1
answer

Open Jframe with click on Jtable (Netbeans)

I am generating a Jtable that has several data, however I need to click on the first cell of each row to open a new Jframe, I have tried with events, but I can not generate it to work specifically there .... So I need to select Registration numb...
asked by 01.10.2018 / 16:21
1
answer

Generate registration number

Friends, I am trying to generate an autoincrementable Registration Number with a certain structure ... The first two numbers correspond to the current year that is added 000000 (5 zeros) and that must be autoincrementando for each record that is...
asked by 20.11.2018 / 20:52
1
answer

QUERY does not filter result correctly

I have the following query: SELECT pe.id_person , pa.id_person_patient , * FROM patient as pa INNER JOIN person as pe on ( pa.id_person_patient = pe.id_person ) WHERE pe.elimination_date is null OR pe.elimination_date = 0 AND pe.name =...
asked by 31.07.2016 / 19:15
1
answer

Filter by dates does not show data

I have a table with invoice records, I'm filtering by date but it does not show me anything <form method="POST"> <div id="fechas"> <label id="lbfecha" for="">Fecha Inicial</label><!--Fech...
asked by 02.10.2018 / 19:32
2
answers

Connection to mysql databases from HTML

Good afternoon I find the following error, I want to get a result of an SQL query to a local DB make a php file with the class and its function, and make an html file so that I can present it but it indicates me error // arhivo php for the conne...
asked by 03.10.2018 / 00:43