Test MySQL DB

From Humanitarian FOSS Summer Institute 2008

Jump to: navigation, search
-- phpMyAdmin SQL Dump
-- version 2.11.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 04, 2008 at 08:22 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `test`
--

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

--
-- Table structure for table `foo`
--

CREATE TABLE IF NOT EXISTS `foo` (
  `bar` varchar(256) NOT NULL,
  `foo_id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`foo_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `foo`
--

INSERT INTO `foo` (`bar`, `foo_id`) VALUES
('Hi', 1),
('Hola', 2),
('Buon giorno', 3),
('Guten tag', 4);

Personal tools