My project uses MemSQL Database to connect through our Java Spring Boot API.
We have a requirement to save list of records in one of the table in MemSQL database.
So for that we have to write a stored procedure which can take this list/array/datatable as input parameter, but we are not sure which data type supports this in MemSQL.
Can some one please help us achieve this functionality.
This is Table create script:
ID bigint(20) NOT NULL AUTO_INCREMENT,
LOB varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
Rpt_LOB varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
L4_Tax varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
IsSelected int(11) DEFAULT 0,
Load_Date datetime DEFAULT NULL,
PRIMARY KEY (
) AUTO_INCREMENT=112 /*!90623 AUTOSTATS_CARDINALITY_MODE=PERIODIC, AUTOSTATS_HISTOGRAM_MODE=CREATE / /!90623 SQL_MODE=‘STRICT_ALL_TABLES’ */;
And we want to create a stored procedure which will take the list/array/datatable as input and in that stored procedure we will write the logic to insert/update all the records in the above table in one transaction.
Any help will be appreciated.