SQL - script - temas sueltos

From Ibbddunq

Revision as of 00:45, 28 April 2009 (view source) Carlos (Talk | contribs) m (SQL - script - temas avanzados moved to SQL - script - temas sueltos) ← Previous diff		Revision as of 01:10, 28 April 2009 (view source) Carlos (Talk | contribs) Next diff →
Line 1:		Line 1:
-	(sólo un punteo)	+	== Cositas chiquitas ==
		+	LIKE
-	Stored procedures	+	IN conjunto finito / NOT IN conjunto finito
		+
		+	== 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);
		+
		+	ROWNUM para MySQL
		+	select @rownum:=@rownum+1 rownum, ...
		+	from (select @rownum=0), ...
		+
		+
		+	== Stored procedures ==
		+
		+
		+	== ¿Más elaborados? ==
	INSERT INTO ... SELECT ...		INSERT INTO ... SELECT ...

---

Revision as of 01:10, 28 April 2009

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

Cositas chiquitas

LIKE

IN conjunto finito / NOT IN conjunto finito

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);

ROWNUM para MySQL

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

Stored procedures

¿Más elaborados?

INSERT INTO ... SELECT ...