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(150) NOT NULL, `Сведения` VARCHAR(150) NOT NULL, `Слк_ДОЛ` CHAR(3) NOT NULL, `Код_ДОЛ` CHAR(3) NOT NULL, CONSTRAINT `ВК1\СОТ^СПР` UNIQUE (`Слк_ДОЛ`, `Код_ДОЛ`) ); INSERT INTO `Проверяемый%ПЕРС` VALUES ("001-Б", "123456", "Иванов И. И.", "комсомолец", "ДОЛ", "1"), ("002-К", "234567", "Сидоров С. С.", "беспартийный", "ДОЛ", "2"); SELECT "`Проверяемый%ПЕРС` Table Content:" FROM `Проверяемый%ПЕРС` WHERE 1=0; SELECT * FROM `Проверяемый%ПЕРС`

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

Copy Clear