2009/6/11 Aleksey Tsalolikhin :
> I am trying to figure out how move this beastie over with all its data and
> all its users.
Zope typically stores all it's data in a database called ZODB. It
stores everything in a file called Data.fs.
Copy it over from the old server to the new server.
Done!
--
I am suspecting that serial in MySQL works like serial in PostgreSQL in which
a sequence is automatically created. If so, you should be able to query the
last_value field in the sequence without having to call the function. The
field
name might be different in MySQL, I don't know. This will
to my knowledge SELECT LAST_INSERT_ID();
is per connection.
so if you do the call in the same request in which you did the the creation of
the record, you should be fine
robert
Merav Ben-David schrieb:
>
>
>
>
> I am working with zope & mysql.
>
> I have a table with SERIAL column type, I cre
On 11.06.09 14:36, Merav Ben-David wrote:
>
>
>
> I am working with zope & mysql.
>
> I have a table with SERIAL column type, I create “z-sql method” for
> insert operation, how can I get the value for the auto increment column?
>
> I know that in mysql I can call last_insert_id(), how do I call
I am working with zope & mysql.
I have a table with SERIAL column type, I create "z-sql method" for insert
operation, how can I get the value for the auto increment column?
I know that in mysql I can call last_insert_id(), how do I call it, should I
create another "z sql method" and if I do