Just saw your reply Grynmoors, and thought I'd take a whack at it just for fun.
I put in 3 words, and did an export as file from PhpMyAdmin.
I got this:
So, I added line 4,5, and 6: and tried an import.-- phpMyAdmin SQL Dump
-- version 2.10.3-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 14, 2008 at 01:04 AM
-- Server version: 4.1.20
-- PHP Version: 5.2.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `vshare`
--
-- --------------------------------------------------------
--
-- Table structure for table `words`
--
CREATE TABLE IF NOT EXISTS `words` (
`word_id` mediumint(8) unsigned NOT NULL auto_increment,
`word` varchar(255) NOT NULL default '',
`replacement` varchar(255) NOT NULL default '',
PRIMARY KEY (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `words`
--
REPLACE INTO `words` (`word_id`, `word`, `replacement`) VALUES
(1, 'poopoo', ''),
(2, 'heck', ''),
(3, 'phooey', '');
Worked like a charm.
Couple things to note though....
When you do the export, make sure that the export type is set to REPLACE, not INSERT.
If it's set to insert, then you will get an error for duplicate entries.
Also, If yer lazy like me, and you copy and paste from the stuff in the lines above and just change the numbers and words, make sure that each line ends with a comma, except for the last line which must have a semi-colon.
Here's what I wound up with:
It worked perfectly :mrgreen:-- phpMyAdmin SQL Dump
-- version 2.10.3-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 14, 2008 at 01:14 AM
-- Server version: 4.1.20
-- PHP Version: 5.2.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `vshare`
--
-- --------------------------------------------------------
--
-- Table structure for table `words`
--
CREATE TABLE IF NOT EXISTS `words` (
`word_id` mediumint(8) unsigned NOT NULL auto_increment,
`word` varchar(255) NOT NULL default '',
`replacement` varchar(255) NOT NULL default '',
PRIMARY KEY (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `words`
--
REPLACE INTO `words` (`word_id`, `word`, `replacement`) VALUES
(1, 'poopoo', ''),
(2, 'heck', ''),
(3, 'phooey', ''),
(4, 'darn', ''),
(5, 'ratss', ''),
(6, 'rats', '');
Bookmarks