Kirk Abbott wrote:
Hello,
I understand where 'Delete all' or 'delete * from table' works just as well as a truncate... But how about the issue of code maintenance and porting from other DBs? Could there be some value is supporting features from other 'sql dialects'?
There are several middleware products that help with migration between database systems, both proprietary and in the open-source, and both data and SQL code. It would be nice if some were extended with an adapter for MonetDB. Any help in this area would be greatly appreciated and an open-source tool that migrates Oracle, MySQL, PostgreSQL, DB2, ... towards MonetDB would certainly find a good place on our website and expert support in getting the adapter working. regards, Martin
Kirk
Niels Nes wrote:
On Fri, Jul 25, 2008 at 08:24:58PM +0900, nori wrote:
Hi, All.
Is there the function such as "TRUNCATE TABLE" in other DB?
There is no need for a special 'TRUNCATE TABLE'. A delete all is handled efficiently by the log allready.
So you can use delete all.
Niels
Regards, Nori.
-- Nori [1]tunohiko@gmail.com
References
1. mailto:tunohiko@gmail.com
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users