I am trying to create a VIEW table in Mysql which is read only.
This is fine with;
Code: Select all
CREATE VIEW v_member AS
SELECT *
FROM memberIs there a way to create a VIEW table where you can alter the column datatype? I.e a field called start_date that is type DATE in "member" table will be mirror'd in table v_member, but the corresponding field in there will be type CHAR instead?
Apologies if that makes no sense! Any help would be much appreciated!