There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 1131
STR: //
SQL: -- phpMyAdmin SQL Dump
-- version 2.11.9.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 04, 2008 at 02:31 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.6
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET NAMES utf8 */;# MySQL returned an empty result set (i.e. zero rows).
--
-- Database: `testagain`
--
-- --------------------------------------------------------
--
-- Table structure for table `product`
--
CREATE TABLE IF NOT EXISTS `product` (
`ProductID` varchar(25) NOT NULL,
`SalesID` varchar(25) NOT NULL,
PRIMARY KEY (`ProductID`)
) TYPE=InnoDB;# MySQL returned an empty result set (i.e. zero rows).
--
-- Triggers `product`
--
DROP TRIGGER IF EXISTS `testagain`.`AuditTrigger`;# MySQL returned an empty result set (i.e. zero rows).
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product`
FOR EACH ROW begin
insert into sales(SalesID) values(new.SalesID);
SQL query:
DELIMITER // CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagain`.`product` FOR EACH ROW begin insert into sales(SalesID) values(new.SalesID);
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER //
CREATE TRIGGER `testagain`.`AuditTrigger` AFTER INSERT ON `testagai' at line 1