By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SET @moneyD = 6;
SET @priceM = 18;
SET @sql = CONCAT('CREATE TABLE `test_SymbolChart` (
`symbolChartId` BINARY(16) NOT NULL,
`symbolId` BINARY(16) NOT NULL,
`date` TIMESTAMP NOT NULL,
`open` DECIMAL(', @priceM, ',', @moneyD, ') NULL,
`high` DECIMAL(', @priceM, ',', @moneyD, ') NULL,
`low` DECIMAL(', @priceM, ',', @moneyD, ') NULL,
`close` DECIMAL(', @priceM, ',', @moneyD, ') NULL,
`volume` INT NULL,
`dateCreated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`symbolChartId`),
INDEX `symbolIdIndex` (`symbolId` ASC)
)')
PREPARE stmt FROM @sql
EXECUTE stmt
SHOW CREATE TABLE test_SymbolChart
| Table | Create Table |
|---|---|
| test_SymbolChart | CREATE TABLE `test_SymbolChart` ( `symbolChartId` binary(16) NOT NULL, `symbolId` binary(16) NOT NULL, `date` timestamp NOT NULL, `open` decimal(18,6) DEFAULT NULL, `high` decimal(18,6) DEFAULT NULL, `low` decimal(18,6) DEFAULT NULL, `close` decimal(18,6) DEFAULT NULL, `volume` int(11) DEFAULT NULL, `dateCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`symbolChartId`), KEY `symbolIdIndex` (`symbolId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |