yes i was trying to truncate more than one table but it didnt work, so i truncated one at a time, oh well
thanks Hartmut On Mon, 3 Jul 2023 at 12:08, Hartmut Holzgraefe <hart...@mariadb.com> wrote: > 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/ > > -- Regards, Robert K Wild.
_______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-le...@lists.mariadb.org
