Showing posts with label linux. Show all posts
Showing posts with label linux. Show all posts

Wednesday, July 6, 2011

Mysql command

Join tables on common columns.

mysql> select lookup.illustrationid, lookup.personid,person.birthday from lookup left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id;

Saturday, October 17, 2009

Quota Configuration

Once you have quotas set up on the server, whether they are user or group quotas, you will need to test them to verify they are working correctly. Set the quota for a user and then add file space as that user to verify that quotas are changing in the process.
One command that I always liked ot use is repquota. For example if your quotas are on the /home directory run this command: