ALTER TABLE
Example
ALTER TABLE demo RENAME TO demo_new-- rename table
ALTER TABLE demo RENAME COLUMN hint TO info-- rename column-- add new column and remove column:CREATE TABLE _tmp (id integer primary key, name VARCHAR(20), tag INTEGER NOT NULL DEFAULT 0, newtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP);-- create new table INSERT INTO _tmp(name) SELECT name FROM demo;-- move dataDROP TABLE demo;-- remove old tableALTER TABLE _tmp RENAME TO demo;-- rename new table Chart for Data Science
-- Change first word "SELECT" to "LINE-SELECT"
SELECT LINE-SELECT
-- labels - first column
-- values - all columns 2..N
-- color column key - "_c": name_cFF00FF (HEX6)
-- Example :
LINE-SELECT name as label, cos(id) as cos_c1ab394, sin(id) as sin_cFF0000 FROM demo;
-- Example :
AREA-SELECT id as x, id as y FROM demo;
-- Example :
BAR-SELECT name as label, id as y FROM demo;
-- Example :
PIE-SELECT name as label, id as y FROM demo;