What are the basic operation commands of the database?

This article introduces the relevant knowledge of "what are the basic operation commands of the database". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. The common commands of MySQL are as follows:

Create database name; creates a database

Use databasename; Select Database

Drop database name deletes the database directly without reminding you

Show tables; display table

Detailed description of the describe tablename; table

Add distinct to select to remove duplicate fields

Mysqladmin drop databasename is prompted before deleting the database.

Displays the current mysql version and current date

Select version (), current_date

2. The common commands of MongoDB are as follows:

Db.help (); Help view command prompts

Use yourDB; switch / create database

Show dbs; queries all databases

Db.dropDatabase (); delete the currently used database

Db.getName (); view the database currently in use

Db.version (); current db version

Db.addUser ("name"); add users

Db.addUser ("userName", "pwd123", true)

Show users; displays all current users

Db.removeUser ("userName"); delete user

Db.yourColl.count (); query the number of data items in the current collection

This is the end of the content of "what are the basic operation commands of the database". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!