Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Basic operation of oracle

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Structural operation on the table

Add increase

Alter table table name drop (column character type (length)); delete

Modify reform

Desc dept; look-up table structure

Operation on record

Select column name from table name where condition lookup

Update student set column = "" where condition change

Delete from table name where conditional deletion (only delete records without deleting table structure)

Maximum value of max ()

The minimum value of function min ()

Average of avg ()

Total value of count ()

Associated database query

Select column name, column name from Table 1, Table 2 where Primary key = Foreign key and condition

Select column name, column name from Table 1 where Table 1 Primary key = (select Table 2 Foreign key from

Table 2 where conditions)

What does the like character% begin with

Order by sorting

Group by column name having condition according to what grouping statistics is in use having restriction condition

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report