Shulou(Shulou.com)05/31 Report--

This article will explain in detail what the core operation of the database is. Xiaobian thinks it is quite practical, so share it with you for reference. I hope you can gain something after reading this article.

The core of the database is also the most commonly used operation is to add, delete and modify the search.

database

Query databases: show databases;

Create database: create database name;

Delete database: drop database name

table

Create table: create table table name (field name data type [attribute][index])

View table structure: desc table name

View table: show tables

insert data into table name value()

View create table information: show create table table name

View the table for the specified library: show tables where target library name

field

Add: alter table table name add field name data type [attribute][index]

Insert a field after the specified position: alter table table name add field name data type [attribute][index] after the specified field name

Insert to the first position: alter table table name add field name data type [attribute][index] first

Delete: alter table name drop field name

Modify: alter table table name change old field new field data type [attribute][index]

Conditional statement: >

= 5 having is re-screening on the basis of aggregation

Group queries are typically used with aggregate queries

About "what is the core operation of the database" this article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.

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.