Developer Cafe

1. 테스트용으로 두 테이블을 생성한다. CREATE TABLE parent ( pid INT AUTO_INCREMENT NOT NULL, name varchar(5), PRIMARY KEY(pid) ) ENGINE = InnoDB; CREATE TABLE child ( pid INT AUTO_INCREMENT PRIMARY KEY, parent_pid INT NOT NULL, title varchar(100), INDEX(parent_pid), FOREIGN KEY(parent_pid) REFERENCES parent(pid) ) ENGINE = InnoDB; 2. 제대로 들어가는지 테스트한다 INSERT INTO parent(name) VALUES('test'); INSERT INTO child(pa..

the server time zone value ' ѹα ǥ ؽ ' is unrecognized or represents more than one time zone. you must configure either the server or jdbc driver (via the servertimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support. SELECT @@GLOBAL.time_zone, @@SESSION.time_zone; SET GLOBAL time_zone = '+9:00'; # 권한 필요 SET time_zone = '+9:00';

ALTER TABLE `workspace`.`task` CHANGE COLUMN `updated_at` `updated_at` datetime ON UPDATE CURRENT_TIMESTAMP COMMENT '업데이트 일자';