When adding data, you can optionally use fields to add data, values The value set later must be consistent with the type of the increased field quantityġ.2 Code example /* notes ： Single-line comments # perhaps - Multiline comment /*123*/ * / # Add student information : The complete syntax uses INSERT INTO Insert grammar ： insert Table name (col ,col2 ,col3.
Transaction control language （TCL Transcation Cnontrol language） adopt COMMIT、SAVEPOINT、ROLLBACK Order to ensure that DML All rows of the table affected by the statement are updated in time.
ĭata query language (DQL Data Query Language) Query the data in the tableĭata operation language (DML Data Manipulation Language) Add data to the table 、 Modify and delete operationsĭata control language (DCL Data Control language) adopt GRANT or REVOKE Keyword to achieve authority control. ĭata definition language (DDL Data Definition Language) Create a database or table 、 Modify and delete operations.
#Sql 2012 express max database size update#
Structured query language (Structured Query Language) abbreviation SQL, Is a special purpose programming language, Is a database query and programming language, For data access and query 、 Update and manage relational database system.Sql It is a language specialized in adding, deleting, modifying and querying databases.
0 kommentar(er)
