Database ( DB )/Database

mysql drop table, create table (with auto_increment)

노루아부지 2019. 8. 4. 23:00

DROP TABLE IF EXISTS server_user;
CREATE TABLE server_user
(
server_user_id INTEGER NOT NULL AUTO_INCREMENT,
server_id INTEGER NOT NULL,
customer_user_id INTEGER NOT NULL,
reg_date INTEGER NOT NULL,
PRIMARY KEY (`server_user_id`,`server_id`,`customer_user_id`)
);

728x90
loading