For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
What is the maximum number of inserts we can achieve with MySQL 5.7 and MySQL 8.0 assuming that the supporting hardware is optimal.
WITH SAMPLE(ID,FirstName,LastName,City,State,Phone,SystemDate) AS ( SELECT 1,'John','Doe','ABC','FL','5555555555',DATE '2020-12-01' FROM DUAL UNION ALL SELECT 1,'John','Doe','ABC','FL','8888888888',DATE '2020-12-01' FROM DUAL UNION ALL SELECT 2,'Jane','Smith','XYZ','CA','9999999999',DATE '2020-12-01' FROM DUAL ) SELECT ID, FirstName, LastName, City, State, LISTAGG(Phone,',') WITHIN GROUP(ORDER BY Phone) Phone, SystemDate FROM SAMPLE GROUP BY ID, FirstName, LastName, City, State, SystemDate / ID FIRS LASTN CIT ST PHONE SYSTEMDAT ---------- ---- ----- --- -- --------------------- --------- 1 John Doe ABC FL 5555555555,8888888888 01-DEC-20 2 Jane Smith XYZ CA 9999999999 01-DEC-20 SQL>
SY.
Wow! That did the trick. Thanks so much! I did not realize it would be something as simple as that.