본문 바로가기

SQL5

DML select distinct a as " " from A where group by having order by a desc ,b asc ; group by count() count(*) max() min() with rollup; (group by +) having count(*)>=7 ; avg(sum()) floor() inner join A A' into B B' on B' PK =A' FK; outer join 2022. 10. 7.
DML insert delete update select SELECT * FROM D; insert into D(a,b,c,d,e) values(,,,); insert into D(a,b,c,d,e) values(,,,),(,,,),(,,,),(,,,); select*from information_schema.table_constraints where constraint_schema=' ' and table_name=' '; update C set c=' ' where a=' '; delete from C where d=''; select[all|distinct] a from A [where ] [group by ] [having ] [order by ] 2022. 10. 5.
Alter -- alter table A add a varchar(); -- alter table A add(c varchar(),b varchar()); -- alter table A modify a int; -- alter table A modify a varchar() not null; -- alter table A rename colum a to b; -- alter table A change a b varchar(); -- alter table A drop column a; -- alter table A drop column a, -- b, -- c; describe A; alter table A drop constraint 외래키제목 a_c; alter table B drop constraint 외래키제.. 2022. 10. 5.
auto_increment auto_increment_offset default=1 ex> auto_increment_increment =100;\ insert into a1(b1,b2) values (0,'d;) 2022. 10. 5.

티스토리툴바