Create a table to store the host and port information

From MyWiki
Jump to: navigation, search

ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0;

CREATE TABLE sslhosts
(
hostname VARCHAR(30),
port INT DEFAULT 443,
PRIMARY KEY(hostname)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;