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
DROP TABLE IF EXISTS `Проверяемый%ПЕРС`; CREATE TABLE `Проверяемый%ПЕРС` ( `Код` CHAR (10) NOT NULL PRIMARY KEY , `Паспорт` CHAR (10) NOT NULL UNIQUE , `ФИО` VARCHAR (50) NOT NULL , `Сведения` CHAR (3) NOT NULL , `Слк_ДОЛ` CHAR (3) NOT NULL , `Код_ДОЛ` CHAR (3) NOT NULL , CONSTRAINT `ВК1\ПРМ^СПР` FOREIGN KEY (`Слк_ДОЛ`, `Код_ДОЛ`) REFERENCES `Справка+` (`Слк`, `Код`) ); INSERT INTO `Проверяемый%ПЕРС` VALUES ("001", "567423", "Петренко И.А", "шатен", "ДОЛ", "11"), ("002", "852374", "Ильясов П.И", "блондин","ДОЛ", "12"); SELECT "`Проверяемый%ПЕРС` Table Content:" FROM `Проверяемый%ПЕРС` WHERE 1=0; SELECT * FROM `Проверяемый%ПЕРС`;

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

Copy Clear