3 Jul
2023
3 Jul
'23
2:08 p.m.
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/