MySQL Forums
Forum List  »  Stored Procedures

procedure for matrix multiplication
Posted by: Robin Somerville
Date: August 04, 2016 05:37PM

I am new to SQL programming but have worked with time series processing packages for the last few decades.
For reasons too strange to get into, I need to use SQL to create a stored procedure that I can call to multiply the data in two tables to create data for a third table. Table1 has data of dimensions PxQ, Table2 of QxR, and I want to create data for a new Table3 of dimensions PxR (i.e. matrix multiplication of Table1 and Table2).
I will need to use this procedure repeatedly so I would like to be able to call it and supply it with arguments for the table names.
I believe this is possible in SQL, but have not been able to get anything to work yet. Any assistance will be appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
procedure for matrix multiplication
3129
August 04, 2016 05:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.