devonbnice Posted January 13, 2011 Share Posted January 13, 2011 I'm still learning sql, and i cant say i like it very much lol, But my question is how would i go about creating a users2 table? Thanks for the help! Devon. Quote Link to comment Share on other sites More sharing options...
Rasheed saeed Posted January 13, 2011 Share Posted January 13, 2011 Quick grab from the .SQL of Mcc v2. [mysql]CREATE TABLE `users2` ( `userid` TINYINT(1) NOT NULL auto_increment, `username` varchar(255) NOT NULL default '', `userpass` varchar(255) NOT NULL default '', `level` int(11) NOT NULL default '0', PRIMARY KEY (`userid`) ) ENGINE=MyISAM ; [/mysql]Just add in what ever after. Quote Link to comment Share on other sites More sharing options...
Jordan Palmer Posted January 13, 2011 Share Posted January 13, 2011 Why do you need a users2 may I ask? Quote Link to comment Share on other sites More sharing options...
devonbnice Posted January 14, 2011 Author Share Posted January 14, 2011 Well i dont actually need another users table, i just dont know how to make a new table that has the IDs in it. Like i for mods, instead of adding the columns in the users table, create a new table. and each user would have their own stuff. ya know? How do i go about doing that? Quote Link to comment Share on other sites More sharing options...
Jordan Palmer Posted January 14, 2011 Share Posted January 14, 2011 New tables are good Thats an old post yet explains all you need to know =) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.