I have this stored procedure: sp_data with this structure:
BEGIN
SELECT
.
.
.
order by ... ;
END
This stored procedure works fine.
I am currently exporting the results of the stored procedure to a .csv file and then importing the table into MySQL.
What I’m looking for: Stop exporting and importing data. I need to add something to the stored procedure that creates a table and if it exists, it uses DROP to make it run again and keep it always updated.
I tried to create an empty table data with the same data types as the columns to use:
INSERT INTO data (column1, column2,...)
SELECT (same structure as sp_data)
the SELECT part is fine, but when executing it with INSERT INTO there is an error:
Data truncation: Truncated incorrect DOUBLE value: ''
And I can’t modify the SELECT of sp_data because someone else did it and other people use it in the company. That’s why I’m looking to add what I put above.
>Solution :
Use the IGNORE option to downgrade the error to a warning.
INSERT IGNORE INTO data (column1, column2,...)
SELECT (same structure as sp_data)