Questions tagged as 'mysql'

Tagged questions
1
answer

Factory error using @Embeddable in JPA

I need to create a composite key on my system, after researching a little to find out that I should implement @Embeddable, until all right, I added the class in my system implementing the keys, but when I try to run the factory it indicates a pr...
asked by 11.01.2018 / 14:51
1
answer

Group Month according to Between

I created a MySQL statement to display a graphical report, I wanted the months to be displayed from the month reported by the start date to the month of the end date. But in my SELECT it groups the months and brings in a growing order Sql s...
asked by 11.01.2018 / 13:45
1
answer

Error executing POST method

I'm facing a problem with the POST method, when I trigger this method it normally inserts into the database, but the application (node index.js) is terminated, at the command prompt I get this error: Error [ERR_HTTP_HEADERS_SENT]: Can not se...
asked by 06.12.2017 / 18:51
1
answer

Create procedure in mysql

I'm trying to create the second precedence in mysql, but when I give the enter in the first line of the declare it gives the following error: ERROR 1064 (42000) CREATE PROCEDURE finaliza_expedicao (IN expedicao_id INT) BEGIN DECLARE...
asked by 06.12.2017 / 19:56
1
answer

I have a report in excel, how do I extract by date?

I have a report in excel that does a search in the DB and brings all the information. How do I put in form in php the user enter the date and search in the BD just between those dates and mount the excel? My code looks like this: $arqui...
asked by 15.12.2017 / 15:02
3
answers

Remove character to search the database

I'm having problems creating a function to search the database and from zip fill in the fields related to it, such as address, neighborhood, city and state. Obs : I have a mask in the zip function.php <?php include("conn.php");...
asked by 07.12.2017 / 20:22
1
answer

ERROR CODE 1215 - You can not add the foreign key

Table 1: Table2: Command: ALTER TABLE extras ADD FOREIGN KEY (login) REFERENCES usuario(login); Response: Error Code: 1215. Cannot add foreign key constraint    Can not find an index in the referenced table where the   ...
asked by 11.12.2017 / 17:51
1
answer

Insert records from one table into another in MySql?

I am having difficulty inserting data from one table into another, for example I have the budget table that has the items, but the items can be from different vendors, and when this budget is approved it should generate the purchase orders for t...
asked by 04.01.2018 / 13:59
2
answers

Unsupported update form

I have a form already filled with two extra inputs only for the user to edit the information already registered and add the two new ones. However, although%% of "saved successfully" appears, when I check with the bank, the information has not...
asked by 25.01.2018 / 17:42
1
answer

Search in MySQL using only day, month or year with PHP

I created a table in a DATETIME field to store the day, month, year and time where a record is made. Would you like to know how I can search only by using day, month, or year? Example: I have 4 records: 2017-02-03 2017-02-13...
asked by 26.01.2018 / 16:19