Opera 9.50 web browser released

Opera has released yet another version of its flagship web browser by the same name. It comes with unique features, many of which are not yet available on alternate web browsers out of the box.

I have always found using Opera to be a pleasant experience. Some of the new features found in Opera are as follows :

1. Opera Link : For the very first time, all your bookmarks, speed dial and notes taken in Opera web browser will follow you around where ever you go. You can even access them from your mobile phone. The catch being you have to be using an Opera web browser. Opera provides space on their server to store your bookmarks and other settings which makes this possible.
2. Quick Find : Opera keeps track of not only the web addresses you visit but also words from pages you have visited. So if you do not remember the web address but remember a word on the web page, typing it in the address bar will let you zero in on the exact web page.
3. Better fraud protection.
4. A sharper skin.
   

Opera also claims that -

It’s faster, lighter and pushes us further out in front of other browsers, by blending the mobile and desktop worlds together in new and powerful ways.

But let the end users be the people who decide that. Why not visit Opera and download the latest version namely 9.5 and take it for a spin ? For all you know, you might get hooked to yet another fabulous web browser.

Free Web Hosting Without Ads

If we have a/some blogs, webhosting is important to support our blog running. web hosting is use for put our files such as images, sound, script, videos and many more. We can use use paid hosting or free hosting, but I suggested you to use 000webhost as your web hosting. 000webhost is a free web hosting service with full feature and no force ads. 000webhost is an amazing web hosting service. It's free web hosting that gives many features such as:

- 250 MB Disk Space
- 100 GB Data Transfer
- cPanel Control Panel
- Fantastico De Luxe 1-Click Autoinstaller
- Website Builder Software
- PHP Scripts Autoinstaller
- MySQL Databases
- Curl, GD2 library, ImageMagick, Zend
- and much more features are enabled

But to make your web hosting running well you must folow their rule.
Here is the most important rules:

1. No adult content or any kind.
2. No warez / hacking / phishing sites
3. No mass mailers / spammers (account will be automatically suspended if you will try to send mass mail), so if your software supports such feature, disable it right now.
4. We do not allow any public image or file hosting server scripts to be run.
5. Chat, proxy, or file download scripts are not allowed.
6. Paid-to-surf, auto-surm, buxto, and any other similar scripts are banned
7. We do not allow online gaming scripts such as ogame, mafia, etc..
8. Nulled software such as ip.board or vbulletin is not allowed to be hosted
9. Account cannot be used only to store files.

What are you waiting for, just SIGN UP HERE

Free Web Hosting Without Ads

If we have a/some blogs, webhosting is important to support our blog running. web hosting is use for put our files such as images, sound, script, videos and many more. We can use use paid hosting or free hosting, but I suggested you to use 000webhost as your web hosting. 000webhost is a free web hosting service with full feature and no force ads. 000webhost is an amazing web hosting service. It's free web hosting that gives many features such as:

- 250 MB Disk Space
- 100 GB Data Transfer
- cPanel Control Panel
- Fantastico De Luxe 1-Click Autoinstaller
- Website Builder Software
- PHP Scripts Autoinstaller
- MySQL Databases
- Curl, GD2 library, ImageMagick, Zend
- and much more features are enabled

But to make your web hosting running well you must folow their rule.
Here is the most important rules:

1. No adult content or any kind.
2. No warez / hacking / phishing sites
3. No mass mailers / spammers (account will be automatically suspended if you will try to send mass mail), so if your software supports such feature, disable it right now.
4. We do not allow any public image or file hosting server scripts to be run.
5. Chat, proxy, or file download scripts are not allowed.
6. Paid-to-surf, auto-surm, buxto, and any other similar scripts are banned
7. We do not allow online gaming scripts such as ogame, mafia, etc..
8. Nulled software such as ip.board or vbulletin is not allowed to be hosted
9. Account cannot be used only to store files.

What are you waiting for, just SIGN UP HERE

MySQL - Cheat Sheet

MySQL is a small, fast and highly configurable DBMS. It supports a number of different table fileformats, depending on the requirements of the user.

These are the main MySQL clients and processes (mysqld):

• mysqld - MySQL server daemon
• safe_mysqld - Server process monitor
• mysqlaccess - Tool for creating MySQL users
• mysqladmin - Utility for administering MySQL
• mysqldump - Tool for dumping the contents of a MySQL database. Useful for backing up a database from within the console.
  
