Perintah dasar mysql melalui cmd

Now I will continue the second part of the MySQL database tutorial. Which in the previous section I have written the basic structure of the MySQL database. All of this tutorial I will discuss with a simple so that you all can easily understand. If any of the writing or the lack of understanding of this tutorial, please give your comment.


BASIC SQL

    * Create a new database.
    * Create a new table.
          o Type column
          o Indexes and Keys
    * Manipulation of data.
          o inserting
          o Retrieving
          o Updateing
          o Deleting
    * Change the table.
1. Creating a New Database

    * Display database

          mysql> SHOW DATABASES;

    * Create a database

          mysql> CREATE DATABASE [Name databasemu];

    * Using a database

          mysql> USE [Name databasemu];

    * Delete a database

          mysql> DROP DATABASE [Name databasemu];
2. Creating a New Table

    * Display table

          mysql> SHOW TABLES FROM [Name databasemu];

    * Create table

          mysql> CREATE TABLE [Name tablemu] ([column name] [column type], [...]);

      For example:

          mysql> CREATE TABLE member (ID int (100), Name varchar (255));

    * Displays column

          mysql> SHOW COLUMNS FROM [Name tablemu];

    * Removing table

          mysql> DROP TABLE [Name tablemu];
Type column commonly used in MySQL:

    * Type String
          o char
          o varchar
          o text
          blob o
    * Type Numeric
          o int
          o tinyint
          o int zerofill
          o int not null
          o float
          o double
          o decimal
Adds Indexing and Keys into the Table:

    mysql> ALTER TABLE [Name tablemu] ADD INDEX ([column name to assign to index]);
For example:

    mysql> ALTER TABLE member ADD INDEX (Name);

    mysql> CREATE TABLE [Name tablemu] ([column name] [column type], [...], PRIMARY KEY ([name of the column that want to be given key]));
For example:

    mysql> CREATE TABLE member (ID int (100), Name varchar (255), PRIMARY KEY (ID));
3. Data Manipulation

    * Entering data

          mysql> INSERT INTO [Names tablemu] ([column name]) VALUES ([Content / Value column]);

      For example:

          mysql> INSERT INTO member (ID, Name) VALUES (1, "Yustian");

    * Update data

          mysql> UPDATE [Name tablemu] SET [Name column] = [Fill / column value] WHERE [Condition of the desired data];

      For example:

          mysql> UPDATE members SET name = "Yustian" WHERE ID = 1;

    * Deleting data

          mysql> DELETE FROM [Name tablemu] WHERE [Condition of the desired data];

      For example:

          mysql> DELETE FROM WHERE ID = 1 member;
4. Changing Table

    * Rename a table

          mysql> ALTER TABLE [Name tablemu] RENAME [new name];

      For example:

          mysql> ALTER TABLE RENAME member of my members;

    * Adding a column to the table

          mysql> ALTER TABLE [Name tablemu] ADD [column name] [column type], [...];

      For example:

          mysql> ALTER TABLE member ADD Name char (100);

    * Delete column

          mysql> ALTER TABLE [Name tablemu] DROP [column name];

      For example:

          mysql> ALTER TABLE DROP member's name;

    * Changing the name and type column

          mysql> ALTER TABLE [Name tablemu] CHANGE [column name] [new column name] [column type], [...];

      For example:

          mysql> ALTER TABLE CHANGE member Username Name varchar (255);
Similarly, some of MySQL are still many more articles that will I write in this YusianBlog among operators in the MySQL, MySQL Query and many more. Hopefully it can all help you to learn MySQL with ease.
Share it to your friends..!