MySQL queries

gistfile1.txt

CREATE TABLE results(
   id INT NOT NULL AUTO_INCREMENT,
   1sttitle VARCHAR(100) NOT NULL,
   2ndtitle VARCHAR(100) NOT NULL,
   3rdtitle VARCHAR(100) NOT NULL,
    1stmsg VARCHAR(300) NOT NULL,
   2ndmsg VARCHAR(300) NOT NULL,
   3rdmsg VARCHAR(300) NOT NULL,
   1stscore VARCHAR(100) NOT NULL,
   2ndscore VARCHAR(100) NOT NULL,
   3rdscore VARCHAR(100) NOT NULL,
   1stlink  VARCHAR(200) NOT NULL,
   2ndlink VARCHAR(200) NOT NULL,
   3rdlink VARCHAR(200) NOT NULL,
   1stimg  VARCHAR(100) NOT NULL,
   2ndimg VARCHAR(100) NOT NULL,
   3rdimg VARCHAR(100) NOT NULL,
   freetrial VARCHAR(100) NOT NULL,
   PRIMARY KEY ( id )
) AUTO_INCREMENT=15110 CHARACTER SET utf8 COLLATE utf8_general_ci;

alter table <some_table> convert to character set utf8 collate utf8_unicode_ci;

ALTER TABLE contacts ADD email VARCHAR(60);

ALTER TABLE contacts ADD email VARCHAR(60) AFTER name;

ALTER TABLE contacts ADD email VARCHAR(60) FIRST;

insert into users (username, password) values ('bob', MD5('supersecret'));