cindyopenDatabase Logical ArchitectureData nodes (DNs) in openGauss store data on disks. This section describes the objects on each DN from the logical view and the…Apr 14, 2023Apr 14, 2023
cindyBasic ConceptsopenGauss is a relational database management system (RDBMS). A relational database organizes data using a relational model, that is, data…Apr 14, 2023Apr 14, 2023
cindyDELETE StatementThe DELETE statement can be executed to delete rows that satisfy the WHERE clause from a specified table. If the WHERE clause does not…Apr 14, 2023Apr 14, 2023
cindyUPDATE StatementExisting data in a database can be updated. You can update one row, all rows, or specified rows of data, or update data in a single column…Apr 14, 2023Apr 14, 2023
cindyCreating a TableCreate an empty table in the current database. The table will be owned by the creator. The same table can be stored in different databases…Apr 14, 2023Apr 14, 2023
cindyopenGauss DISTINCTThe DISTINCT keyword is used together with the SELECT statement to remove duplicate records and obtain only unique records.Apr 14, 2023Apr 14, 2023
cindyopenGauss GROUP BY ClauseThe GROUP BY clause is used together with the SELECT statement to group the same data. You can group one or more columns, but the columns…Apr 14, 2023Apr 14, 2023