FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour MySql MariaDatase INDEX
mauri.menabue
Posts: 181
Joined: Thu Apr 17, 2008 02:38 PM
MySql MariaDatase INDEX
Posted: Wed Apr 19, 2023 07:37 PM

Hi all,

I would like to know how to remove an index on a MySql MariaDatase table.

To create an index, the 'UNIQUE' clause is used. How to delete an index?

how to build compound index INDEX ON CLI_COD + STR(CLI_FAT,12,2) + DTOS(date())

TIA

Maurizio Menabue

vilian
Posts: 1067
Joined: Wed Nov 09, 2005 02:17 AM
Re: MySql MariaDatase INDEX
Posted: Wed Apr 19, 2023 08:01 PM
TO REMOVE
oCN:Execute("ALTER TABLE your_table DROP INDEX your_index")

TO CREATE
oCN:Execute("ALTER TABLE your_table ADD INDEX your_index(`field1`, `field2`)")
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil
mauri.menabue
Posts: 181
Joined: Thu Apr 17, 2008 02:38 PM
Re: MySql MariaDatase INDEX
Posted: Wed Apr 19, 2023 09:49 PM

Hi all

Thank Vilian

is also possible : oCN:Execute("ALTER TABLE your_table ADD INDEX your_index(field1, My_function())")

vilian
Posts: 1067
Joined: Wed Nov 09, 2005 02:17 AM
Re: MySql MariaDatase INDEX
Posted: Wed Apr 19, 2023 10:22 PM

I think no.

Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil

Continue the discussion

Static archive · New replies & topics via GitHub Discussions