SQLize Online / PHPize Online  /  SQLtest Online

CREATE TEMPORARY TABLE new_network (id int(10) unsigned NOT NULL AUTO_INCREMENT, date VARCHAR (200) NOT NULL, login VARCHAR (200) NOT NULL, user VARCHAR (200) NOT NULL, dnsname VARCHAR (200) NOT NULL, ip VARCHAR (200) NOT NULL, switch VARCHAR (200) NOT NULL, mac_address VARCHAR (200) NOT NULL, switch_ip VARCHAR (200) NOT NULL, vlan VARCHAR (200) NOT NULL, port VARCHAR (200) NOT NULL, num VARCHAR (200) NOT NULL, switch1 VARCHAR (200) NOT NULL, switch_ip1 VARCHAR (200) NOT NULL, vlan1 VARCHAR (200) NOT NULL, port1 VARCHAR (200) NOT NULL, name VARCHAR (200) NOT NULL, switch2 VARCHAR (200) NOT NULL, switch_ip2 VARCHAR (200) NOT NULL, vlan2 VARCHAR (200) NOT NULL, port2 VARCHAR (200) NOT NULL, PRIMARY KEY (id)) ENGINE=MyISAM DEFAULT CHARSET=utf8