I'm in the process of converting the data in MySQL database to DBISAM

mySQL uses an insert statement that then lists all of the data (the
"Insert" phrase is only used once for all of the data)

Is it a requirement that DBISAM SQL has an

insert into "tablename" values (....

for each record or is there a short form syntax that I don't know?


Jon

Jon,

<< I'm in the process of converting the data in MySQL database to DBISAM

mySQL uses an insert statement that then lists all of the data (the
"Insert" phrase is only used once for all of the data)

Is it a requirement that DBISAM SQL has an

insert into "tablename" values (....

for each record or is there a short form syntax that I don't know? >>

Yep, it needs the INSERT INTO for each statement.

--
Tim Young
Elevate Software
www.elevatesoft.com

tim,

Thanks... thought that was the case. It was just that mySQL
has different (probably non-standard) syntax for such things
and I thought maybe I had missed something.

Jon


Tim Young [Elevate Software] wrote:
> Jon,
>
> << I'm in the process of converting the data in MySQL database to DBISAM
>
>  mySQL uses an insert statement that then lists all of the data (the
> "Insert" phrase is only used once for all of the data)
>
>  Is it a requirement that DBISAM SQL has an
>
>  insert into "tablename" values (....
>
>  for each record or is there a short form syntax that I don't know? >>
>
> Yep, it needs the INSERT INTO for each statement.
>

Jon

Just a curiosity.
Why did you change from MySql to DBISAM ? I would like to know it because
many customers tell me about MySql and I defend DBISAM and may be I get more
explanations.

Thanks
Eduardo

"Jon Lloyd Duerdoth" <jld@welshdragoncomputing.ca> escreveu na mensagem
news:0CCB6AB6-92B6-4E4A-B03C-B7096917507E@news.elevatesoft.com...
> I'm in the process of converting the data in MySQL database to DBISAM
>
> mySQL uses an insert statement that then lists all of the data (the
> "Insert" phrase is only used once for all of the data)
>
> Is it a requirement that DBISAM SQL has an
>
> insert into "tablename" values (....
>
> for each record or is there a short form syntax that I don't know?
>
>
> Jon

Eduardo,

Nope... didn't switch.  I've been a DBISAMer since v1.
I just have a situation where mySQL works for an
agency that I do volunteer work for.  As a backup
I wanted to convert the data from mySQL to DBISAM.

Jon



Jose Eduardo Helminsky wrote:
> Jon
>
> Just a curiosity.
> Why did you change from MySql to DBISAM ? I would like to know it because
> many customers tell me about MySql and I defend DBISAM and may be I get more
> explanations.
>
> Thanks
> Eduardo
>
> "Jon Lloyd Duerdoth" <jld@welshdragoncomputing.ca> escreveu na mensagem
> news:0CCB6AB6-92B6-4E4A-B03C-B7096917507E@news.elevatesoft.com...
>> I'm in the process of converting the data in MySQL database to DBISAM
>>
>> mySQL uses an insert statement that then lists all of the data (the
>> "Insert" phrase is only used once for all of the data)
>>
>> Is it a requirement that DBISAM SQL has an
>>
>> insert into "tablename" values (....
>>
>> for each record or is there a short form syntax that I don't know?
>>
>>
>> Jon
>
>

Jon

Thanks for share this info

Eduardo

Eduardo,

I had written an application for the organization using only
DBISAM but they needed to be able access the data from several
physical locations.  It was not possible to setup a DBISAM
c/s but mySQL was available on their host so I made some minor
modifications to the application and used mySQL for the
data source.

There were a number of complications having to do with backup
and reporting so data was copied from the mySQL source
into DBISAM (temporary tables) for these activities
since they had already been setup for the original application.

Not sure I would do it this way if I was starting from scratch
but it was one of those "fix an existing application with
the least amount of effort" situations.

Jon

Jose Eduardo Helminsky wrote:
> Jon
>
> Thanks for share this info
>
> Eduardo
>
>