why this code is not working in sql/phpmyadmin?

CREATE TABLE D5EMPS LIKE EMPLOYEE (SELECT E.* FROM EMPLOYEE AS E WHERE E.Dno=5) WITH DATA;