Joke Collection Website - Joke collection - What kind of database is sql?

What kind of database is sql?

SQL is a relational database.

SQL (Structured Query Language) is a database query and programming language, which is used to access data, query, update and manage relational database systems. It is also an extension of the database script file.

SQL is an advanced non-procedural programming language, which allows users to work on advanced data structures. It does not require users to specify the storage mode of data, nor does it require users to know the specific storage mode of data, so different database systems with completely different underlying structures can use the same SQL language as SQL for data input and management.

Interface. It takes the recordset as the operation object, and all SQL statements accept it as input and return it as output. This set feature allows the output of one SQL statement as the input of another, so SQL statements can be nested, which makes it very flexible and powerful. In most cases, in other languages, functions that need a long program can be realized by only one SQL statement, which means that very complicated statements can also be written in SQL language. Structured query language was originally developed by IBM's San Jose research laboratory for its relational database management system SYSTEM R, and its predecessor was SQUARE language. SQL language is simple in structure, powerful in function and easy to learn, so it has been widely used since 198 1 was introduced by IBM in. Now, both large database management systems such as Oracle, Sybase, DB2, Informix and SQL Server, and database development systems commonly used on PCs such as Visual Foxpro and PowerBuilder support SQL as the query language. The American National Bureau of Standards (ANSI) and the International Organization for Standardization (ISO) formulated the SQL standard. ANSI is an American industrial and commercial organization, which is responsible for formulating American business and communication standards. ANSI is also a member of ISO and IEC. ANSI publishes American standards corresponding to international standards organizations. In 1992, ISO and IEC published the international standard of SQL, called SQL-92. The corresponding standard issued by ANSI is ANSI SQL-92. ANSI SQL-92 is sometimes called ANSI SQL. Although there are some differences in SQL versions used by different relational databases, most of them follow ANSI SQL standards. SQL Server uses an extended set of ANSI SQL-92, called T-SQL, which follows the SQL-92 standard formulated by ANSI. SQL language consists of four parts: ※ Data Definition Language (DDL), such as CREATE, DROP, ALTER and other statements. Data manipulation languages (DML), such as INSERT, UPDATE and DELETE statements. ※ .※ Data query language (DQL), such as SELECT statement. Data control language (DCL), such as authorization, revocation, submission and rollback. ※.SQL language includes statements in three main programming languages: data definition language (DDL), data manipulation language (DML) and data control language (DCL). SQL is a standard computer language for accessing and processing databases. SQL refers to the structured query language, which enables us to access the database. SQL is an ANSI standard computer language.