mysql与oracle的一些区别。
左右连查询
oracle:(+)
mysql :left join on
函数
oracle:NVL
mysql :IFNULL
日期
oracle:sysdate
mysql :current_timestamp、now()
oracle:TO_DATE('${beginTime} 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
mysql :str_to_date('2010-11-11 11:11:11','%Y-%m-%d %h:%i:%s')
UPDATE table_name SET id = ( SELECT id FROM ( SELECT * FROM table_name WHERE NAME = 'leisure2' ) xx );
增加语句,带select的必须有别名
排序(类似子查询,需要单独套一层)
删表语句,不能有别名
oracle:delete from t_ufw_figure_info_category_rel xx where 1=2;
mysql :delete from t_ufw_figure_info_category_rel where 1=2;
mysql :insert into table values (id,name,select pass from password p where 1=1)
comcat ( 'a','b','c') == abc