On 03.07.23 12:22, robert k Wild wrote:
> have i got the syntax correct for the truncate command, can i run it all
> on one command?

start by showing the actual TRUNCATE command you are issuing,
and the actual error you are getting back, that removes
guessing from the process.

I assume that you are trying to truncate more than one table with
a single TRUNCATE command? That does not work.

See also the IBM document you shared earlier, that does show
TRUNCATE for individual tables one at a time.

You may also want to check the reference information on TRUNCATE:

https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html

--
Hartmut Holzgraefe, Principal Support Engineer (EMEA)
MariaDB Corporation | http://www.mariadb.com/