View MySQL

  1. Home
  2. MySQL
  3. View
  4. 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