SQL SERVER OPERATION



insert into Table1 values ('1','aaa','a');

insert into Table1 values('2','bbb','b');

insert into Table1 values('3','ccc','c');

select * from Table1 where Table1.user_id=1;

insert into Table2 values('1','111000');

insert into Table2 values('2','000111');

insert into Table2 values('3','22222');

select * from Table2;

update Table2 set user_power='uptadtTo333' where user_id=2;

delete Table2 where user_id='3';

insert into Table2 values('4','44444');

update Table2 set user_id=5 where user_id=3;

update Table2 set user_power=5555 where user_id=5;

delete from Table2 where user_id=5;

select COUNT(*) from (select * from table1 a inner join table2 b on a.user_id=b.user_id);

/*inner join*/

select Table1.user_id,Table1.user_name,Table1.user_pss,Table2.user_power from Table1 inner join Table2 on Table1.user_id=Table2.user_id;

/*left join*/

select * from Table1 left join Table2 on Table1.user_id=Table2.user_id;

/*right join*/

select * from Table1 right join Table2 on Table1.user_id=Table2.user_id;

/*full join*/

select * from Table1 full join Table2 on Table1.user_id=Table2.user_id;