Differences between SQL and MySQL

Differences between SQL and MySQL

SQL	MySQL
1.     Dual table required for calculation Eg. Select 4+3 from Dual;	No dual table required for calculation Select 4+3;
2.     Datatype is Varchar2	Dataype is Varchar for variable strings
3.     Number for real numbers Number(s,p)	Decimal (s,p)
4.     Update is only simple without order by clause	Update has the order by clause
5.     For concatenation : Select fname || lname from emp;	Only concat function, No || or +
6.     Insert only for 1 row at a time	Insert multiple rows Insert into emp values(1,’a’),(2,’b),(3,’c’);
7.     Date format is dd-mm-yyyy	Date format is Yyyy-mm-dd,  yy-mm-dd, yyyy/mm/dd, yyyymmdd