Code Poet

1. some words you should know: SQL : Structured Query Language DDL: Data Definition Language DML: Data Manipulation Language DCL: Data Control Language TPL: Transaction Processing Language Attribute:...

SQL 数据基本定义功能 – 模式（Schema） 1.create schema CREATE SCHEMA <schemaName> AUTHORIZATION <username> eg: Create shcema "student_course" authorization sheepcore CREATE SCHEMA <schemaName&...

SQL 基本建表语句 1. Create Table CREATE TABLE sample_table ( column1 data_type(size) constraint_name, column2 data_type(size) constraint_name, column3 data_type(size) constraint_name, .... ); sample_table:...