- Details
- Hits: 20310
It seems ACLs are more and more used by applications running on Debian rsp RaspberryOS. Unfortunately rsync does complain about ACLs with RC23 when files with ACLs are copied with rsync onto a nfs mounted partition. Today I detected it's possible but you have to use an important option when you mount a partition via nfs.
Read more: How to backup ACLs with rsync on a nfs mounted partition?
- Details
- Hits: 6061
Some SQL DBMs allow to create recursive queries. That's a feature of DB2 (free download ), SQL Server and Oracle. Unfortunately mySQL misses this feature. But every recursive algorithm can be written in a non recursive way - so it's not clear whether this is a need or just a nice DBMS feature. Anyhow - it's an interesting topic.
- Details
- Hits: 12630
Some time ago I liked to play Little Big Adventure (LBA und LBA2) on DOS: It's a nice and amusing game. Recently I detected both CDs in my shelf and thought it would be great to play these games again.
Read more: How to play Little Big Adventure (LBA und LBA2) on Linux and Windows7
- Details
- Hits: 14531
SQL is not very easy to learn, in particular joins of multiiple tables are difficult to understand at a first glance. On the next pages it's explained for sql beginners how SQL joins work. Venn diagrams are used to explain how the tables are combined. In addition sample tables with sample data and sample joins are used to explain in detail the query input data results. SQL files to create the sample data and execute the queries can be downloaded. The samples are for mySQL and DB2.
If you want to see more complex sql joins in action visit Learning SQL by example for sql join examples and other SQL funktions as views, count, max, subselect and other.
 |
 |
 |
 |
 |