News

Log In Sponsors
Partner Sites





database tables



I can't seem to work out how to create tables. CREATE TABLE `databasename`.`cmsarticles` ( `ID` int(6) unsigned NOT NULL auto_increment COMMENT 'The unique ID of the article', `title` varchar(200) NULL COMMENT 'The article title', `tagline` varchar(255) NULL COMMENT 'Short summary of the article', `section` int(4) NULL DEFAULT 0 COMMENT 'The section of the article', `thearticle` text NULL COMMENT 'The article itself', PRIMARY KEY (`ID`) ); I'm following a tutorial that uses this to a create a table and i'm not sure how to go about it. I can't do it in phpMyAdmin because some of the options aren't in the table maker. I'll screen shot if you want. How do I create the table from the browser?

Click here to read the whole forum topic