SQLize Online / PHPize Online  /  SQLtest Online

DROP TABLE IF EXISTS `Гриф\ОРГ`; CREATE TABLE `Гриф\ОРГ` ( `Код\ОРГ` INT (50) NOT NULL, `Регномер` INT (50) NOT NULL, `Дата` DATE (50) NOT NULL, `Слк\СПР` INT (3) NOT NULL, `Код\СПР` INT (50) NOT NULL, CONSTRAINT `ПК\ГРИ` PRIMARY KEY ( `Код\ОРГ`, `Регномер` ), CONSTRAINT `ВК\ОРГ` FOREIGN KEY (`Код\ОРГ`) REFERENCES `Организация` (`Код`), CONSTRAINT `ВК\СПР` FOREIGN KEY ( `Слк\СПР`, `Код\СПР` ) REFERENCES `Справочник` (`Слк`, `Код`) ); INSERT INTO `Гриф\ОРГ` VALUES ( "23", "123456", "14.05.2022", "2", "123456" ), ( "23", "234567", "3.08.2032", "2", "234567" ); SELECT "`Гриф\ОРГ` Table Content:" FROM `Гриф\ОРГ` WHERE 1 = 0; SELECT * FROM `Гриф\ОРГ`;