SQL language Statement

Source: Internet
Author: User

Before we talk about the SQL language, we first define the contents of a small sales company relational database that contains the following relational tables:

▲office table. The columns of the table are: Office,city,region,mgr,target and sales, respectively, the department number, the city name of the sales office, the region name of the sales office, the Sales manager number, the sales department's target, and the sales department.

▲salesreps table. The columns of the table are: Empl--num,name,age,rep_office,title,hire_date,manager,quota and sales, respectively, the name of the sale office, the date of hire, the number of the salesperson's person, Sales staff quota and sales staff sales.

▲orders table. The columns of the table are: Order_num,order_date,cust,rep,mfr,product,qty and amout; The order number, the order date, the customer number, the sales department number, the manufacturer number, the product model number, the product quantity and the order amount.

1.SQL data Query statement

2.sql Data Add statement

3.sql Data Deletion statement

4.sql Data Modification Statement

5.SQL Database Structure Action statement

6.sql View Action Statement

7.sql Security Action Statement

8.sql Transaction Processing

References: SQL language tutorials SQL language basics

Back to the database basics ABC Directory

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.