Hi All,
I have a table that I exported and I am going to do some 'testing' and want to do it on the test table, not the real one.
I exported all my data and when I do a SQL query in phpMyAdmin, I get "No SQL Query' and no new table??
Here is the sql header and one sample data to check integrity.
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 19, 2005 at 10:24 AM
-- Server version: 4.0.18
-- PHP Version: 4.3.11
--
--
-- --------------------------------------------------------
--
-- Table structure for table `Forms`
--
DROP TABLE IF EXISTS `Forms`;
CREATE TABLE IF NOT EXISTS `Forms` (
`FormID` int(6) NOT NULL auto_increment,
`Title` varchar(5) NOT NULL default '0',
`FirstName` varchar(15) NOT NULL default '0',
`LastName` varchar(25) NOT NULL default '0',
`Position` varchar(25) NOT NULL default '0',
`SubjectTaught` varchar(25) NOT NULL default '0',
`GradeLevel7` varchar(9) NOT NULL default '0',
`GradeLevel8` varchar(9) NOT NULL default '0',
`GradeLevel9` varchar(9) NOT NULL default '0',
`GradeLevel10` varchar(9) NOT NULL default '0',
`GradeLevel11` varchar(9) NOT NULL default '0',
`GradeLevel12` varchar(9) NOT NULL default '0',
`School` varchar(30) NOT NULL default '0',
`SchoolAddress1` varchar(30) NOT NULL default '0',
`SchoolAddress2` varchar(30) NOT NULL default '0',
`City` varchar(20) NOT NULL default '0',
`State` char(2) NOT NULL default '0',
`Zip` varchar(10) NOT NULL default '0',
`EmailAddress` varchar(40) NOT NULL default '0',
`Washington` varchar(11) NOT NULL default '0',
`AmericaOne` varchar(11) NOT NULL default '0',
`Greed` varchar(11) NOT NULL default '0',
`Scaring` varchar(11) NOT NULL default '0',
`Freeloaders` varchar(11) NOT NULL default '0',
`WouldLikeBecause` text NOT NULL,
`PlanOnUsing` text NOT NULL,
`AverageStudents` int(4) NOT NULL default '0',
`VideoUse` int(3) NOT NULL default '0',
`Promise` varchar(22) NOT NULL default '0',
`ReferredFirstName` varchar(30) NOT NULL default '',
`ReferredLastName` varchar(40) NOT NULL default '',
`ReferredEmailAddress` varchar(50) NOT NULL default '',
`Comments` text NOT NULL,
`Date` date NOT NULL default '0000-00-00',
`Time` time NOT NULL default '00:00:00',
`Processed` int(2) NOT NULL default '0',
PRIMARY KEY (`FormID`)
) TYPE=MyISAM AUTO_INCREMENT=19193 ;
--
-- Dumping data for table `Forms`
--
INSERT INTO `Forms` (`FormID`, `Title`, `FirstName`, `LastName`, `Position`, `SubjectTaught`, `GradeLevel7`, `GradeLevel8`, `GradeLevel9`, `GradeLevel10`, `GradeLevel11`, `GradeLevel12`, `School`, `SchoolAddress1`, `SchoolAddress2`, `City`, `State`, `Zip`, `EmailAddress`, `Washington`, `AmericaOne`, `Greed`, `Scaring`, `Freeloaders`, `WouldLikeBecause`, `PlanOnUsing`, `AverageStudents`, `VideoUse`, `Promise`, `ReferredFirstName`, `ReferredLastName`, `ReferredEmailAddress`, `Comments`, `Date`, `Time`, `Processed`) VALUES (117, 'Ms.', 'x', 'x', 'Teacher', 'History', '', '', 'GRADE 9', 'GRADE 10', '', '', 'x School', '3000 x, NW', '', 'Washington', 'DC', 'x', 'x', '', 'WANTS SJ04', '', '', '', 'In our 9th grade world history curriculum, we incorporate the study of world poverty and hunger. This video seems relevant.', 'Showing it to the entire 9th grade each year (approximately 80 students)', 50, 5, 'PromiseToProvideData', '', '', '', '', '2005-11-16', '03:14:00', 0);
I tried using the .sql file and pasting the contents into the sql query window in phpMyAdmin, and both times, 'No SQL Query' ??
I'm stumped.
Thanks,
Don
