The Economist explains: Why Sweden has so few road deaths | The Economist:
'via Blog this'
Wednesday, December 31, 2014
Tuesday, December 30, 2014
Monday, December 29, 2014
Sunday, December 28, 2014
Wednesday, December 24, 2014
Monday, December 22, 2014
Thursday, December 18, 2014
Monday, December 15, 2014
Tuesday, December 9, 2014
Sunday, December 7, 2014
Friday, December 5, 2014
Thursday, December 4, 2014
Monday, December 1, 2014
Monday, November 24, 2014
Sunday, November 23, 2014
Thursday, November 6, 2014
Friday, October 24, 2014
Thursday, October 23, 2014
Tuesday, October 21, 2014
Monday, October 20, 2014
Sunday, July 6, 2014
Thursday, July 3, 2014
Sunday, March 9, 2014
Friday, February 21, 2014
Saturday, February 8, 2014
Friday, February 7, 2014
Wednesday, February 5, 2014
Friday, January 31, 2014
Wednesday, January 22, 2014
Tuesday, January 21, 2014
Sunday, January 12, 2014
Saturday, January 11, 2014
Tuesday, January 7, 2014
Sunday, January 5, 2014
Saturday, January 4, 2014
Installing MySQL on Ubuntu
- Update the OS
- sudo apt-get update
- Install MySQL
- sudo apt-get install mysql-server (You will be prompted for root password. Dont forget the password)
- It is not advisable to open mysql connections to outside of localhost. However if you must, then
- sudo vi /etc/mysql/my.cnf
- Comment out the line "bind-address 127.0.0.1"
- After install, create a non-root user ID
- mysql -u root -h 127.0.0.1 -p (when prompted enter the root password)
- create user 'userid'@'localhost' identified by 'passwd'
- grant all privileges on *.* to 'userid'@'%' identified by 'passwd' with grant option;
- flush privileges;
- quit
- Restart MySQL
- sudo /etc/init.d/mysql restart
- Create tables, Insert data, Select data
- mysql -u <userid> -h <host name> -p
- create database <db name>;
- use <db name>;
- create table test1 (fname varchar(20));
- insert into test1 values('John');
- select * from test1;
- Install a SQL GUI client (Toad or RapidSQL or SequelPro(for mac), etc)
- For bulk import of a CSV file (reference)
- mysqlimport --ignore-lines=1 --fields-terminated-by=, --columns='ID,Name,Phone,Address' --local -u root -p Database /path/to/csvfile/TableName.csv
- Happy SQLing!
Friday, January 3, 2014
Subscribe to:
Posts (Atom)