逃离这么久，终于还记得这里有个home ,忙，忙 … 忙的忘记了时间。

回来，其实只为了这段代码 7032991e

呵呵

看的懂吗？ ！

一段做了又做的代码，为了测试这个blog归我所有

呵呵

代码 2 7032991e

摘录：有用的表格（三）Treebeard’s Unix Cheat Sheet

http://www.rain.org/%7emkummel/unix.html

Long listings (ls -l) have this format: 

     - file     d directory,                                            * executable     ^   symbolic links (?)  file size (bytes)   file name   / directory     ^           ^               ^                  ^        ^     drwxr-xr-x 11 mkummel      2560 Mar  7 23:25 public_html/     -rw-r–r–  1 mkummel     10297 Mar  8 23:42 index.html                                             ^      ^^^        user permission  (rwx)      date and time last modified         ^^^     group permission (rwx)            ^^^  world permission (rwx) 

An alias lets you type something simple and do something complex. It’s a shorthand for a command. If you want to type “dir” instead of “ls -l” then type alias dir ‘ls -l’. The single quotes tell Unix that the enclosed text is one command.Aliases are more useful if they’re permanent so you don’t have to think about them. You can do this by adding the alias to your .cshrc file so they’re automatically loaded when you start. Type pico .cshrc and look for the alias section and add what you want. It will be effective when you start. Just remember that if you make an alias with the name of a Unix command, that command will become unavailable.

Here are a few aliases from my .cshrc file:

 

# enter your aliases here in the form: 	    # alias     this    means this              alias       h       history                      alias       m       more             alias	q	quota -v             alias       bye     exit             alias 	ls 	ls -F             alias       dir     ls             alias 	cdup	cd ..             alias	motd	more /etc/motd

A Unix script is a text file of commands that can be executed, like a .bat file in DOS. Unix contains a powerful programming language with loops and variables that I don’t really understand. Here’s a useful example.Unix can’t rename a bunch of files at once the way DOS can. This is a problem if you develop Web pages on a DOS machine and then upload them to your Unix Server. You might have a bunch of .htm files that you want to rename as .html files, but Unix makes you do it one by one. This is actually not a defect. (It’s a feature!) Unix is just being more consistent than DOS. So make a script!

Make a text file (eg with pico) with the following lines. The first line is special. It tells Unix what program or shell should execute the script. Other # lines are comments.

#! /bin/csh     # htm2html converts *.htm files to *.html     foreach f ( *.htm )       set base=`basename $f .htm`       mv $f $base.html     end

Save this in your home directory as htm2html (or whatever). Then make it user-executable by typing chmod 700 htm2html. After this a * will appear by the file name when you ls -F, to show that it’s executable. Change to a directory with .htm files and type ~/htm2html, and it will do its stuff.Think about scripts whenever you find yourself doing the same tedious thing over and over.

Dotfile names begin with a “.” These files and directories don’t show up when you list a directory unless you use the -a option, so they are also called hidden files. Type ls -la in your home directory to see what you have.Some of these dotfiles are crucial. They initialize your shell and the programs you use, like autoexec.bat in DOS and .ini files in Windows. rc means “run commands”. These are all text files that can be edited, but change them at your peril. Make backups first!

Here’s some of what I get when I type ls -laF:

.addressbook	my email addressbook.
.cshrc	my C-shell startup info, important!
.gopherrc	my gopher setup.
.history	list of past commands.
.login	login init, important!
.lynxrc	my lynx setup for WWW.
.ncftp/	hidden dir of ncftp stuff.
.newsrc	my list of subscribed newsgroups.
.pinerc	my pine setup for email.
.plan	text appears when I’m fingered, ok to edit.
.profile	Korn shell startup info, important!
.project	text appears when I’m fingered, ok to edit.
.signature	my signature file for mail and news, ok to edit.
.tin/	hidden dir of my tin stuff for usenet.
.ytalkrc	my ytalk setup.

Action	DOS	UNIX
change directory	cd	cd
change file protection	attrib	chmod
compare files	comp	diff
copy file	copy	cp
delete file	del	rm
delete directory	rd	rmdir
directory list	dir	ls
edit a file	edit	pico
environment	set	printenv
find string in file	find	grep
help	help	man
make directory	md	mkdir
move file	move	mv
rename file	ren	mv
show date and time	date, time	date
show disk space	chkdsk	df
show file	type	cat
show file by screens	type filename | more	more
sort data	sort	sort

http://www.googleguide.com/advanced_operators_reference.html

(A printable PDF version is available.)
Basic Examples
This Search		Finds Pages Containing…
biking Italy		the words biking and Italy
recycle steel OR iron		information on recycling steel or recycling iron
“I have a dream“		the exact phrase I have a dream
salsa –dance		the word salsa but NOT the word dance
Louis +I France		information about Louis the First (I), weeding out other kings of France
castle ~glossary		glossaries about castles, as well as dictonaries, lists of terms, terminology, etc.
fortune-telling		all forms of the term, whether spelled as a single word, a phrase, or hyphenated
define:imbroglio		definitions of the word imbroglio from the Web
“Nancy * Blachman“		the words Nancy and Blachman separated by exactly one word

