Month: January 2011

Egg Drop Soup

Posted on by rchapin
  • 1 egg
  • 2 1/2 cups chicken broth
  • 1 tbsp corn starch mixed with 1tbsp water
  • 1 tsp finely chopped tops of green onions
  • Pinch of white pepper
  • Dash of sesame oil

In a small bowl, beat egg slightly; set aside. Bring chicken broth to a boil over high heat. Add corn starch mixture to the broth stirring until it comes to a boil again. Reduce heat to medium-low. Hold the pan with beaten egg about 12 to 15″ above the → Continue reading “Egg Drop Soup”

Deleting a File Using the Inode Number

Posted on by rchapin

Sometimes you will accidentally create a file that has special characters in the file name which then prevents you from running commands on it.  In that case, you can resort to accessing the file via it’s inode number.

To do so:

$ ls -il | more

In the directory in which the file that you want to examine resides

This will output a list of files, the first column being the inode number.

You can then run the following command → Continue reading “Deleting a File Using the Inode Number”

Retuning a MySQL Query in CSV

Posted on by rchapin

The following is an example of how to run a query on the command line to output the result of a MySQL query to a CSV file.

Create a text file with the your query, query.sql:

SELECT * FROM hosts;

The run the following command:

mysql –skip-column-names -uuser -ppassword database < query.sql | sed ‘s/\t/”,”/g;s/^/”/;s/$/”/;’ > filename.csv

This will run the MySQL query and output the results to a text file in .csv format.

The sed commands do the following:→ Continue reading “Retuning a MySQL Query in CSV”

© 2005 Ryan Chapin