CREATE TABLE mytable (
    NAME VARCHAR(26) NOT NULL PRIMARY KEY
    ,City VARCHAR(10) NOT NULL
    ,EMail VARCHAR(79) NOT NULL
    ,Contact VARCHAR(33) NOT NULL
    );

INSERT INTO mytable (
    NAME
    ,City
    ,EMail
    ,Contact
    )
VALUES (
    'EFG'
    ,'Chennai'
    ,'eminent5sales@gmail.com;eminentyusuf@gmail.com'
    ,'Mr. Y'
    );

INSERT INTO mytable (
    NAME
    ,City
    ,EMail
    ,Contact
    )
VALUES (
    'ABC'
    ,'AHMEDABAD'
    ,'priyalcorporation@gmail.com'
    ,'Mr. N'
    );

INSERT INTO mytable (
    NAME
    ,City
    ,EMail
    ,Contact
    )
VALUES (
    'XYZ'
    ,'Ahemadabad'
    ,'Dhruv_Patel@milacron.co;mayur_a_patel@milacron.com;Bharat_R_Parekh@milacron.com'
    ,'Mr. J'
    );

+------+------------+------------------------------------------------+---------+
| Name |    City    |                     E-Mail                     | Contact |
+------+------------+------------------------------------------------+---------+
| EFG  | Chennai    | eminent5sales@gmail.com;eminentyusuf@gmail.com | Mr. Y   |
| EFG  | Chennai    | eminentyusuf@gmail.com                         | Mr. Y   |
| ABC  | AHMEDABAD  | priyalcorporation@gmail.com                    | Mr. N   |
| XYZ  | Ahemadabad | Dhruv_Patel@milacron.co                        | Mr. J   |
| XYZ  | Ahemadabad | mayur_a_patel@milacron.com                     | Mr. J   |
| XYZ  | Ahemadabad | Bharat_R_Parekh@milacron.com                   | Mr. J   |