Re: Best way to lock a whole mySQL table ?

2024-01-07 Thread matthias rebbe via use-livecode
Rereading your posts i realized that you want to lock a table. So maybe this link is more helpful https://www.atlassian.com/data/admin/grant-permissions-for-mysql > Am 07.01.2024 um 21:50 schrieb matthias rebbe via use-livecode > : > > You could set user permissions and allow only select. >

Re: Best way to lock a whole mySQL table ?

2024-01-07 Thread matthias rebbe via use-livecode
You could set user permissions and allow only select. https://simplebackups.com/blog/how-to-create-and-grant-permissions-to-a-mysql-user/ Regards, Matthias > Am 07.01.2024 um 21:45 schrieb jbv via use-livecode > : > > Hi list, > I have a mySQL table with over a million rows and I would > like

Best way to lock a whole mySQL table ?

2024-01-07 Thread jbv via use-livecode
Hi list, I have a mySQL table with over a million rows and I would like to lock the data so that no inserts nor updates are possible, only reads via select commands. I have read the doc as well as numerous blogs, and as far as I understand, the following command LOCK TABLES myTable WRITE; locks th