I want to become a full stack developer and i choose mysql as database for my project. How can i create database using mysql workbench ,can anyone show creation of database using mysql with few examples..
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people's questions, and connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Pooja Jakhar
To create database in MySQL, following prerequisites are required –
Now, follow these steps –
That’s all you need to do to create database in My SQL.
Hope this will help you!
Janhavi
Database creation in mysql with examples easy
Creating a new database using MySQL means executing the database as a directory to store all your files in a table format.
My Sql Database creation is as follows
In MySQL Workbench, click on the “create a new schema in the connected server” icon which can be found on the toolbar.
Enter your schema name and the default collation. At the bottom, click on the “Apply” button.
The next window opens where you are made to review the SQL statement that will run to create the new database. Click “Apply”.
Here, the following statement shows:
CREATE SCHEMA ‘database_name’ DEFAULT CHARACTER SET ‘characterset_name’
You will be able to view your new database listed under the SCHEMAS tab on the left pane.