首先查询：
MySQL默认不区分大小写，也就是说：
select * from sale_person where identitycard like '%x%';
select * from sale_person where identitycard like '%X%';
查询结果一样
要在查询中区分识别大小写，需要使用binary关键字
select * from sale_person where binary identitycard like '%x%';
select * from sale_person where binary identitycard like '%X%';
这两个结果就不一样了
发现存在不同写法，然后替换
update `sale_person` set `identitycard` = replace(`identitycard`, 'x', 'X');
替换sale_person表中，identitycard字段的所有x为X。
这个替换语句，还可以用来更新网站中的数据，比如批量更改文章图片的alt属性：
update `helloer_thread` set `content` = replace(`content`, 'alt=""', 'alt="www.mqney.com"');
Linux killall svnserve
Windows net stop svn 【停止服务】
sc delete svn 【删除服务】
3D TEXT
Lets add some text to the scene now. Text is just another layer, so we hit the ADD butoon and select 3D TEXT.
You will need to position the text so its centered on the screen and is just in front of the world - you do this by selecting the AXIS tab , dragging the X TRanslate slider to the left and the Z translate slider to the right. You can also scale it down a bit by dragging the x and y scale sliders slightly to the left.
SETTING UP THE SCENE
Now lets add the rest of the scene!
Were going to add two more layers, one for the ESPN Interface and one for the text image. Once you have done this, drag the text interface's Z slider and bring it up close to you by dragging to the right. You will notice that it stops at 500 - to get past this click on the lcd and drag to the right to go over the default limits. Bring it up to around 750.
Ok, now we have our scene set up lets save it out before we animate it in case anyting goes wrong. Select the SCENE tab, and hit SAVE and then double-click on your filename - espn.jsf
If you want to take a snapshot of how things are going, you can click on the PHOTO button located on top of the GRAB DESKTOP button. If you click render by mistake, just hit it again to stop it. To look at your photo, go to the desktop and it will be in the top left hand corner underneat any images that are already there.
ANIMATING THE SCENE!
Ok, now we are going to bring the scene to life. We will start by hiding all the layers we dont want to see. You can do this by un-checking everything except for the world and the first layer you added (The one on top of the world layer).
To make things easier to understand, lets name this layer the earth. To do this, make sure its selected and hit the name button. Type earth in the pop-up box and hit return.
Now we can animate the earth layer! To do this, we first need to make sure we are at the first frame of the animation. Do this by dragging the main horizontal slider, the big one to the right of the vcr looking controls, to the far left. The green LCD should now be set to 00:00:00. We are going to call this slider the scrubber from now on to make things easier.
We are going to have the earth zoom in from outer space on to the scene. To do this, we will need go to the AXIS tab and drag the earths Translate Z slider to the far right. It stops at 500 - but we needs to go to 1000 so you have to click on the green lcd to the right of its z slider and drag that to the far right till it reaches 1000. The earth should dissapear off the screen.
SETTING KEYFRAMES
We want to record this keyframe (position in a animation) so you need to hit the KEY button to the left of the PHOTO button in the middle-right side of the screen.
Now drag the scrubber slider so its in the middle and we will move the earth in and set another keyframe. Drag the z slider and move it back to zero to do this. You can also play with the rotation values as well so the earth will spin around on its way back in. Once you have positioned it hit the key button again.
Now you can drag the scrubber from left to right, or hit the play button, and the earth should fly in and then stop!
We want to do the same thing with the 3d text but we want it to fly in after the earth... so lets set that up.
Drag the scrubber to the far right so the earth is off the screen again. Then hit the checkbox for the 3dtext layer so it turns on, you should see it in the middle of the screen where you left it.
You are going to do the same thing you did for the earth - go to the AXIS tab and click on the trasnlate Z lcd and drag it to the right until the text dissapears off the screen. Then hit the KEY button to record this.
Since we want the text to wait a bit before moving in, we will set anothre keyframe for it out in space before bringing it in. To do this, drag the scrubber and move it about one third of the way to the right or to where the scrubbers lcd reads 00:01:00 and hit the kay button again.
If for some reason the text poped back up thats a bug, just move the scruuber again and it will go back to where it was before setting teh 2nd keyframe.
Then drag the scrubber to where its around 2/3rds the way or towhere its lcd reads 00:02:00. We can now move the text back in by draginfg its Z Translate slider to the left and positioning it just in front of the world and hitting the KEY button.
Now you can drag the scrubber from left to right and you should see the earth fly in followed by the jahshaka text!
If you messed up, just make sure the Earth layer is selected, click the OBJECT tab and hit reset and then animate it again!
Now lets turn on the ESPN interface by clicking its check box. You may want to name it ESPN to make things easier. Hit the play button and you should see your first animation rocking on the screen! You may want to sve it out as a backup.
Ok, we're not ready to sell it to ESPN just yet, now we want to add some fancy overlay graphics. To do this, turn on the lst layer you added, and name it textlayer so you can tell it from the 3DText.
You will want tomake sure the scrubber is back in its far left position. Then go to the AXIS box and move its Z Transalte to where its around 1000. Then move its translate X to the left to where its aroud -50.
EFFECTS
Now we are going to fade it out! Go to the EFFECTS tab and you will see the transparency slider. You will want to drag this to where its round 35 so its slightly faded out.
Now we can animate it so it moves slowly from left to right as our animation plays. To do this just set a keyframe for it a 00:00:00 and then drag the scrubber to the far right and then move it to the right by dragging its AXIS X Translate to the right so it moves over but not off the screen. Then set another keyframe by hittiong the KEY button.
Now you can play it back and enjoy your creation!
RENDERING
In order to make your movie, you will now need to render it out. Dont worry, Jahshaka uses hardware rendering so it renders as fast as it play... although it usually slows down since we have to write the images to disk. To speed this up, we will switch over to the smallest file size whcih is uncompressed jpeg.
To do this, after you have saved your scene out, go to the desktop and hit the prefernces button. You will see a render quality slider, make sure this is set to the far left. Then go back to your animation, make sure the scrubber is also to the far left and hit the render button!
*hint - if your graphics card supports anti-aliasing turn on full scene aliasing (using your cards control panel - control for this will be added later on) and you will get a smooth looking animation!
You creation will now be visible as a clip on the desktop. Go to the dekstop, select it, and hit play to check it out!
ENJOY!
If you are using linux you can use the player to create a mpeg animated clip of your creation using the utility menu. We will bring this functionality to windows soon.
Hope you enjoed the first tutorial, later on we will get into the other modules!
昨天打开火狐FireFox发现就像是Google浏览器chrome一样，出现了“访问最多的网站”，不知道是FireFox升级模仿了Chrome还是Google Toolbar升级集成了Chrome，这些技术人员还真是敬业啊。
但是出现了一个问题，这要是这家伙晚上看了比较私人的东西，第二天到公司当众展示就糗大了。双刃剑啊。
幸好你不喜欢可以关闭，在Google Toolbar--选项--网络浏览工具--启用新的Google标签页，去掉勾选就可以了。
编辑catalina.sh文件，改成如下这样：
# OS specific support. $var _must_ be set to either true or false.
cygwin=false
os400=false
darwin=false
case "`uname`" in
CYGWIN*) cygwin=true;;
OS400*) os400=true;;
Darwin*) darwin=true;;
esac
JAVA_OPTS="-Djava.awt.headless=true"
export JAVA_OPTS
# resolve links - $0 may be a softlink
PRG="$0"
