2017-02-27, 23:03
3..Truncate - it simply means to delete the data from the table while maintaining the structure of table itself. In the case of MSSQL which I am using for my database, it's simply "truncate table dbo.recording"
If you're using something other than MS SQL the command may (will) vary slightly, you'll have to look it up, though it's all sql so it should be similar. also, take a look at your tables, see whats in there.
if you don't have a sql management tool HeidiSQL is free and multiplatform. it works with MSSQL, MySQL and others.
I dont recall what db platforms mediaportal supports.If you happen to be using mssql as I am, then microsofts SSMS is excellent, but of course it is specific to MSSQL...and I'm getting waaaaaay off topic now.
I stress again, make a backup first...deleting data from tables can break things and cause inconsistencies big time. test first on a test system if possible.
good luck !
If you're using something other than MS SQL the command may (will) vary slightly, you'll have to look it up, though it's all sql so it should be similar. also, take a look at your tables, see whats in there.
if you don't have a sql management tool HeidiSQL is free and multiplatform. it works with MSSQL, MySQL and others.
I dont recall what db platforms mediaportal supports.If you happen to be using mssql as I am, then microsofts SSMS is excellent, but of course it is specific to MSSQL...and I'm getting waaaaaay off topic now.
I stress again, make a backup first...deleting data from tables can break things and cause inconsistencies big time. test first on a test system if possible.
good luck !
