SQLize Online / PHPize Online

A A A
Share   Donate   Blog   Popular
Copy Format Clear
DROP TABLE IF EXISTS `Клиент%ПЕРС`; CREATE TABLE `Клиент%ПЕРС` ( `Код` CHAR (50) NOT NULL , `Код категории` CHAR (50) NOT NULL , `Слк` CHAR(3) NOT NULL , `Паспорт` int (50) NOT NULL , `ФИО` VARCHAR (50) NOT NULL , CONSTRAINT `ПК\КЛИП` PRIMARY KEY (`Код`) , CONSTRAINT `ВК\СПР` FOREIGN KEY (`Код\СПР`, `Слк\СПР`) REFERENCES `Справочник` (`Код`, `Слк`) ); INSERT INTO `Клиент%ПЕРС` VALUES ("1", "1", "123", "20153000", "Барашкин А.А."), ("2", "2", "231", "20153000", "Конев К.А."), ("3", "3", "321", "20153000", "Петров К.П."); SELECT "`Клиент%ПЕРС` Table Content:" FROM `Клиент%ПЕРС` WHERE 1=0; SELECT * FROM `Клиент%ПЕРС`;
Stuck with a problem? Need help? Ask professionals on our Telegram channel!
Join the channel
Your quersion is posted.
Join our Telegram channel and get answers.
Send
Copy