Consultation on creating views in CnosDB

7 Views Asked by At

MySQL:

-- Create
CREATE VIEW employee_view AS
SELECT id, name, department
FROM employees
WHERE department = 'IT';

-- Select
SELECT * FROM employee_view;

-- Update
CREATE OR REPLACE VIEW employee_view AS
SELECT id, name, department
FROM employees
WHERE department = 'HR';

-- Drop
DROP VIEW employee_view;

How is the view feature implemented in CnosDB? Please provide documentation or examples. Thank you.

0

There are 0 best solutions below