-
What, who, where am I?!?
Craig Lotter is a web developer based in Gordon's Bay, South Africa, who seems completely incapable of shaking off that pesky inner child within, the one that forces him to love all things animated or hand drawn.
The Rugged Rock of Craig contains snippets of his life, popular culture and all the important things like anime, manga, games and comic books. The CodeUnit of Craig on the other hand contains the more serious stuff like code snippets and tutorials, while the House of C chronicles his foray into the world of web comics.
For which it never seems he has enough time anyway.
CodeUnit Post Archive
Author Archives: Craig Lotter
Ubuntu: How to Show MySQL User Accounts via the Terminal
To get a list of user accounts on a MySQL server instance, we need to make a SELECT call to the mysql.user table. Continue reading
Posted in MySQL, Tutorials, Ubuntu
Tagged mysql, show users, terminal, Ubuntu, user accounts
Leave a comment
SQL: Toggle 1 and 0 Value in an Update SQL Statement
I tend to use a lot of tinyint columns as controllers for my database-held objects, usually sticking to the convention of 1 means on and 0 means off. In other words, the perfect target for a SQL toggle statement! Continue reading
Internet Explorer (IE) and the Cached .js File
Internet Explorer and pretty much all other modern web browsers make use of silent caching in order to streamline user experience. Of course, caching is a marvellous tool when needed, but also a frustrating one when you don’t want it turned on. Enter the humble .js javascript include file. Now IE likes to cache javascript .js file includes, but unfortunately unlike normal web pages, getting it to refresh its cached copy can sometime prove to be quite difficult to achieve.
Continue reading
How to Split a MP4 Video File for Your iPod
At the moment I quite enjoying watching television shows on my iPod while working out at gym. Of course to get these television show episodes on my little iPod, I first need to rip them off my DVDs and convert them into MP4 – which of course results in one long video file which is of no use to anyone. So how do I split my MP4 video files into episode chunks for the iPod? Continue reading
Ubuntu: How to Search for a Folder via the Terminal
Often you know that there exists a specific directory on your system, but you just can’t seem to locate it anywhere. Enter the useful find statement, a generic workhorse that you will most certainly find on almost all *nix distributions! Continue reading
