Posts

Showing posts from 2012

python csv to sql inserts

code below tells why i like python #!/usr/bin/env python import string def main():     file=open('yourfile.txt')     for i in file:         line=string.split(i,',')         print "insert into your_table values ('%s','%s','%s');" % (line[0],line[1],line[2]) if __name__ == '__main__':     main()

bootstrap css library framework from twitter

Are you only coder like me ? Can't you find good and cheap designer for your apps ? Don't you want to bother with basic css and js tricks ? http://twitter.github.com/bootstrap/  is your best friend. Bootstrap is very easy to use css library from well known social platform twitter . They are also using this library in their site. I tried to implement bootstrap library in http://freedjangohosting.com

how to remove dublicates from your mysql table

nice mysql syntax for removing dublicates from your tables strategy as follows clone your table with create table a as select * from b truncate your table truncate b create unique index create unique index u_indx1 on b (x,y,z) insert all rows back to table with ignore insert ignore into b select * from a