Monday, December 27, 2010

My SQL databases

To connect to a mysql database use the below command from command line

mysql -u DBUSERNAME -h DBSERVER -p DBNAME

DBUSERNAME- user name to connect to the database
DBSERVER- Server where the database is hosted
DBNAME: Database in the mysql server which you will be connecting


After entering the below command you will be prompted to enter your password


Good link to refer for mysql commands


http://www.pantz.org/software/mysql/mysqlcommands.html




To connect to oracle use
Sqlplus


and to find all the tables which are present in the database use
select * from user_objects where object_type = 'TABLE';  


To add sql driver to squirrelsql 


Follow the below link




http://javaboutique.internet.com/tutorials/squirrel/



How to find out sid of your database
http://forums.oracle.com/forums/thread.jspa?threadID=622348

Good links

Here is the link to a interesting article I found in internet.

 Hope this helps people who have similar doubt lingering in their mind

How Facebook makes money:

http://www.businessinsider.com/how-does-facebook-make-money-2010-5

50 things everyone should know:

http://www.marcandangel.com/2008/06/02/50-things-everyone-should-know-how-to-do/

Here is another good link for people who are preparing for technical phone interviews

http://sites.google.com/site/steveyegge2/five-essential-phone-screen-questions

People who are shy to network

http://www.cio.com/article/164300/How_to_Network_12_Tips_for_Shy_People