Re: [SQLObject] Setting mysql engine for created tables

[David F. <df...@kl...>]

On Wednesday 22 February 2006 09:48, BJ=F6rn Lindqvist wrote:
> On 2/21/06, David Faure <df...@kl...> wrote:
> > I'm looking for how to choose the mysql engine (http://mysql.speedbone.=
de/doc/refman/5.0/en/storage-engines.html)
> > used by tables created by SQLObject. Since it can be done with an ALTER=
 TABLE command, it looks like
> > I don't have to customize the CREATE TABLE sql syntax. However... how c=
ould I make that ALTER command
> > be executed for all SQLObjects that users might create in scripts, auto=
matically?
>=20
> I haven't tested it, but it seems like using a connection string like:
>=20
>     mysql://user@host/db?init_command=3D'set table_type InnoDB'
>=20
> should do the trick. If it doesn't, then something should be made so
> that it works.

But this forces the same table type onto all tables, unlike the sqlmeta sol=
ution.

=2D-=20
David Faure -- fa...@kd..., df...@kl...
KDE/KOffice developer, Qt consultancy projects
Klar=E4lvdalens Datakonsult AB, Platform-independent software solutions