Internet solutions team

Note : T=Table, C=Column, C2 for T1 and T2 got same values.

 I want to update T1.C1 values from T2.C1. What would be the SQL Query.

update T1 set T1.C1=T2.C1 from T2inner join T1 on T2.C2=T1.C2

Above sql query will update all values from table 2 column 1 to table 1 column1 where table1 and table2 have same values in column2 of each table. Above query has been tested on Microsoft Sql Server and should work with MsAccess, MySQl , Oracle and all database which support SQL.

Database is a set of rows and columns. We use database to store information in it and we can retrieve that information on demand. To manipulate database we use SQL (Structured Query Language.)

There are many database or DBMS (Database Management System) are available few re-known are Oracle, SQL Server, MySql, Sybase etc.

Which database should I choose?

Choosing database is difficult, as all databases perform the basic task of storing database. It depends on your business needs and your budget as, database vary in price and at some point they are different in functionalities also. Before choosing database you should consult with a qualified organisation or individual. You can find differences between databases on internet. It would be worth tou look at differences and prices before choosing database.

What are front end and back end?

Front end is UI (User Interface) which you see e.g. any web site is a front end or any application which you see is a front end. Term back end commonly used for database. Data are stored at back end. Those data then cab be representd on Front end which shows meanings to a user.