[Database] MySQL sql 노가다로 테이블 생성해보기

Yeon Jeffrey Seo·2022년 3월 14일
0

데이터베이스

목록 보기
3/6
CREATE TABLE SmsLog (
id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, 
message TEXT, 
message_length INTEGER, 
sender VARCHAR(20), 
receiver VARCHAR(20), 
is_lms TINYINT, 
merchant_id VARCHAR(50), 
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
profile
The best time to plant a tree was twenty years ago. The second best time is now.

0개의 댓글