create table match ( m_id int NOT NULL AUTO_INCREMENT, m_date datetime NOT NULL, m_hname char(30) NOT NULL, m_vname char(30) NOT NULL, m_hscore int NOT NULL, m_vscore int NOT NULL, PRIMARY KEY (m_id) )ENGINE=InnoDB;
create table `match` (m_id int aUTO_INCREMENT, m_date datetime nOT NULL, m_hname char(30) NOT NULL, m_vname char(30) NOT NULL, m_hscore int NOT NULL, m_vscore int NOT NULL, PRIMARY KEY (m_id) )ENGINE=InnoDB;注意保留字
(m_id int aUTO_INCREMENT,
m_date datetime nOT NULL,
m_hname char(30) NOT NULL,
m_vname char(30) NOT NULL,
m_hscore int NOT NULL,
m_vscore int NOT NULL,
PRIMARY KEY (m_id)
)ENGINE=InnoDB;注意保留字