• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

MySQL Alter Table Syntax

Avarian

Bring Out Your Dead!
Joined
Jun 14, 2007
Messages
472
Reaction score
1
Location
United States
For my AAC i'm working on I need people to upload an SQL file that will add the following into `accounts`

Code:
ALTER TABLE `accounts`
(
  	`rlname` varchar(45) NOT NULL default '',
  	`location` varchar(45) NOT NULL default '',
  	`hide` tinyint(1) NOT NULL default '0',
  	`hidemail` tinyint(1) NOT NULL default '0',

INSERT INTO `accounts` VALUES ('', '', '0', '0');

However i'm not sure how to do this, I found this site http://dev.mysql.com/doc/refman/5.0/en/alter-table.html which talks about Altering tables which is what I think I need to do but I cant figure out how to work it.
 
Back
Top