数据库操作

数据库操作

1数据库

Mysql

oracle

 

2工具navicat

3新建表

 

4Datafactory数据工厂

 

 

 

 

 

 

5增删改查

 

 

--  查询所有列

SELECT * FROM vlookup where xm='mrh60' ;

-- 查询单独列

SELECT xm FROM vlookup where xm='mrh60' ;

-- 删除一列

DELETE from vlookup  where xm='mrh60' ;

--  删除整张表数据

DELETE from vlookup

-- 插入一条数据

INSERT into vlookup(gh,xm,sfzh,sbh) VALUES('1','2','3','4');

INSERT into vlookup(gh,xm,sfzh,sbh) VALUES('5','6','7','8');

-- 修改

 UPDATE vlookup SET xm = '马瑞华',sfzh='88888888888' WHERE gh = '1';