Quick References #

select * from expenses where date regexp '2013-0[4-5]' limit 2;

select * from expenses where date like '2013-0%' limit 2;

select unix_timestamp(createtime) from expenses limit 1;

select * from student limit 4 offset 9

UPDATE tb1 SET f1=REPLACE(f1, 'abc', 'def');

select Db, IF(IFNULL(User, “”)=”“, DB, User) from db;

apt-get install mysql-server

apt-get install mysql-client libmysqlclient-dev, yum install mysql-devel

easy_install mysql-python

mysql -u$username -p$password -P$port -h$dbhost $dbname

set names utf8;

show databases;

show tables;

describe $tablename;

=mysql -uUSER -pPASSWORD databasename -e “select * from t limit 10”=

mysql -uUSER -pPASSWORD dbname < backup.sql

mysqldump -uUSER -pPASSWORD DATABASE > backup.sql

mysqldump -uUSER -pPASSWORD DATABASE --no-data=true --add-drop-table=false > backup.sql

=GRANT SUPER ON `DBNAME`.`user` TO ‘DBUSER’@’%’=

ALTER TABLE expenses ADD COLUMN createtime timestamp not null default now();

ALTER TABLE expenses DROP COLUMN createtime;

DROP INDEX indexname ON table_name;

create index idindex on table_name(col_name) using btree;

UPDATE mysql.user SET Password=PASSWORD(‘MyNewPass’) WHERE User=’root’; FLUSH PRIVILEGES;

CREATE USER 'myuser'@'%' IDENTIFIED BY 'MYPASSWORD';

GRANT ALL PRIVILEGES ON mydbname.* TO 'myuser'@'%' WITH GRANT OPTION;

apt-get install postgresql postgresql-client postgresql-contrib

brew install postgres

service postgresql status

psql --version

psql -U postgres

CREATE USER tom WITH PASSWORD '';

GRANT ALL PRIVILEGES ON DATABASE launchpad_empty to tom;

/var/lib/pgsql/data/pg_hba.conf, /etc/postgresql/*/main/postgresql.conf

ALTER USER myuser WITH SUPERUSER;

\l

\d

\connect launchpad_dev;

\ds

createdb -O root -T launchpad_dev launchpad_ustack_cn

drop database launchpad_ustack_cn;

psql -h myhost -d mydb -U myuser -W

CREATE USER tom WITH PASSWORD 'myPassword';

CREATE DATABASE anand;