Hi Hannes, Thank you for the prompt reply. Does DELETE FROM without WHERE truncate table storage ? Radovan On 08/08/2013 08:59 AM, Hannes Mühleisen wrote:
Hello Radovan,
On 08/08/2013 08:48 AM, Radovan Bičiště wrote:
I'm trying to "truncate" according to http://www.monetdb.org/Documentation/SQLreference/Updates using DELETE ALL FROM statement. But what I get is syntax error. :(
ceos@lux-analytics:~$ mclient -h localhost -d zkdev1 -u drmaxtst -p 50000 password: Welcome to mclient, the MonetDB/SQL interactive terminal (Feb2013-SP3) Database: MonetDB v11.15.11 (Feb2013-SP3), 'mapi:monetdb://lux-analytics:50000/zkdev1' Type \q to quit, \? for a list of available commands auto commit mode: on sql>delete all from crmkarta; syntax error, unexpected ALL, expecting FROM in: "delete all" sql>
Confirmed the issue on latest released version (Feb2013-SP3). At the same time,
DELETE FROM table;
works fine, so I would suggest using this. I removed the non syntax from the web page for now.
Best,
Hannes
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
-- __________________________ Radovan Bičiště ceos data s.r.o. třída SNP 402/48 500 03 Hradec Králové Czech Republic mobil CZ: +420 601 563 014 skype: rbiciste