Archive for the ‘Mysql’ Category

Newer Entries »

MySql: Show, Desc, Info on Database and Table

Wednesday, January 14th, 2009

Show Database

mysql> show databases

Show Tables

mysql> use my_database
mysql> show tables

or Show Table Status for more information

mysql> show table status

Describe Table

mysql> desc my_table

MySql Cheat Sheet

Posted in Mysql | No Comments »

Mysql: Java Web App and MySql 5.x UTF-8

Saturday, November 8th, 2008

To fully support UTF-8 with mysql, make sure of the followings:

  1. Set HttpServletRequest UTF-8 character encoding.
    request.setCharacterEncoding(”UTF-8″);
  2. Set HttpServletResponse UTF-8 character encoding
    response.setContentType(”text/html; charset=UTF-8″);
  3. Create the Column, Table, or DB need to have the UTF8 charset and collation
    CHARACTER SET utf8 COLLATE utf8_general_ci
  4. THE TRICK: Add the character encoding instruction in your JDBC URL
    jdbc:mysql://localhost:3306/DATABASENAME?useUnicode=true&characterEncoding=UTF8

Related links:

Posted in Mysql | 1 Comment »

Mysql: Create Foreign Key

Sunday, October 12th, 2008

Assuming 1 to M from Person to Address:

ALTER TABLE address ADD
CONSTRAINT FK_address_person_id
FOREIGN KEY (person_id)
REFERENCES person(id) ON DELETE CASCADE

MySQL - SQL Table Basics - Table Relationships

Posted in Mysql | No Comments »

Mysql: Create new user

Wednesday, October 1st, 2008

Create a new user:

grant all privileges on yourdatabase.* to youruser@localhost identified by ‘yourpwd’ with grant option;

Posted in Mysql | No Comments »

Mysql: Create Database

Wednesday, October 1st, 2008

Login to mySql:

mysql -u root -p

Create a new Database:

create database YourTableName character set utf8 collate utf8_general_ci

Posted in Mysql | 1 Comment »

Newer Entries »