Difference between DML (Data Manipulation Language) and DDL (Data Definition Language) DML (Data Manipulation Language) and DDL (Data Definition Language) Subsets of SQL commands: DML (Data Manipulation Language) is the Continue Reading »
Home / Archive by Category "DATABASE"
1.What is the difference between JOIN and UNION? SQL JOIN allows us to “lookup” records on other table based on the given conditions between two tables. For example, if we Continue Reading »
A Database Management System (DBMS) is described as a set of computer programs that manages the creation, maintenance, and administration Continue Reading »
1. Difference between varchar and varchar2 data types? Varchar can store upto 2000 bytes and varchar2 can store upto 4000 bytes. Varchar will occupy space for NULL values and Varchar2 Continue Reading »
How do import from CSV file to Mysql Database using PHPMyAdmin Writing a sql code is not required. Just use the phpMyAdmin interface for uploading the csv file. I assume Continue Reading »