[jitebi]

You are too fast 😀

I was just editing my post cause i wrote

TRIGGER but really i was speaking about VIEWS

I'm using sqlyog 5.16 community version

An example:

DROP TABLE IF EXISTS `view_name`;

DROP VIEW IF EXISTS `view_name`;

CREATE TABLE `view_name` (

`ID` bigint(21) NOT NULL default '0',

`NYear` bigint(4) default NULL,

`NMonth` bigint(2) default NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

When i import the SQL statment generated by sqlyog

i don't find my views but only equivalent tables.

Thank you for your speed

C.

[Author]

Posts