1. MySQL. UTF-8 database creation snippet

    Well, I haven't remembered syntax of database creation in UTF-8 character set with MySQL for quite a long time. Finally I decided to write a little snippet because I used it so often last time.

    CREATE DATABASE database CHARACTER SET utf8 COLLATE utf8_general_ci;
    CREATE USER 'username'@'localhost' IDENTIFIED BY ...
    Tagged as : Linux SQL
  2. Usage of Oracle Database via JDBC

    In this article I want to show you how to use Oracle Database via JDBC. I'm going to describe the easy way of connection to database, creation of table, and fetching, inserting, updating and deleting rows in created table (CRUD).

    What do you need for this?

    First of all ...

    Tagged as : Java SQL

Page 1 / 1