Companies to watch

Companies to watch in big data
http://www.greentechmedia.com/content/images/reports/leading-vendors-soft-grid.png

Europe Tech Awars

Hi!

Just discover a europe tech awards site :
http://www.theeuropas.com

ping it there are great startup´s there.

tecbea

Quick mysql datatable export into file

Hi ,
just as easy to export a datatable as this:

SELECT * FROM table into outfile '/home/user/table.sql';

regds,
tecbea

Quick Pivot Table with Mysql

Hi,
a pivot table is easy to make on mysql:


replace into tablea
select tableb.col1
from tableb as tableb
where 1=1
;

But the secret for a good pivot table is that we can make business logic on the query:

1)   count(case when c like '%something%' then 1 end) as col2

2)  other aggregation functions can be used like avg, ...


best
tecbea

Mysql procedure to quick insert test data

Hi,
usually a procure for mysql quick insert data can be done like this:


DELIMITER $$

DROP PROCEDURE IF EXISTS sampleData$$
CREATE PROCEDURE sampleData()
BEGIN
DECLARE x INT;
DECLARE thedate DATETIME;

SET thedate = '2012-12-01';


SET x = 1;
WHILE x  <= 6 DO
SET  x = x + 1;
SET thedate = DATE_ADD(thedate, INTERVAL 1 DAY); 

INSERT INTO `temptable` (`x`, `thedate`) 
VALUES (x, thedate);

END WHILE;


END$$
DELIMITER ;


best,
tecbea

How to show file size on disk

Hi, This scripts shows how to show directory content with size of files:

option 1) using awk

ls -l | awk '{printf "%s %i %s %s %.3fMB %s %i %s %s\n", $1,$2,$3,$4,$5/1024000,$6,$7,$8,$9}' 

 option 2) using ls

ls -las t_ts* --block-size=1M 

best, 
tecbea