向表中添加默認值:create table userinfo1
2(id number(6,0),
3.regdate date default sysdate);
insert into userinfo1(id)
2 values(1);
更改默認值:alter table userinfo
modify email defauly'無”;
2(id number(6,0),
3.regdate date default sysdate);
insert into userinfo1(id)
2 values(1);
更改默認值:alter table userinfo
modify email defauly'無”;
2015-07-08
插入值:insert into userinfo
2.value(1,‘xxx’,‘123’,‘[email protected]’,sysdate);
select* from userinfo:注:*表示全部,字符串外面需要加單引號;
指定字段添加值 insert into userinfo(id,username,userpwd)
2 values(2,'yyy','123')
select username,userpwd from userinfo
2.value(1,‘xxx’,‘123’,‘[email protected]’,sysdate);
select* from userinfo:注:*表示全部,字符串外面需要加單引號;
指定字段添加值 insert into userinfo(id,username,userpwd)
2 values(2,'yyy','123')
select username,userpwd from userinfo
2015-07-08