Under Windows, if your MySQL is installed in D:MySQL, you can do this:
1. First switch to its bin directory
|
1 |
|
|
1 |
|
2. Then enter your root password
Next, you can create databases, create users, create and modify tables and other operations (common commands are as follows).
3. View existing database
|
1 |
|
mysql creates a database (if the database is named mydb)
|
1 |
|
Delete the database (if the database is named mydb)
|
1 |
|
Use database (if using database mydb)
|
1 |
|
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, and a table is equivalent to the cells of the Excel file, and the data is stored in the table.
