Monthly Archives: March 2009

//March

Simple MySQL Developer Intro

MySQL is one of the most powerful and widely used databases available. Here is a really quick guide to creating a database, creating a table, inserting, selecting and deleting the data, then table, then database. This will not go into too much depth as there are plenty of resources out there already that can provide more information on each step. I’ll be using the MySQL command line tool on a Linux (Debian!) platform. Assuming I already have mysql running and a passworded root user account: ns3:~# mysql -u root -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or g. Your MySQL connection id is 168753 Server version: 5.0.51a-24-log (Debian) Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer. mysql> […]

By | March 11th, 2009|Development, MySQL|1 Comment

Linux diff and patch

diff and patch are a complimentary pair of commands for viewing and applying changes to a file. Let’s assume that we have a simple C program (hello.c): ns3:~/test# cat hello.c #include &lt;stdio.h&gt;<br /> int main(void) { printf("Hello Worldn"); return 0; } […]

By | March 5th, 2009|Linux, Technology|0 Comments