Re: nebiew migrate access tables to mysql

replied to him privately with this before I realized he'd sent a different copy with the list CC'd: CREATE TABLE if not exists TASK ( `Payment Date` DATE, ID INT AUTO_INCREMENT, CaseNumber CHAR(12) NOT NULL, Payment_Amount FLOAT(8,2), PRIMARY KEY (ID), KEY CaseNumber ( CaseNumb

Re: nebiew migrate access tables to mysql

What about this? I will not take "AUTO INCREMENT" I tried removing the underscore and putting `AUTO INCREMENT` , but im getting the same error as before. CREATE TABLE if not exists TASK ( `Payment Date` DATE, ID INT AUTO_INCREMENT, CaseNumber CHAR(12) NOT NULL,

Re: nebiew migrate access tables to mysql

The reserved words are listed in the manual . 'Purge' is on the list. Michael ian douglas wrote: Put Purge into backticks. `Purge` char(1), It worked great but I would like to know why, thank! It could be that 'purge' is a reserv

Re: nebiew migrate access tables to mysql

Put Purge into backticks. `Purge` char(1), It worked great but I would like to know why, thank! It could be that 'purge' is a reserved word in MySQL. I wanted to have a table with a shortened name of 'description' by trying to create a table with a 'desc' field, and MySQL had problems wi

Re: nebiew migrate access tables to mysql

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: >

Re: nebiew migrate access tables to mysql

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

Re: nebiew migrate access tables to mysql

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), SomachDistentionCHAR(1), TissueGa

Re: nebiew migrate access tables to mysql

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

Re: nebiew migrate access tables to mysql

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 <[EMA

Re: nebiew migrate access tables to mysql

I see 4.1.1 is new im downloading 4.1.7 now... 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 includ

Re: nebiew migrate access tables to mysql

sorry I should over put my verision number in. 4.0.21-standard 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 aut

Re: nebiew migrate access tables to mysql

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 jus

nebiew migrate access tables to mysql

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. Beca