Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to create a new mysql database

2025-01-26 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

The following brings you about how to build a new mysql database, if you are interested, let's take a look at this article. I believe it will be of some help to you after reading how to build a new mysql database.

Under Windows, if your MySQL is installed in D:\ MySQL, you can do this:

Change to its bin directory first

Cd D:\ MySQL\ bin\ D:\ MySQL\ bin > mysql-u root-p

Then enter your root password

Then you can create databases, create users, create modified tables, and so on (common commands are as follows).

View existing database

Mysql > show databases

Mysql creates the database (if the database name is mydb)

Mysql > create database mydb

Delete the database (if the database name is mydb)

Mysql > drop database accounts

Use the database (if using the database mydb)

Mysql > use mydb

After executing the database command, you can create, modify, insert, delete tables and other operations on the database. A database is equivalent to an Excel file, while a table is equivalent to the cells of an Excel file, and the data is stored in the table.

Read the details above about how to create a new mysql database, and whether you have gained anything. If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 235

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report