[MonetDB-users] Is there Function likes TRUNCATE ?
Hi, All. Is there the function such as "TRUNCATE TABLE" in other DB? Regards, Nori. -- Nori tunohiko@gmail.com
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
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
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'? 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
On Fri, Jul 25, 2008 at 07:13:34AM -0500, 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'?
You could add a feature request, see the source forge site. Shouldn't be to hard to rewrite a truncate table x into delete from table. Niels
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
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
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
participants (4)
-
Kirk Abbott -
Martin Kersten -
Niels Nes -
nori