MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
#管理員MANAGER 
CREATE TABLE MANAGER_seq ( 
MG_no INT NOT NULL AUTO_INCREMENT PRIMARY KEY );
CREATE TABLE MANAGER (
MG_no VARCHAR(20) NOT NULL PRIMARY KEY DEFAULT '0', 
MG_email VARCHAR(20) NOT NULL, 
MG_password VARCHAR(20) NOT NULL, 
MG_name VARCHAR(20) NOT NULL, 
MG_title VARCHAR(20) NOT NULL, 
MG_spec VARCHAR(45), Line_id VARCHAR(20) , 
Line_url VARCHAR(20) , 
MG_createtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, 
MG_updatetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL);
INSERT INTO MANAGER (MG_email, MG_password, MG_name, MG_title, MG_spec, Line_id, Line_url) 
VALUES ('bbosstw@gmail.com', 'aa4731073', '大翔', '老闆', '', 'siang5032', ''); 
INSERT INTO MANAGER (MG_email, MG_password, MG_name, MG_title, MG_spec, Line_id, Line_url) 
VALUES ('123456@gmail.com', '123456', '小翔', '小編', '', '', '');
Duplicate entry '0' for key 'MANAGER.PRIMARY'

SELECT *
FROM MANAGER


MG_no
MG_email
MG_password
MG_name
MG_title
MG_spec
Line_id
Line_url
MG_createtime
MG_updatetime


0
bbosstw@gmail.com
aa4731073
大翔
老闆

siang5032

2021-10-20 07:53:50
2021-10-20 07:53:50