PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → WB19:  modify MySQL DB structure
WB19: modify MySQL DB structure
Iniciado por guest, 23,feb. 2015 12:19 - 1 respuesta
Publicado el 23,febrero 2015 - 12:19
Hi everybody,
I have a WB application with a MySQL DB and I need to insert a new field in a table.
How can do this without lose de existing data in the table and DB in general?
I tihink that HModifyStructure doesn't work with MySQL.

Any suggestion, please?

Thanks in advance.
Jordi
Publicado el 23,febrero 2015 - 13:33
Hi Jordi

If you are using a "regular" SQL DB, then you need to know enough SQL to manage this kind of things by hand (using sql queries of ALTER TABLE type)...or, you do your changes directly in a SQL too/administrator by hand

Best regards