INNER JOIN returns rows from both tables that satisfy with given conditions. Syntax SELECT column_list FROM table_1 INNER JOIN table_2 ON join_condition; Example SELECT r.rollno, r.name, f.fees, f.status FROM register... READ MORE >>
JOINS are used to retrieve data from multiple tables. It is performed whenever you need to fetch records from one (Self Join), two or more tables based on the common column between the tables and tables are mutually related using primary and... READ MORE >>
Data type specifies the particular type of data used with their possible value and the way of that values to be stored. Different datatype with their size and value are listed below: Data Type Maximum SizeExplanationCHAR(size)Maximum size of 255... READ MORE >>
MySQL MySQL is a very popular high-speed data processing and open-source RDBMS which is used widely such as Facebook, Google, Twitter and Adobe. It uses structured query language(SQL) and it is written in C and C++. It is mainly used in web... READ MORE >>
Recent Comments