Salesforce.com Learn & Share
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 set of commands which modify the data itself. A few…
Read MoreHere is top 10 examples of (RDMS) Relational database management systems. Oracle MySQL Microsoft SQL server PostgreSQL DB2 Microsoft access Sq Lite Sybase Tera data Fire bird (321)
Read More1.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 have the department ID of each employee, then we can…
Read MoreA Database Management System (DBMS) is described as a set of computer programs that manages the creation, maintenance, and administration of a database. It is a system software package that…
Read More1. 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 will not occupy any space. Both are differed with respect…
Read MoreHow 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 that you have created a mysql database and within it…
Read More