PDA

View Full Version : how to create a table


Thug
09-02-2005, 09:20 PM
Hi i mstuck on creating tables in phpmyadmin
im missing some tables EG;
and need to no how to create it

"CREATE TABLE ibf_games_cats (
c_id mediumint(8) NOT NULL auto_increment,
cat_name varchar(32) NOT NULL default '',
active tinyint(1) NOT NULL default '1',
show_all TINYINT( 1 ) DEFAULT '0' NOT NULL,
pos TINYINT( 2 ) DEFAULT '1' NOT NULL,
password VARCHAR( 32 ) NOT NULL,
num_of_games MEDIUMINT( 8 ) DEFAULT '0' NOT NULL,
PRIMARY KEY (c_id)) TYPE=MyISAM";

Marco van Herwaarden
09-03-2005, 04:39 AM
In phpMyAdmin you will find a tab-page where you can enter SQL. Just copy&paste the above there.

Thug
09-03-2005, 12:24 PM
thanx sorted