Simple MySQL database operations

Simple MySQL database operations
1. Create a database

Use the show databases command to display the names of all created databases.
Create Database xxx; Create a database named XXX.

For example, mysql> Create Database test;

 

Ii. Create a form

Create Table XXX ();

For example:

Then you can run the DESC command to view the form:

For example:

3. insert data

Insert into XXX values (,); to complete the Insert Process. Then, run the SELECT command to view the specific information of the form.

For example:

4. Update Data

Update XXX set xx = xx where xx = xx; To update the form.

For example:

5. delete data

Use the delete from XXX Where xx = xx; command to delete data.

For example:

6. delete a database

Drop database xxx; to delete a database.

For example: