I have a canned banner-rotate program that utilizes scripts and one .sql file (see below). I've been going nuts in utilizing my web hosts MySQL command feature and as well Access and MyODBC to connect to my host's MySQL. In any event, all I need to do is upload this single .sql file but I don't have a clue if it's possible or not. Can MysqlMan upload a ready-made .sql file?
Here's the .sql file. I'm just learning so I am not even sure if I can manually make this file?
CREATE TABLE banners (
account char(25) DEFAULT 'account' NOT NULL,
startdate char(50) DEFAULT 'startdate' NOT NULL,
username char(12) DEFAULT 'username' NOT NULL,
password char(12) DEFAULT 'password' NOT NULL,
imagefile char(100) DEFAULT 'imagefile' NOT NULL,
url char(100) DEFAULT 'url' NOT NULL,
impressions int,
clickthroughs int,
expire int,
startjulean int,
stopjulean int,
expiretype char(25) DEFAULT 'type' NOT NULL,
email char(50) DEFAULT 'email' NOT NULL,
PRIMARY KEY(account)
);
CREATE TABLE system (
startdate char(25) DEFAULT 'startdate' NOT NULL,
username char(12) DEFAULT 'username' NOT NULL,
password char(12) DEFAULT 'password' NOT NULL,
impressions int,
clickthroughs int,
startjulean int,
accountcounter int,
PRIMARY KEY(username)
);
INSERT INTO system VALUES ('','adminusername','adminpassword','0','0','0','0');
Here's the .sql file. I'm just learning so I am not even sure if I can manually make this file?
CREATE TABLE banners (
account char(25) DEFAULT 'account' NOT NULL,
startdate char(50) DEFAULT 'startdate' NOT NULL,
username char(12) DEFAULT 'username' NOT NULL,
password char(12) DEFAULT 'password' NOT NULL,
imagefile char(100) DEFAULT 'imagefile' NOT NULL,
url char(100) DEFAULT 'url' NOT NULL,
impressions int,
clickthroughs int,
expire int,
startjulean int,
stopjulean int,
expiretype char(25) DEFAULT 'type' NOT NULL,
email char(50) DEFAULT 'email' NOT NULL,
PRIMARY KEY(account)
);
CREATE TABLE system (
startdate char(25) DEFAULT 'startdate' NOT NULL,
username char(12) DEFAULT 'username' NOT NULL,
password char(12) DEFAULT 'password' NOT NULL,
impressions int,
clickthroughs int,
startjulean int,
accountcounter int,
PRIMARY KEY(username)
);
INSERT INTO system VALUES ('','adminusername','adminpassword','0','0','0','0');