Regular Change Operations
Change operations on schemas and data of tables
This section describes the supported change operations on schemas and data of tables.
Create tables using the same schema
- Execute a
CREATE TABLE
statement to create a StoneDB table.
Code example:
CREATE TABLE t_name(
col1 INT NOT NULL AUTO_INCREMENT,
col2 VARCHAR(10) NOT NULL,
......
PRIMARY KEY (`col1`)
) engine=stonedb;
The column-based storage engine is named after StoneDB in StoneDB-5.6, and is renamed to Tianmu in StoneDB-5.7 to distinguish from the database StoneDB.
Execute a
CREATE TABLE ... LIKE
statement to create another table that uses the same schema as the table created in the step 1.Code example:
create table t_other like t_name;
Clear data in a table
Execute a TRUNCATE TABLE
statement to clear data in a table and retain the table schema.
Code example:
truncate table t_name;
Drop a table
Code example:
drop table t_name;
Add a field
Execute an ALTER TABLE ... ADD COLUMN
statement to add a field in a given table. The added field is the last field, by default.
Code example:
alter table t_name add column c_name varchar(10);
Drop a field
Execute an ALTER TABLE ... DROP
statement to drop a field from a table.
Code example:
alter table t_name drop c_name;
Rename a table
Execute an ALTER TABLE ... RENAME TO
statement to rename a given table.
Code example:
alter table t_name rename to t_name_new;
Change operations on user permissions
Create a user
Code example:
create user 'u_name'@'hostname' identified by 'xxx';
Grant user permissions
Code example:
grant all on *.* to 'u_name'@'hostname';
grant select on db_name.* to 'u_name'@'hostname';
grant select(column_name) on db_name.t_name to 'u_name'@'hostname';
Revoke permissions
Code example:
revoke all privileges on *.* from 'u_name'@'hostname';
revoke select on db_name.* from 'u_name'@'hostname';
revoke select(column_name) on db_name.t_name from 'u_name'@'hostname';
Drop a user
Code example:
drop user 'u_name'@'hostname';