MySQL Logical grouping of tables I am coming from MSSQL world and learning MySQL now. I see that schema and database is same in MySQL, however these are different in MSSQL. 

I want to logically group my tables as can be done using schema in MSSQL. How can I achieve this?

Edit 1

As per comments, I can't use schema to logically group my tables. Is there any other system which I can use? Maybe using a prefix in table names?

Edit 2

My use case is, I am designing a big software which would have multiple modules. Each of the modules would have multiple tables. I want these tables segregated from each other. Although all the tables would be used for this software only, but they should be kept apart. E.g. Employee module tables should be separate from Inventory module tables.
i like to tell you in mysql , its also schema and database are different things.

schema is present under database.

means in two different database, same named schema may present.

i.e; in any one database this may possible -

create new schema sch1;
CREATE TABLE sch1.pet (name VARCHAR(20), owner VARCHAR(20),

create new schema sch2;
CREATE TABLE sch2.pet (name VARCHAR(20), owner VARCHAR(20),


in any 2nd database which having different connection ip have

above same schema  and  may possibly present..