MYSQL系统语句(ORACLE, DB2, SQLSERVER应该也有类似的SQL):
1. 查找系统表:
1.1 SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'big_data_haishi'
2. 查找系统字段:
2.1 SELECT T.* FROM information_schema.columns T where table_schema='big_data_haishi'
3. 修改表的列名:
3.1 alter table 表名 change 列名 新的列名 int;
4. 删除表的某一列
4.1 alter table 表名 drop column 列名;
5. 添加表的某一列
5.1 alter table tableName add column columnName varchar(32) default 'helloworld';
6. 查询数据库中所有表名
select table_name from information_schema.tables where table_schema='csdb' and table_type='base table';
7. 获取表里面的所有字段
select column_name from information_schema.columns where table_schema='csdb' and table_name='users'
8. 修改默认值:
ALTER TABLE table_name ALTER COLUMN column_name SET DEFAULT 'default_value';
9. load数据
load data local infile 'E:/test.csv' into table rules fields terminated by '##' lines terminated by '$$';