Mega Code Archive

 

Categories / MySQL / View

 

Create view for user information

CREATE USER 'DIANE'@'localhost' IDENTIFIED BY 'SECRET' ; CREATE   VIEW NAME_ADDRESS AS SELECT   NAME, INITIALS, STREET, HOUSENO,          TOWN FROM     PLAYERS WHERE    LEAGUENO IS NULL ; GRANT   SELECT ON      NAME_ADDRESS TO      DIANE