MySQL Database Basics (iii)--sql Language I. Introduction to SQL 1. Introduction to SQL languageSQL is a Structured Query language (structured Query Language), which is the standard computer language for accessing and working with databases.The
1. OverviewSQL is a database-oriented structured Query language. is a computer standard language that conforms to ANSI, the national standardization organization of the United States.SQL has the operation of the database: adding and deleting changes.
One or more rows into a column (and separated by ",")Table Name: ATable data:Desired Query Results:Query statement:Select Name, value = (STUFF (select ', ' + value from A WHERE name = Test.name
Pivot is used to rotate column values to column names (row to column)Grammar:Table_sourcepivot (Aggregation function (value_column) for Pivot_columnin ())Unpivot used to set the column value to a column (that is, a column
First, log on to oraclesqlplussysbjsxtassysdba as a super administrator and then remove the alteruserscot lock on scott users.
First, log on to oracle sqlplus sys/bjsxt as sysdba as a super administrator and then remove the alter user scot lock on
First, log on to Oracle as a super AdministratorSqlplus sys/bjsxt as sysdbaThen, unlock the scott user.Alter user scott account unlock;Then the user name can be used.(Default Global Database Name orcl)1. select ename, sal * 12 from emp; // calculate
I. multiple choice questions
1. SQL is a () language that is easy to learn.
A. Procedural B. Non-procedural
C. Format D. Navigation
2. Data manipulation statements in SQL include select, insert, update, and delete. The most important and
[TOC]I. Variables 1. Declaring variablesA variable is a name for a piece of data storage space, and the program can request a chunk of data storage by defining a variable, which can then be used by referencing the variable
Before installation, we recommend that you check the source code package description readme. For version 4.0/4.1, refer to version 3.2 for installation. The steps are the same. For problems, see the detailed installation instructions. # Download
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.