数据库增删改命令 分类笔记

注一下所有命令都在postgresql下验证过

数据库
1创建
create database database_name;

2删除
drop database database_name;

3重命名
alter database database_name 
rename to new_database_name;

表
1创建
create table table_name
(
id  serial primary key not null,
column_name varchar(255),

not null, unique, primary key, foreign key, check, default
);

2删除
drop table table_name;

3重命名
alter table table_name 
rename to new_table_name;

字段
1添加字段
alter table table_name 
add column column_name datatype;

2删除字段
alter table table_name
drop column column_name;

3重命名字段
alter table table_name
rename column column_name to new_column_name;

4修改字段数据类型
alter table table_name
alter column column_name type datatype;

索引
1创建索引
create index index_name 
on table_name(column_name, column_name);

2删除索引
drop index index_name;

3重命名索引
alter index index_name
rename to new_index_name;

视图
1创建视图
create view view_name
as 一条select的搜索语句

2删除视图
drop view view_name

3重命名视图
alter view view_name rename to new_view_name;

数据
1插入数据
insert into table_name (column_name, column_name, ...)
values(value1, value2, ....);

2删除数据
delete from table_name
where column_name = value;

3更新数据
update table_name
set column_name = value
where column_name = value;