It worked great but I would like to know why, thank!
On Fri, 05 Nov 2004 13:42:29 +0200, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
