First, Introductionsql,structured query Language, structured querying language. SQL is used to access and manipulate the database. SQL is the American standard of database language adopted by the American National Standards Institute (AMERICAN) (Institute,ansi). —————————————————————————
second, what can be done1. You can create a new database 2. New Table 3 can be created in the database. You can insert a new record in the database 4. Record 5 can be deleted from the database. You can update data in the database by 6. Query 7 can be executed against the database. Data can be retrieved from the database 8. You can create stored procedure 9 in the database. View 10 can be created in the database. You can set permissions on tables, stored procedures, and views —————————————————————————
Three, there are many different versions of the SQL languageDatabase Company for the performance of their products, characteristics and other aspects of the support of the SQL language is different, some may extend the standards, which led to many different versions of the SQL language. However, to be compatible with ANSI standards, database companies must work together in a similar way to support key keywords such as SELECT, UPDATE, DELETE, INSERT, WHERE, and so on. —————————————————————————
Iv. RDBMSRdbms,relational database Management system, which is the relational databases management systems. The RDBMS is the foundation of SQL and is also the foundation of all modern database systems, such as MS SQL server,ibm db2,oracle,mysql and Microsoft Access. Data in an RDBMS is stored in a database object called a table (tables). A table is a collection of related data items that consists of columns and rows. —————————————————————————
v. Reference links1. W3school SQL Introduction (end)
What is SQL?
