Getting started with MySQL Introduction Topic

Examples

• 4

  Getting Started

  edit move example delete share

  4

  Creating a database in MySQL

  CREATE DATABASE mydb;
  

  Return value:

  Query OK, 1 row affected (0.05 sec)

  ---

  Using the created database mydb

  USE mydb;
  

  Return value:

  Database Changed

  Creating a table in MySQL

  CREATE TABLE mytable
  (
    id              int unsigned NOT NULL auto_increment,
    username        varchar(100) NOT NULL,
    password        varchar(100) NOT NULL,
    PRIMARY KEY     (id)
  );
  

  CREATE TABLE mytable will create a new table called mytable.

  id int unsigned NOT NULL auto_increment creates the id column, this type of field will assign an unique numeric ID to each record in the table (meaning that no two rows can have the same id in this case), MySQL will automatically assign a new, unique value to the record's id field (starting with 1).

  Return value:

  Query OK, 0 rows affected (0.10 sec)

  ---

  Inserting a row into a MySQL table

  INSERT INTO mytable ( username, password )
  VALUES ( "myuser", "123456" );
  

  Example return value:

  Query OK, 1 row affected (0.06 sec)

  ---

  Selecting rows based on conditions in MySQL

  SELECT * FROM mytable WHERE username = "myuser";
  

  Return value:

  +----+----------+----------+
  | id | username | password |
  +----+----------+----------+
  |  1 | myuser   | 123456   |
  +----+----------+----------+
  

  3 rows in set (0.00 sec)

  ---

  Show tables in an existing database

  SHOW tables;
  

  Return value

  +----------------+
  | Tables_in_mydb |
  +----------------+
  | mytable        |
  +----------------+
  

  1 row in set (0.00 sec)

  ---

  Show list of existing databases

  SHOW databases;
  

  Return value:

  +-------------------+
  | Databases         |
  +-------------------+
  | information_schema|
  | mydb              |
  +-------------------+
  

  2 rows in set (0.00 sec)

  You can think of "information_schema" as a "master database" that provides access to database metadata.

  ---

  edited Nov 26 at 8:02

  

  

  

  

  

  +6