FREE AI-Enhanced Online MariaDB Compiler

Untitled*

You must execute the code again to save those values in the database.

drop table if exists app;
create table if not exists app
(
	Version char(40),
	Description char(100),
	Latest_Rating char(10),
	Latest_Wine_version_tested char(10),
	Test_results int,
	Comments int,
	PRIMARY KEY (Version)
);

insert into app values
('1.0 (DOS)', 'Acrobat Reader 1.0 for DOS','Gold','1.5.12',4,0),
('10.x','Adobe Reader X','Silver','1.7.55',18,0),
('11.x','Introduces Extended tools, improved PDF Annotator, improved eSignatures.','Silver','3.11',26,0),
('2.x','Acrobat Reader 2','Garbage','5.0',3,0),
('3.x (16-bit)','Acrobat Reader 3 for Windows 3.1','Bronze','1.3.16',7,0),
('3.x (32-bit)','Acrobat Reader 3 for Windows 95 and later','Platinum','1.9.14',10,0),
('4.x','Acrobat Reader 4','Platinum','1.9.14',8,0),
('5.x','Acrobat Reader 5','Gold','1.9.14',6,0),
('6.x','Adobe Reader 6 for Windows 98SE, NT4 SP6 and later','Platinum','1.9.14',5,0),
('7.x','Adobe Reader 7 for Windows NT4 SP6 and later','Silver','5.0',7,0),
('8.x','Adobe Reader 8.  Later versions include support for Windows Vista.','Platinum','1.9.14',14,0),
('9.x','Adobe Reader 9','Platinum','2.0.2',9,0),
('DC','Adobe Acrobat Reader DC for Windows 7 and later','Gold','7.0',16,17);

select * from app order by cast(substring(version,locate(' ',version)+1) as signed), substring(version,-1);

Version	Description	Latest_Rating	Latest_Wine_version_tested	Test_results	Comments
1.0 (DOS)	Acrobat Reader 1.0 for DOS	Gold	1.5.12	4	0
3.x (32-bit)	Acrobat Reader 3 for Windows 95 and later	Platinum	1.9.14	10	0
3.x (16-bit)	Acrobat Reader 3 for Windows 3.1	Bronze	1.3.16	7	0
DC	Adobe Acrobat Reader DC for Windows 7 and later	Gold	7.0	16	17
2.x	Acrobat Reader 2	Garbage	5.0	3	0
4.x	Acrobat Reader 4	Platinum	1.9.14	8	0
5.x	Acrobat Reader 5	Gold	1.9.14	6	0
6.x	Adobe Reader 6 for Windows 98SE, NT4 SP6 and later	Platinum	1.9.14	5	0
7.x	Adobe Reader 7 for Windows NT4 SP6 and later	Silver	5.0	7	0
8.x	Adobe Reader 8. Later versions include support for Windows Vista.	Platinum	1.9.14	14	0
9.x	Adobe Reader 9	Platinum	2.0.2	9	0
10.x	Adobe Reader X	Silver	1.7.55	18	0
11.x	Introduces Extended tools, improved PDF Annotator, improved eSignatures.	Silver	3.11	26	0