728x90 반응형 mysql alter1 [MYSQL/Database] 실습 alter, rename, view 생성 view생성하기 create veiw [view name] as 조건 create database testdb; use testdb; create table t_user( c_ID int primary key auto_increment comment '유저 고유 아이디', c_name char(20) not null comment '유저이름' )comment '유저 테이블'; SELECT table_name, table_comment FROM information_schema.tables WHERE table_schema = 'testdb' AND table_name = 't_user'; SELECT table_name, column_name, column_comment FROM information_s.. 2023. 4. 11. 이전 1 다음 728x90 반응형
