information for MYSQL

SHOW CURRENLY DATABASE
mysql> select database();

SHOW COMMAND FOR CREATE DATABASE
mysql> show create database db_name

SHOW COMMAND FOR CREATE TABLE
mysql> show create table table_name

SHOW TABLE INDEX
mysql> show index from table_name

RUN BATCH

shell> mysql -u user_name -p < batch_name
OR
mysql> source batch_name;
OR
mysql> \. batch_name;

ADD/DROP VALUE IN TABLE

ADD NEW VALUE TO TABLE


either use insert into or load data


test.txt
xxxx YYY 1999-03-30 \N

mysql> LOAD DATA LOCAL INFILE '/path/test.txt' INTO TABLE pet;
mysql> INSERT INTO table_name VALUES ('xxxx','YYY','1999-03-30',NULL);


UPDATE VALUE IN TABLE


mysql> update table_name set value_name=value where value_name=value


REMOVE ALL VALUE TO TABLE


mysql> delete from pet;

REMOVE TABLE
mysql>  drop table table_name;

Mysql command(BASIC)

shell > mysql -h (hostname) -u (user) -p

-p = with password

mysql> SELECT VERSION(), CURRENT_DATE;
+-----------+--------------+
| VERSION() | CURRENT_DATE |
+-----------+--------------+
| 5.5.23    | 2012-05-06   |
+-----------+--------------+
1 row in set (0.02 sec)

exit the mysql command shell - (ctrl+c / quit)
cancel the current command - (\c)

SHOW EXISTING DATABASE
mysql> show databases;

CHANGE CURRENT USING DATABASE
shell> mysql -u username -p db_name
mysql> user db_name;

CREATE A NEW DATABASE
mysql> create database db_name;

SHOW CURRENT DATABASE OWNED TABLE
mysql> show tables;

CREATE A NEW TABLE
mysql> create table table_name (column1 type, column2 type, column3 type);

TYPE-> VARCHAR(NO); CHAR(NO); INT();FLOAT();DATE; BOOLEAN

SHOW TABLE DESC
mysql> describe table_name;