Add Data to Tables in a Database

After you have created a table in database the next step is to add data to that table.Now the data that you will add to the table may consist of one, more than one but less than the required number or all of the parameters specified in the table.The number of parameters depends upon the actions and also the scripts that you are executing and it differs from case to case.

To simplify if you want to add username and password but put all other parameters optional in your script than the data is added to the table inside the database only when a username and a password is entered.In that case it doesn't matter if all other fields are left blank or filled.So basically, by putting up various conditions you can add data to tables in multiple number of ways.

For Adding data to tables - 

INSERT INTO table_name(field1, field2, field3) VALUES('value1', 'value2', 'value3');

To view table content - 
SELECT * from table_name;

Write Your First C++ Program and Compile it Using Microsoft Visual C++

A simple C++ "Hello World" program consists of several lines of code.Many of those lines are included in each and every C++ program.The first line consists of inclusion of a header file that lets us use all basic commands.Then we create our main function and inside main function we write our body.We use a standard output stream command to output our text.The steps for writing your first program are as follows:-

1.Install Microsoft Visual C++ 2010 Express 

2.Create a new project. 

3.Add a new file.

4.Write the simplest C++ code for a "hello world" program.

5.Debug it.

Install Microsoft Visual C++ 2010 Express on Windows

C++ Programming language is one of the efficient and user friendly programming language for writing any program.It is an object oriented language and has many useful applications.To get started with C++ install Microsoft Visual C++ express edition on your computer and you are good to write and execute C++ code.Microsoft Visual C++ consists of both IDE and compiler for writing and executing C++ programs.
Download Link: http://www.microsoft.com/express/Downloads/

If you are unable to get a full version of Microsoft Visual C++ then watch this tutorial "How to Install Code Blocks"

Write and Execute Java Programs By Downloading Eclipse IDE

Usually as a programmer we like make things simple and easy for our own benefit. Similarly, when writing JAVA programs we always use an Integrated Environment instead of writing the program at one place and running it at an other place. ECLIPSE IDE is such an integrated environment where we can write and run java programs. It is open source and thus freely available and easy to handle.

Download Link : http://www.eclipse.org/downloads/

Create a Database and Add Tables to it in MySQL Command Line

MySQL is one of most basic database application language and is very easy to deal with. The applications of MySQL go in hand to hand with any scripting language.It is very much useful to deal with situations where data manipulation is to be specific and ordered.

Various commands are given below:

*Connecting to a database---mysql -u username -p password -h hostname It is by default mysql -u root -p -h 127.0.0.1;

*Seeing the different databases present---show databases;
*Creating a database---create database database name;
*Creating tables---create table table_name(parameters);

Install Java Development Kit (JDK) and Get Started With Java Programming

Java Tutorial : Install java development kit on your computer, then you can write java programs on notepad and compile and run them using cmd.You have to set the path of compiler by going to environment variables in computer properties.

JDK Download link: http://www.oracle.com/technetwork/java/javase/downloads/index.html
Steps for Setting up java compiler
(1) Install Jdk
(2) Go to the installed java folder. Then go to "bin" folder inside.
(3) Right click on any of the files and go to properties. Copy the Location.
(4) Go to my computer.Right click on it and go to properties.
(5) Click on environment variables(it may be inside Advanced System Settings).
(6) Create a new environment variable having name "Path" and value as whatever location You copied.
(7) Now Your compiler is ready.