CREATE SCHEMA IN MYSQL

Question

I have used the Create Schema in mySQL. But it act as a separate database. It doesn't affect the already created Databaase. How to create Schema in mySQL within an particular database in mySQL and need to group the tables within a schema.?

Can anyone know about this pls...??

score 2 · Answer 1 · edited May 23 '17 at 11:57

2

I believe from recent experience and from a quick Google on the subject that a Schema IS a database in MySQL unlike other databases where the two are different. See the following links:

MySQL 'create schema' and 'create database' - Is there any difference

http://lists.mysql.com/mysql/211616

edited May 23 '17 at 11:57

Community

1
1

answered Oct 22 '12 at 15:09

Daniel Casserly

3,552
2
29
60

score 1 · Answer 2 · edited Oct 22 '12 at 15:45

1

You can use CREATE SCHEMA/CREATE DATABASE and the USE dbname.

edited Oct 22 '12 at 15:45

Devart

119,203
23
166
186

answered Oct 22 '12 at 15:09

Mihai Stancu

15,848
2
33
51

1

i used the below codes to create schema in mysql mysql> CREATE USER 'some_user'@'localhost' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON databasename.* TO 'some_user'@'localhost' WITH GRANT OPTION; – Bharathiraja Aug 02 '14 at 05:15

CREATE SCHEMA IN MYSQL

2 Answers2