Hi. Put Purge into backticks.
........ `Purge` char(1), ........ spiv007 <[EMAIL PROTECTED]> wrote: > The complete error is: > ERROR 1064 (42000) at line 355: 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 'Purge CHAR(1), > Dehydration CHAR(1), > SomachDistention CHAR(1), > TissueGas CH' at line 12 > > > > CREATE TABLE if not exists EmbalmingCaseHistory ( > CaseNumber CHAR(50) NOT NULL, > PersonalEffectsYes CHAR(20), > PersonalEffectsNo CHAR(1), > Description TEXT, > CauseOfDeath TEXT, > TimeStarted DATETIME, > TimeCompleted DATETIME, > Normal CHAR(1), > Emaciated CHAR(1), > Edema CHAR(1), > Purge CHAR(1), > Dehydration CHAR(1), > SomachDistention CHAR(1), > TissueGas CHAR(1), > SkinSlip CHAR(1), > Jaundice CHAR(1), > BodyRefrigerated CHAR(1), > HowLong CHAR(50), > RogorMortis CHAR(1), > IVLeakage CHAR(1), > Discoloration TEXT, > Swelling TEXT, > AutopsyFull CHAR(1), > AutospyThoracic CHAR(1), > AutopsyAbdominal CHAR(1), > AutospyCranial CHAR(1), > RemarksPriorToEmbalming TEXT, > NeedleInjector CHAR(1), > Sutures CHAR(1), > MouthClosureRemarks TEXT, > c_Natural CHAR(1), > Mouthformer CHAR(1), > Cotton CHAR(1), > DenturesUpper CHAR(1), > DenturesLower CHAR(1), > EyeCaps CHAR(1), > EyeCotton CHAR(1), > EyeOther CHAR(1), > EyeOther1 CHAR(50), > CarotidR CHAR(1), > CarotidL CHAR(1), > SubclavianR CHAR(1), > SubclavianL CHAR(1), > AxillaryR CHAR(1), > AxillaryL CHAR(1), > BrachialR CHAR(1), > BrachialL CHAR(1), > IlliacR CHAR(1), > IlliacL CHAR(1), > FemoralR CHAR(1), > FemoralL CHAR(1), > RadialR CHAR(1), > RadialL CHAR(1), > UlnarR CHAR(1), > UlnarL CHAR(1), > ArteriesOther CHAR(50), > VJugularR CHAR(1), > VJugularL CHAR(1), > VAxillaryR CHAR(1), > VAxillaryL CHAR(1), > VIlliacR CHAR(1), > VIlliacL CHAR(1), > VFomoralR CHAR(1), > VFomoralL CHAR(1), > VeinsOther CHAR(50), > HairWashedYes CHAR(1), > HairWashedNo CHAR(1), > BodyBathedYes CHAR(1), > BodyBathedNo CHAR(1), > EyesNoseMouthDisinfectedYes CHAR(1), > EyesNoseMouthDisinfectedNo CHAR(1), > ArterialConditionGood CHAR(1), > ArterialConditionFair CHAR(1), > ArterialConditionPoor CHAR(1), > DrainageIntermittent CHAR(1), > DrainageContinuoust CHAR(1), > AspirationTreatmentImmediate CHAR(1), > AspirationTreatmentDelayed CHAR(1), > AspirationTreatmentHydro CHAR(1), > AspirationTreatmentElectric CHAR(1), > CavityTreatmentFluid CHAR(4), > CavityTreatmentType CHAR(12), > FluidDilutionsPreInjectedOz CHAR(5), > FluidDilutionsPreInjectedGal CHAR(5), > FluidDilutionsPreInjectedType CHAR(12), > FluidDilutionsPreInjectedIndex CHAR(5), > FluidDilutionsArterialOz CHAR(5), > FluidDilutionsArterialGal CHAR(5), > FluidDilutionsArterialType CHAR(12), > FluidDilutionsArterialIndex CHAR(5), > FluidDilutionsArterialOz1 CHAR(5), > FluidDilutionsArterialGal1 CHAR(5), > FluidDilutionsArterialType1 CHAR(12), > FluidDilutionsArterialIndex1 CHAR(50), > FluidDilutionsArterialOz2 CHAR(5), > FluidDilutionsArterialGal2 CHAR(5), > FluidDilutionsArterialType2 CHAR(12), > FluidDilutionsArterialIndex2 CHAR(5), > FluidDistributionGood CHAR(1), > FluidDistributionFair CHAR(1), > FluidDistributionPoor CHAR(1), > AreasReceivingPoorCirculation TEXT, > HowTreatedChemicalsUsed TEXT, > HypodermicTreatmentArms CHAR(1), > HypodermicTreatmentLegs CHAR(1), > HypodermicTreatmentTorso CHAR(1), > HypodermicTreatmentNeck CHAR(1), > HypodermicTreatmentFace CHAR(1), > HypodermicTreatmentHands CHAR(1), > HypodermicTreatmentFingers CHAR(1), > HypodermicTreatmentOther CHAR(1), > HypodermicTreatmentOther1 CHAR(10), > Condition TEXT, > Recommendations TEXT, > EmbalmedBy CHAR(50), > EmbalmedLicenseNumber CHAR(50), > INDEX CavityTreatmentFluid ( CavityTreatmentFluid ), > PRIMARY KEY ( CaseNumber ) > ); > > > On Thu, 04 Nov 2004 17:34:14 +0200, Gleb Paharenko > <[EMAIL PROTECTED]> wrote: >> Hi. >> >> You may send us fragment of your file, near line 355. >> >> >> >> >> spiv007 <[EMAIL PROTECTED]> wrote: >> >> > Thanks, I go the dump now. but when i go to import the dump: >> >> > >> >> > mysql -D sd2000 -u root < mysqldump.txt >> >> > >> >> > Im getting errors; ERROR 1064 (42000) at line 355: You have an error >> >> > in your SQL syntax; check the manual, etc!!! >> >> > >> >> > What does this means? >> >> > >> >> > >> >> > On Wed, 03 Nov 2004 09:23:53 +0200, Gleb Paharenko >> >> > <[EMAIL PROTECTED]> wrote: >> >> >> Hi. >> >> >> >> >> >> What version of MySQL do you use? >> >> >> >> >> >> To make it easier to reload dump files for tables that have foreign key >> >> >> >> >> >> relationships, mysqldump automatically includes a statement in the dump >> >> >> >> >> >> output to set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1. >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> spiv007 <[EMAIL PROTECTED]> wrote: >> >> >> >> >> >> > I just dumped my access tables into mysql via mysql dump script. >> >> >> >> >> >> > >> >> >> >> >> >> > But now when i del my ables in access then do an import it does not >> >> >> >> >> >> > save the primary key info nor the tables relationships. Is there >> >> >> >> >> >> > something I need to do to save this info before i remove the old >> >> >> >> >> >> > tables and insert the links. Because everything things works fine >> >> >> >> >> >> > until i del the tables. >> >> >> >> >> >> > >> >> >> >> >> >> > >> >> >> >> >> >> > Thanks for any ideals... >> >> >> >> >> >> > >> >> >> >> >> >> >> >> >> -- >> >> >> For technical support contracts, goto https://order.mysql.com/?ref=ensita >> >> >> This email is sponsored by Ensita.NET http://www.ensita.net/ >> >> >> __ ___ ___ ____ __ >> >> >> / |/ /_ __/ __/ __ \/ / Gleb Paharenko >> >> >> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >> >> >> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET >> >> >> <___/ www.mysql.com >> >> >> >> >> >> -- >> >> >> MySQL General Mailing List >> >> >> For list archives: http://lists.mysql.com/mysql >> >> >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >> >> >> >> >> >> >> >> > >> >> >> -- >> >> >> For technical support contracts, goto https://order.mysql.com/?ref=ensita >> This email is sponsored by Ensita.NET http://www.ensita.net/ >> __ ___ ___ ____ __ >> / |/ /_ __/ __/ __ \/ / Gleb Paharenko >> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET >> <___/ www.mysql.com >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >> >> > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
