[Fengma family _ mysql] basic mysql commands, _ mysqlmysql

[Fengma family _ mysql] basic mysql commands, _ mysqlmysql

Common database commands:

Show Database

Delete Database

Connect to database

View the database currently connected

Common commands for Data Tables

View table

Modify Table

Delete table

Add the alter add command to add table fields.

Modify Field

Delete Field

Add Index

Delete Index

Insert data

View the data in the table // query the required data for accuracy

Mysql> select * from where the order by id limit table starts, a total of several items;

Delete table data

Modify Table Data