ofi Posted March 22, 2007 Share Posted March 22, 2007 Hi I have never done this before, i need to add in new table into SQL query from in phpmyadmin. how do i do that, i got 3 mysql Databasees, i am running wordpress on my site, so i pick wordpress mysql, and there to phpmyadmin, and then what do i do ??? need to add this in -- -- Table structure for table `wp_fim_cat` -- DROP TABLE IF EXISTS `wp_fim_cat`; CREATE TABLE IF NOT EXISTS `wp_fim_cat` ( `catname` varchar(255) NOT NULL default '', `id` int(11) NOT NULL auto_increment, `date` datetime default NULL, `description` text NOT NULL, `folder` varchar(255) NOT NULL default '', `cover` varchar(50) default '', `status` varchar(20) NOT NULL default 'public', `password` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `wp_fim_comments` -- DROP TABLE IF EXISTS `wp_fim_comments`; CREATE TABLE IF NOT EXISTS `wp_fim_comments` ( `id` int(11) NOT NULL auto_increment, `image_id` int(11) NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', `author_comment` text NOT NULL, `author_name` varchar(255) NOT NULL default '', `author_email` varchar(255) NOT NULL default '', `author_url` varchar(255) NOT NULL default '', `author_ip` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `wp_fim_images` -- DROP TABLE IF EXISTS `wp_fim_images`; CREATE TABLE IF NOT EXISTS `wp_fim_images` ( `id` smallint(11) NOT NULL auto_increment, `image` varchar(255) default NULL, `date` datetime default NULL, `title` varchar(255) default NULL, `description` text, `cat` varchar(10) NOT NULL default '', `status` varchar(50) default 'include', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; Link to comment https://forums.phpfreaks.com/topic/43820-insert-new-table/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.