Comments - You have an error in your SQL syntax; check the manual that corresponds
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
-- Create the sample database CREATE DATABASE testdb;
-- Switch to the test database USE testdb;
-- Create the sample table CREATE TABLE SampleTable ( DateValue DATE, CopperHeadGrade DOUBLE, LeadHG_Pb DOUBLE, ZincHG DOUBLE, SilverHG DOUBLE, DeliveredToPlant DOUBLE, Milled DOUBLE, CopperCuPercentage DOUBLE, CopperCuRecovery DOUBLE, LeadPbPercentage DOUBLE, LeadPbRecovery DOUBLE, ZincZnPercentage DOUBLE, ZincZnRecovery DOUBLE, TonsSilverAg DOUBLE, SilverAgRecovery DOUBLE, Source NVARCHAR(255), CopperInCopper DOUBLE, LeadInCopper DOUBLE, ZincInCopper DOUBLE, SilverInCopper DOUBLE, pH DOUBLE, OilInFeed DOUBLE, Measure_150microns DOUBLE, RedoxPotential_eH DOUBLE );
-- Insert sample data into the table INSERT INTO SampleTable VALUES ('2023-05-31', 1.5, 2.3, 3.1, 4.2, 100, 200, 60, 80, 20, 70, 30, 90, 500, 85, 'Sample Source', 0.8, 1.2, 2.5, 3.8, 7.2, 0.5, 5.5, 600);
-- Query the sample data SELECT * FROM SampleTable;