• mysql - Command line interface to MySQL
• mysqlshow - List all MySQL database
• Mysql Administrator - This is a GUI tool which makes administering mysql database a painless task. Read more about it here.
  

Field Types in SQL

INTEGER - A whole number
VARCHAR(10) - Up to 10 characters.
CHAR(10) - Fixed number of characters
DATE - A date
DATETIME - Date and time
FLOAT - Floating point numbers

Field Types specific to MySQL

TEXT - Allows up to 65535 characters
DECIMAL(10,2) - Up to 10 digits before the point, 2 after.

Create a database

$ mysqladmin --user=ravi --password=xxx create database addressdb

Using the database

$ mysql --user=ravi --password=xxx
mysql> USE addressdb

Create a table

mysql> CREATE TABLE p_addr (i INTEGER PRIMARY KEY,address TEXT,email VARCHAR(30),pincode DECIMAL(10),phone DECIMAL(15),website TEXT);

Add a column called "name" to the table

mysql> ALTER TABLE p_addr ADD name VARCHAR(30);

Inserting values into table

mysql> INSERT INTO p_addr VALUES (1,"My, present, address","ravi@localhost",681024,2122536, "http://linuxhelp.blogspot.com","Ravi");

List the contents of the table

mysql> SELECT * FROM p_addr;

Delete a row from the table

mysql> DELETE FROM p_addr WHERE i=1;

Rename a column in the table from "address" to "home_address"

mysql> ALTER TABLE p_addr CHANGE address home_address INTEGER;

Note: You cannot use this method to rename a column which is a primary key.

Change an existing record in the table

mysql> UPDATE p_addr SET name="Sumitra" WHERE i=2;

Delete the table from the database

mysql> DROP TABLE p_addr;

List the databases

$ mysqlshow --user=ravi --password=xxx
+-----------+
| Databases |
+-----------+
| addressdb |
| myblog    |
| mysql     |
| test      |
+-----------+

List the tables in the database "addressdb"

$ mysqlshow --user=ravi --password=xxx addressdb

Database: addressdb
+---------+
| Tables  |
+---------+
| p_addr  |
| mytble  |
| phonebk |
+---------+

These are only a subset of the commands in mysql. But this will be enough for creating and maintaining a simple database.

Free Domain co.cc

Do you feel your blog name is too long?
If we create a blog, use blogspot or wordpress service, we have to make a name to our blog, it should be like "name.blogspot.com" or "name.wordpress.com". Do you feel it's such as a long name? If we have some money, we can buy a domain, and then our blog name would be like name.com or name.net or name.co.uk name.us etc.

But now, we can to get free domain to cut up our blog name. it's co.cc service. We can register domain to co.cc, our blogname will be like "name.co.cc". It's free, no payment needed, no setup fee and it's easy to setup. I thinnk it's very good service that offer us a free domain name. I have try it for some of my blogs, and it's interesting. So what are you waiting for.....

Free Domain co.cc

Do you feel your blog name is too long?
If we create a blog, use blogspot or wordpress service, we have to make a name to our blog, it should be like "name.blogspot.com" or "name.wordpress.com". Do you feel it's such as a long name? If we have some money, we can buy a domain, and then our blog name would be like name.com or name.net or name.co.uk name.us etc.

But now, we can to get free domain to cut up our blog name. it's co.cc service. We can register domain to co.cc, our blogname will be like "name.co.cc". It's free, no payment needed, no setup fee and it's easy to setup. I thinnk it's very good service that offer us a free domain name. I have try it for some of my blogs, and it's interesting. So what are you waiting for.....

Unbreakable Linux - Free Linux DVD set from Oracle

First it was Ubuntu and now it is Oracle's turn. That is right; here is a wonderful chance to get yourself a DVD set of Oracle's Unbreakable Linux. Essentially Unbreakable Linux is Red Hat Enterprise Linux sans the Red Hat trademarks.

Oracle claims Unbreakable Linux delivers enterprise-class support for Linux with premier backports, comprehensive management, cluster software, indemnification, testing and more, all at significantly lower cost.

Fig: Enter your email id and a password.

Fig: Enter your name and address.

To order your Free DVD of Oracle Unbreakable Linux with free shipping and all, visit this page and click the "Register Now" button. If this is your first visit to the Oracle website, you will have to create an Oracle account. Next enter your shipping address which is the address to which you would like to receive the DVD set and press "Submit". That is it. Oracle will ship you a brand new DVD set of Unbreakable Linux.