SQL - script - temas sueltos

From Ibbddunq

Revision as of 01:23, 28 April 2009 (view source) Carlos (Talk | contribs) ← Previous diff		Current revision as of 13:56, 4 May 2009 (view source) Carlos (Talk | contribs)
Line 4:		Line 4:
	IN conjunto finito / NOT IN conjunto finito		IN conjunto finito / NOT IN conjunto finito
		+	LIMIT (desde,)cuantos
		+
		+	IFNULL
	== Cositas no tan chiquitas ==		== Cositas no tan chiquitas ==

---

Current revision as of 13:56, 4 May 2009

Contents 1 Cositas chiquitas 2 Cositas no tan chiquitas 3 Stored procedures 4 Vistas 5 ¿Más elaborados?

Cositas chiquitas

LIKE

IN conjunto finito / NOT IN conjunto finito

LIMIT (desde,)cuantos

IFNULL

Cositas no tan chiquitas

Capacidad de agrupar según el resultado de una función. P.ej.

 -- cantidad de funciones por mes
 select month(diaFn) as mes, year(diaFn) as anio, count(*)
 from formaParte
 group by month(diaFn), year(diaFn);

Stored procedures

Vistas

¿Más elaborados?

ROWNUM para MySQL

 select @rownum:=@rownum+1 rownum, ...
 from (select @rownum=0), ... 

INSERT INTO ... SELECT ...