PHPMyAdmin, a free tool to administer MySQL databases that provides the SQL statements used so you can redo what you did in the web application in php code.
More after the break.
Here’s the code for the MySQL dump that phpMyAdmin generated
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 25, 2009 at 02:38 PM
-- Server version: 5.1.36
-- PHP Version: 5.3.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `test`
--
-- --------------------------------------------------------
--
-- Table structure for table `table`
--
CREATE TABLE IF NOT EXISTS `table` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(225) NOT NULL,
`text` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `table`
--
INSERT INTO `table` (`ID`, `name`, `text`) VALUES
(1, 'banana', 'they have peals'),
(3, 'Joe', 'Joe has a diaper on his head.');