Devart Forum

Код: Выделить всё

CREATE TABLE IF NOT EXISTS `myview` (
`id` int(11)
,`number` int(11)
,`uploadstamp` datetime
,`author` varchar(25)
,`updatestamp` datetime
);

...

DROP TABLE IF EXISTS `myview`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `myview` AS SELECT
`a`.`id` AS `id`,
`a`.`number` AS `number`,
`a`.`uploadstamp` AS `uploadstamp`,
`a`.`author` AS `author`,
`a`.`updatestamp` AS `updatestamp`
FROM maintable;