Calculator
Operators		Meaning		Type Into Search Box (& Results)
+ – * /		basic arithmetic		12 + 34 - 56 * 7 / 8
% of		percentage of		45% of 39
^ or **		raise to a power		2^5 or 2**5
the nth root of		nth root		4th root of 16
old units in new units		convert units		300 Euros in USD, 130 lbs in kg, or 31 in hex

Restrict Search
Operators		Meaning		Type Into Search Box (& Results)
city1 city2		Book flights.		sfo bos (Book flights from San Francisco (SFO) to Boston (BOS).)
site:		Search only one website or domain.		Halloween site:www.census.gov (Search for information on Halloween gathered by the US Census Bureau.)
[#]..[#]		Search within a range of numbers.		Dave Barry pirate 2002..2006 (Search for Dave Barry articles mentioning pirates written in these years.)
filetype: (or ext:)		Find documents of the specified type.		Form 1098-T IRS filetype:pdf (Find the US tax form 1098-T in PDF format.)
link:		Find linked pages, i.e., show pages that point to the URL.		link:warriorlibrarian.com (Find pages that link to Warrior Librarian’s website.)

Specialized Information Queries
Operators		Meaning		Type Into Search Box (& Results)
book (or books)		Search full-text of books.		book Ender’s Game (Show book-related information. Note: No colon needed after book.)
define, what is, what are		Show a definition for a word or phrase.		define monopsony, what is podcast (Show a definition for the words monopsony and podcast. Note: No colon after define, what is, or what are.)
define:		Provide definitions for words, phrases, and acronyms from the Web.		define:kerning (Find definitions for kerning from the Web.)
phonebook:		Show all phonebook listings.		phonebook: Disney CA (Search for Disney’s phone numbers in California - CA.)
rphonebook:		Show residential phonebook listings.		rphonebook: bill jones NY (Search for the phone number of every Bill Jones in New York State - NY.)
movie:		Find reviews and showtimes.		movie: traffic (Search for information about this movie, including reviews, showtimes, etc.)
stocks:		Given ticker symbols, show stock information		stocks: goog (Find Google’s current stock price.)
weather		Given a location (US zip code or city), show the weather		weather Seattle WA, weather 81612 (Show the current weather and forecast. Note: No colon after weather.)

Alternative Query Types
Operators		Meaning		Type Into Search Box (& Results)
cache:		Display Google’s cached version of a web page.		cache:www.irs.gov (Show Google’s cached version of the US Internal Revenue Service home page.)
info: (or id:)		Find info about a page.		info:www.theonion.com (Find information about The Onion website.)
related:		List web pages that are similar or related to the URL.		related:www.healthfinder.gov (Find websites related to the Healthfinder website.)

Restrict Search to Sites where Query Words Appear
Operators		Meaning		Type Into Search Box (& Results)
allinanchor:		All query words must appear in anchor text of links to the page.		allinanchor:useful parenting sites (Search for pages that are called useful parenting sites by others.)
inanchor:		Terms must appear in anchor text of links to the page.		restaurants Portland inanchor:kid-friendly (Search for pages on Portland restaurants for which links to the page say they are “kid friendly.”)
allintext:		All query words must appear the in text of the page.		allintext:ingredients cilantro chicken lime (Search for recipes with these three ingredients.)
intext:		The terms must appear in the text of the page.		Dan Shugar intext:Powerlight (Find pages mentioning Dan Shugar where his company, Powerlight, is included in the text of the page, i.e., less likely to be from the corporate website.)
allintitle:		All query words must appear in the title of the page.		allintitle: Google Advanced Operators (Search for pages with titles containing “Google,” “Advanced,”, and “Operators”.)
intitle:		The terms must appear in the title of the page.		movies comedy intitle:top ten (Search for pages with the words movie and comedy that include top ten in the title of the page.)
allinurl:		All query words must appear in the URL.		allinurl:pez faq (Search for pages containing the words pez & faq in the URL.)
inurl:		The terms must appear in the URL of the page.		pharmaceutical inurl:investor (Search for pages in which the URL contains the word investor.)

Restrict Search to Google Groups
Operators		Meaning		Type Into Search Box (& Results)
author:		Find Groups messages from the specified author.		flying author:Hamish author:Reid (Search for Hamish Reid’s articles on flying.)
group:		Find Groups messages from the specified newsgroup.		ivan doig group:rec.arts.books (Search for postings about Ivan Doig in the group rec.arts.books.)
insubject:		Find Groups messages containing crazy quilts in the subject.		insubject:”crazy quilts” (Find articles containing crazy quilts in the subject line.)

Restrict Search to Google News
Operators		Meaning		Type Into Search Box (& Results)
location:		Find News articles from sources located in the specified location.		queen location:uk (Find British news articles on the Queen.)
source:		Find News articles from specified sources.		peace source:ha_aretz (Show articles on peace from the Israeli newspaper Ha’aretz.)

Restrict Search to Froogle
Operators		Meaning		Type Into Search Box (& Results)
store:		Find Froogle products from the specified store.		jeans store:gap (Find Gap jeans.)

About This Cheat Sheet
		For more tips, tricks, & examples, visit www.GoogleGuide.com. By Nancy Blachman, Tasha Bergson-Michelson, & Jerry Peek who don’t work for Google. Thank you Matt Vance for the idea of creating a Google Guide cheat sheet.
Please email suggestions or corrections to nancy(at)googleguide.com (replace (at) by @).
This page was last modified on Saturday December 23, 2006

MYSQL Cheat Sheets
http://www.nparikh.org/unix/mysql.php

Selecting a database:
mysql> USE database;
Listing databases:
mysql> SHOW DATABASES;
Listing tables in a db:
mysql> SHOW TABLES;
Describing the format of a table:
mysql> DESCRIBE table;
Creating a database:
mysql> CREATE DATABASE db_name;
Creating a table:
mysql> CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE));
Ex: mysql> CREATE TABLE pet (name VARCHAR(20), sex CHAR(1), birth DATE);
Load tab-delimited data into a table:
mysql> LOAD DATA LOCAL INFILE “infile.txt” INTO TABLE table_name; (Use n for NULL)
Inserting one row at a time:
mysql> INSERT INTO table_name VALUES (’MyName’, ‘MyOwner’, ‘2002-08-31′); (Use NULL for NULL)
Retrieving information (general):
mysql> SELECT from_columns FROM table WHERE conditions;
All values: SELECT * FROM table;
Some values: SELECT * FROM table WHERE rec_name = “value”;
Multiple critera: SELECT * FROM TABLE WHERE rec1 = “value1″ AND rec2 = “value2″;
Reloading a new data set into existing table:
mysql> SET AUTOCOMMIT=1;
# used for quick recreation of table
mysql> DELETE FROM pet;
mysql> LOAD DATA LOCAL INFILE “infile.txt” INTO TABLE table;
Fixing all records with a certain value:
mysql> UPDATE table SET column_name = “new_value” WHERE record_name = “value”;
Selecting specific columns:
mysql> SELECT column_name FROM table;
Retrieving unique output records:
mysql> SELECT DISTINCT column_name FROM table;
Sorting:
mysql> SELECT col1, col2 FROM table ORDER BY col2;
Backwards: SELECT col1, col2 FROM table ORDER BY col2 DESC;
Date calculations:
mysql> SELECT CURRENT_DATE, (YEAR(CURRENT_DATE)-YEAR(date_col)) AS time_diff [FROM table];
MONTH(some_date) extracts the month value and DAYOFMONTH() extracts day.
Pattern Matching:
mysql> SELECT * FROM table WHERE rec LIKE “blah%”;
(% is wildcard - arbitrary # of chars)
Find 5-char values: SELECT * FROM table WHERE rec like “_____”; (_ is any single character)
Extended Regular Expression Matching:
mysql> SELECT * FROM table WHERE rec RLIKE “^b$”;
(. for char, […] for char class, * for 0 or more instances ^ for beginning,
{n} for repeat n times, and $ for end)
(RLIKE or REGEXP) To force case-sensitivity, use “REGEXP BINARY”
Counting Rows:
mysql> SELECT COUNT(*) FROM table;
Grouping with Counting:
mysql> SELECT owner, COUNT(*) FROM table GROUP BY owner;
(GROUP BY groups together all records for each ‘owner’)
Selecting from multiple tables:
(Example) mysql> SELECT pet.name, comment FROM pet, event WHERE pet.name = event.name;
(You can join a table to itself to compare by using ‘AS’)
Currently selected database:
mysql> SELECT DATABASE();
Maximum value:
mysql> SELECT MAX(col_name) AS label FROM table;
Auto-incrementing rows:
mysql> CREATE TABLE table (number INT NOT NULL AUTO_INCREMENT, name CHAR(10) NOT NULL);
mysql> INSERT INTO table (name) VALUES (”tom”),(”dick”),(”harry”);
Adding a column to an already-created table:
mysql> ALTER TABLE tbl ADD COLUMN [column_create syntax] AFTER col_name;
Removing a column:
mysql> ALTER TABLE tbl DROP COLUMN col;
(Full ALTER TABLE syntax available at mysql.com.)
Batch mode (feeding in a script):
# mysql -u user -p  source batch_file;
Backing up a database with mysqldump:
# mysqldump –opt -u username -p database > database_backup.sql
(Use ‘mysqldump –opt –all-databases > all_backup.sql’ to backup everything.)
(More info at MySQL’s docs.)

前段时间，应飞鸽的需要推出了精彩feedsky；

根据规则自动从150个满足条件的feed中合烧出5个并显示其最新文章；

尝试合烧中…

欢迎对此提出意见