--Structured Query Language (structured query Language) with a definition,--query, update and control, and other functions, is the standard language of the relational database. --SQL Classification:--Data Manipulation language DML data manipulation Language:--SELECT INSERT UPDATE DELETE--inserting values INSERT INTO t_three_killed T (t.c_pk_id, T.c_name, T.c_age, T.c_sex, T.c_country, T.c_skill) VALUES (' WEEFFFWEFG ', ' Zhao Yun ', ' 18 ', ' Male ', ' shu ', ' kill when Flash, Flash kill '); COMMIT; --updated value update t_three_killed T SET t.c_name= ' Liu San dog ', t.c_age = ' $ ', t.c_country = ' group 'WHERE t.c_pk_id= ' Sdffdssdfa '; COMMIT; --remove Delete t_three_killed T WHERE t.c_pk_id= ' SDFFDSASFA '; COMMIT; --Data Definitions Language DDL data definition language:create ALTER DROP RENAME TRUNCATE--Data Control Language DCL Data Control language:grant REVOKE--Transaction:commit rollback savepoint
Oracle Structured language Query DML DDL DCL