devonbnice Posted January 13, 2011 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
Rasheed saeed Posted January 13, 2011 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
Jordan Palmer Posted January 13, 2011 Posted January 13, 2011 Why do you need a users2 may I ask? Quote
devonbnice Posted January 14, 2011 Author 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
Jordan Palmer Posted January 14, 2011 Posted January 14, 2011 New tables are good Thats an old post yet explains all you need to know =) Quote
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.