Plants SQL Database Dump for MySQL, Microsoft Access and Oracle

Preview
-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Feb 18, 2007 at 06:45 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
-- 
-- Database: `phpdata_demodb`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `plants`
-- 

DROP TABLE IF EXISTS `plants`;
CREATE TABLE IF NOT EXISTS `plants` (
  `id` int(10) NOT NULL default '0',
  `symbol` varchar(255) NOT NULL default '',
  `scientific` varchar(255) NOT NULL default '',
  `common` varchar(255) NOT NULL default '',
  `family` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `plants`
-- 

INSERT INTO `plants` VALUES (1, 'ABELI', 'Abelia R. Br.', 'abelia', 'Caprifoliaceae');
INSERT INTO `plants` VALUES (2, 'ABGR4', 'Abelia ?grandiflora (Rovelli ex Andr?) Rehd. [chinensis ? uniflora]', 'glossy abelia', 'Caprifoliaceae');
INSERT INTO `plants` VALUES (3, 'ABELM', 'Abelmoschus Medik.', 'okra', 'Malvaceae');
INSERT INTO `plants` VALUES (4, 'ABES', 'Abelmoschus esculentus (L.) Moench', 'okra', 'Malvaceae');
INSERT INTO `plants` VALUES (5, 'HIES', 'Hibiscus esculentus L.', 'Abelmoschus esculentus', 'Malvaceae');
INSERT INTO `plants` VALUES (6, 'ABMA9', 'Abelmoschus manihot (L.) Medik. [excluded]', '', 'Malvaceae');
INSERT INTO `plants` VALUES (7, 'HIMA9', 'Hibiscus manihot L. [excluded]', 'Abelmoschus manihot', 'Malvaceae');
INSERT INTO `plants` VALUES (8, 'ABMO', 'Abelmoschus moschatus Medik.', 'musk okra', 'Malvaceae');
INSERT INTO `plants` VALUES (9, 'HIAB', 'Hibiscus abelmoschus L.', 'Abelmoschus moschatus', 'Malvaceae');
INSERT INTO `plants` VALUES (10, 'ABIES', 'Abies P. Mill.', 'fir', 'Pinaceae');
INSERT INTO `plants` VALUES (11, 'ABAL3', 'Abies alba P. Mill.', 'silver fir', 'Pinaceae');
INSERT INTO `plants` VALUES (12, 'ABAM', 'Abies amabilis (Dougl. ex Loud.) Dougl. ex Forbes', 'Pacific silver fir', 'Pinaceae');
INSERT INTO `plants` VALUES (13, 'ABBA', 'Abies balsamea (L.) P. Mill.', 'balsam fir', 'Pinaceae');
INSERT INTO `plants` VALUES (14, 'ABBAB', 'Abies balsamea (L.) P. Mill. var. balsamea', 'balsam fir', 'Pinaceae');
INSERT INTO `plants` VALUES (15, 'PIBA3', 'Pinus balsamea L.', 'Abies balsamea var. balsamea', 'Pinaceae');
INSERT INTO `plants` VALUES (16, 'ABBAP', 'Abies balsamea (L.) P. Mill. var. phanerolepis Fern.', '', 'Pinaceae');
INSERT INTO `plants` VALUES (17, 'ABPH', 'Abies ?phanerolepis (Fern.) Liu', 'Abies
To view the full dump, please login
SQL database dumps

Plants

Navigation

Popular databases
