Relational Database (SQL) 2
This is the second part of Relational database post. We talk about create and delete database and tables in last post. So, in this post I ‘ll hope to give knowledge relevant operations inside tables . Okey , let’s start. First I would like to mentions that what are the kind of operations we can do inside table. You know them. They are insert data, select and get data, delete data, update data as well as join tables , create views and index like wise. Lets refer those things as below. After create database and tables very first we should insert data. Because we don’t do any other operations without any data. So, let’s start from insert data Insert data INSERT INTO table_name( column_names) VALUES (values); Ex-: ...