Delete duplicate rows in database table (postgresql).
Posted Over 11 years ago. Visible to the public. Linked content.
DELETE FROM in_mam WHERE ctid NOT IN (SELECT MAX(ctid) FROM in_mam GROUP BY video_id, mam_id);
Tags
Related cards:
Installing Linux on USB – Which Linux filesystem for USB devices?
USB Hard Drives = Ext3 or Ext2;
USB Flash Drives = Ext2 with “noatime” or “relatime” mount option
Read properties file in Java
Configuration wsconfig;
try {
wsconfig = new PropertiesConfiguration("webservice.properties");
} catch (ConfigurationException e) {
e.printStackTrace();
}
uuid = wsconfig.getString("tibkdb.uuid");
Create a Debian Package
- Ordnerstruktur erstellen wie zukünftig unter /
- DEBIAN/control Datei erstellen
Package: helloworld
Version: 0.0.1-0
Section: misc
Priority: extra
Architecture: all
Depends:
Installed-Size: 8
Maintainer: Tho...
Give group access to a directory where everybody may read/write/update using the SGID bit.
SGID is usually used on directories shared by GroupID. Where users join a group and share access to a directory using the GID of the directory. SGID is then used to ensure that all files created in that directory also belong to the same GID, allow...
Posted by mgns to FB10 (2012-11-19 13:50)