It is currently Fri Mar 29, 2024 10:12 am


All times are UTC


Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: How to create a table?
PostPosted: Mon Jan 21, 2008 6:37 pm 
Newbie
Newbie

Joined: Sat Dec 15, 2007 9:20 pm
Posts: 11
very noobish im sure, but if i want to create a MySQL table with this code in it:

Quote:
CREATE TABLE `users` (
`ID` int(11) NOT NULL auto_increment,
`Username` varchar(255) NOT NULL,
`Password` varchar(255) NOT NULL,
`Temp_pass` varchar(55) default NULL,
`Temp_pass_active` tinyint(1) NOT NULL default '0',
`Email` varchar(255) NOT NULL,
`Active` int(11) NOT NULL default '0',
`Level_access` int(11) NOT NULL default '2',
`Random_key` varchar(32) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `Username` (`Username`),
UNIQUE KEY `Email` (`Email`)
) ENGINE=MyISAM;


how do i do that? do i have to type something in notepad and upload somehow? help?


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jan 22, 2008 4:29 pm 
Regular
Regular

Joined: Sun Apr 15, 2007 5:14 pm
Posts: 308
Location: Barrie On Ca
log in to your control panel,
click on the MySQL Databases link,
click on your database name (at the bottom),
log in to phpMyAdmin,
click on your database name (top of left column),
at the very top you'll see a few tabs, the second one will say "SQL", click it to run a query,
you'll then see a textbox, paste what you have in that quote above,
then click the go button directly below it(not the bottom one),
that should do it.
:)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ]  Moderators: Moderators, Support Team

All times are UTC


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Hosting | Domains | Servers | Extras | Order | Support | Contacts | FreeHostia © 2011