Scripts posted recently tagged to sql in Kelpi

create database database_name;
grant all on database_name.* to 'user_name'@'host_name' [identified by 'user_password']

if distinct_ids != []:
   ids = "("+", ".join(distinct_ids)+")"
   commented_photos = Photo.objects.extra(where=['id IN '+ids])

SELECT *
FROM erosketak_erosgaia e, erosketak_produktua p
WHERE e.erosgai_mota_id_id = p.mota_id
AND e.id NOT
IN (

 UPDATE `pasarteas` SET `zintaren_kodea` = 'ELG-022' WHERE `zintaren_kodea` = 'BER-123'

# su - mysql
# mysql
CREATE DATABASE databasename;
GRANT ALL PRIVILEGES ON databasename.* TO "user"@"hostname" IDENTIFIED BY "password";
FLUSH PRIVILEGES;

# su - postgres
# psql
CREATE USER username WITH PASSWORD 'password' CREATEDB CREATEUSER;

select tag, subfieldcode, subfieldvalue, tagorder, subfieldorder  
from marc_subfield_table where bibid = '565'
order by tag, tagorder, subfieldcode, subfieldorder;

insert into bisitak (field1, field2, field3) 
values (v1,v2,v3)

#Open the file
f = open('26.log','r')
#some variables
ITEMS = total_log_lines = TAGS = BOOL = SELECT = POWCounter = 0 
for s in f:

-- http://poeticcode.wordpress.com/2007/01/27/tag-cloud-algorithmlogicformula/

select entity,metric from fact order by metric desc;
select entity,metric from fact ordre by metric desc limit 0,<n>;
select * from (select entity,metric from fact order by metric desc limit 0,<n>) order by entity;