Questions tagged as 'mysql'

Tagged questions
1
answer

Export password-protected csv from a DB

Is it possible to generate a CSV protegido por Senha file from a banco MySql using PHP ? the password is to open the file on the client. I use this PHP script to generate the CSV file: <?php //export.php if...
asked by 04.09.2018 / 20:27
1
answer

I want to trigger a Stock control, but I do not know how to do it

I want to create a table called 'product' that has its id and the quantity in the inventory and another table called 'purchase, the purchase table will have the primary key of the product and the id of the purchase, so I wanted to decrease the q...
asked by 16.06.2018 / 15:32
1
answer

Syntax error in SELECT MAX

I have a syntax problem in my sql code inside the php code, I need to know which video has the largest id in the database to save it to a separate folder with the same id number, so that the path gets saved in the bank. The error that happens is...
asked by 01.07.2018 / 21:35
1
answer

Load a TEXTAREA field from a SELECT with Jquery

I have a modal that does email sending. But I created some email templates in the mysql database. On the screen appears my select with all templates for selection, only I would like when the template is selected, it filled in the input subje...
asked by 01.07.2018 / 07:39
1
answer

Trigger gives error with date

I did a trigger to count the weekdays. It accepts the dates of month 06 very well, but other dates gives the following error: INSERT INTO 'teste' VALUES ("2018-05-01") #1292 - Incorrect date value: '20180532' for column 'i' at row 1 Trigger...
asked by 29.06.2018 / 22:32
1
answer

Error when making Many to Many relation with Spring Boot

I am trying to make a Many-to-Many link between the usuario and permissao classes, using the hibernate as a reference. But when I try to generate a JSON file of class usuario the program loops and generates an unexpected f...
asked by 19.05.2018 / 00:21
1
answer

Update record in table using selected in MYSQL

I have this problem, which I can not solve. I have the following tables in the database: Andintheformitpullstherightdata,sointhenowthatI'llupdateforexampleonlythecardanddonotchangeanythingelseintheform,thefieldtypeofvehiclesandSectoritd...
asked by 10.05.2018 / 14:51
1
answer

Visual studio 2017 c # BLL & DAL

I have a problem with saving and taking an image of the database. I would like to know a way to enter the image in the database taking into account that the taxpayer number is the primary key and then in another form can use code to search it th...
asked by 10.05.2018 / 12:51
1
answer

Insert in related tables

That's right, I'm not sure how to do this. tb_Customer(id_Customer INTEGER [PK], nm_Customer VARCHAR, cpf_cnpj NUMERIC) dm_address_type(cd_address_type CHAR(1) [PK], ds_address_type VARCHAR) tb_customer_address(id_customer [PFK], cd_address...
asked by 13.05.2018 / 16:30
1
answer

Update PHP variable with Jquery using AJAX request

I have a problem related to HTML, Jquery and PHP, I will try to get as much information as possible. I have a PHP page that has to go back and forth with the variables and it's kind of a step by step, where each step sends its data to the next t...
asked by 12.05.2018 / 05:46