I am not sure if this is the correct place to post this but it looks like it. I have a problem. I have created a new MySQL DB and when I created it I used TINYINT, unfortunately I didn't realized that it limited the DB to 127 records. I have searched online and found that I should have used INT because it doesn't have the 127 record limit. The question I have now is, is there a way to change it from TINYINT to INT?
I have already existing data that I would like to avoid loosing, can I just update it in some way and not effect the DB?
I have included a copy of the original dump file:
- Code: Select all
CREATE TABLE quotes ( id tinyint(21) DEFAULT '0' NOT NULL AUTO_INCREMENT,
quoteid varchar(6), quotedate varchar(12), quotetime varchar(11),
quoteamount varchar(8), quotepromo varchar(20), quotelogo varchar(3),
quotehosting varchar(3), quotedomainreg varchar(3),
quotewebdesign varchar(3), quotewebdesigntype varchar(30),
quoteseoss varchar(3), quotepage varchar(3), quotepagesother varchar(3),
quotelayout varchar(3), quotename varchar(50), quoteemail varchar(50),
quotestartdate varchar(20), quotecompletein varchar(10),
quotenotes varchar(255), quoteua varchar(255), quoteip varchar(16),
PRIMARY KEY (id), UNIQUE id (id));
If there are any other errors please let me know.