Shulou(Shulou.com)06/02 Report--

This article mainly introduces "what are the essential SQL commands of the Linux system". In the daily operation, I believe that many people have doubts about the necessary SQL commands of the Linux system. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "what are the essential SQL commands of the Linux system?" Next, please follow the editor to study!

Database and SQL

Flat text files may be suitable for relatively small amounts of data, but they are not very helpful in storing large amounts of data or querying that data. Over the years, a variety of databases have been developed for this purpose, including hierarchical and network databases, but now the most common are relational databases. Relational databases are based on the idea of E. F. Codd, who works for IBM ®, who published an original paper, "A Relational data Model for large shared data Banks" in 1970. There are a variety of relational database systems today, including commercial products (such as IBM DB2 ®, IBM Informix ®, and Oracle Database) and open source projects (such as MySQL, PostgreSQL SQLite, and MariaDB [a branch of MySQL]). Relational databases use SQL as the data definition and query language.

prerequisite

To get the most from this series of tutorials, you should have a basic knowledge of Linux and a working Linux system on which you can practice the commands covered in this tutorial. You should be familiar with GNU and UNIX ®commands. Sometimes, different versions of a program format the output in different ways, so your results may not always be exactly the same as the list given here.

For this tutorial, you need a database (such as MariaDB) and documentation for your database.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.