Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
Copy Format Clear
CREATE TABLE TEST_TABLE (col_1_SMALLINT SMALLINT, col_2_FLOAT FLOAT); INSERT INTO TEST_TABLE (col_1_SMALLINT, col_2_FLOAT) VALUES (-0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000760758397609034, 0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000411124425066974); INSERT INTO TEST_TABLE (col_1_SMALLINT, col_2_FLOAT) VALUES (0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000315598177965245, 0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000895166828752146); INSERT INTO TEST_TABLE (col_1_SMALLINT, col_2_FLOAT) VALUES (-0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000239413671821167, 0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000348515970655390); INSERT INTO TEST_TABLE (col_1_SMALLINT, col_2_FLOAT) VALUES (0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000300961661143483, -0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000248058097616209); INSERT INTO TEST_TABLE (col_1_SMALLINT, col_2_FLOAT) VALUES (-0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000094075973497660, 0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000943039733477705); INSERT INTO TEST_TABLE (col_1_SMALLINT, col_2_FLOAT) VALUES (-0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000352776587359125, -0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000650425782634107); INSERT INTO TEST_TABLE (col_1_SMALLINT, col_2_FLOAT) VALUES (NULL, 2354345); SELECT CONCAT(col_1_SMALLINT,col_2_FLOAT) FROM TEST_TABLE; SELECT col_1_SMALLINT*col_2_FLOAT FROM TEST_TABLE; DROP TABLE TEST_TABLE;

Stuck with a problem? Got Error? Ask AI support!

Copy Clear