MariaDB Create Database Tables Columns Manage Databases Using HeidiSQL

MariaDB tutorial : how to create database table and column database in MariaDB database using HeidiSQL Databases management.

MariaDB tutorial - How To Create and Manage Databases in MariaDB or MySQL using HeidiSQL databases management? Create MariaDB database using HeidiSQL is very simple to manage your MariaDB or MySQL database will be faster and easier than when using the web based.

Please Read :

1. How to Install MariaDB on Windows step by step
2. How to create MySQL Database on Windows

HeidiSQL features :

1. HeidiSQL is Open Source
2. Connection to many servers at once in just one application
3. Connect to the server via commandline
4. Connect via SSH tunner, or pass the SSL settings
5. Create and edit tables, view, stored routines, triggers and scheduled events
6. Export the database or table to the SQL format
7. Manage users (user) including ha access easily
8. Export from one server/database directly into another database/server
9. Import text files
10. Export table in the form of CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
11. Browse and edit table with grid user friendly
12. Batch insert ACSII or files into binary table
13. Write queries with syntax highlighting and code completion
14. Optimization and repair tables from many databases at once

Create MariaDB Database using HeidiSQL

Open your HeidiSQL databases manage application, we'll create new database.
On our connection, right click and add new databases.

Rename your database and click on OK. 

Or, you can use this simple SQL query to create new database.

CREATE DATABASE `java_project` /*!40100 COLLATE 'latin1_swedish_ci' */;

now, we will create new table for java_project database, Right click on your database -> create new -> table

Design your table look like this picture

To add Primary Key to our column like "id_users" column, just right click on colum name and create Index and add Primary

After finished, click on save.
Or you can add this query to make your columns.

CREATE TABLE `users` (
 `id_users` INT NOT NULL,
 `username` VARCHAR(50) NULL,
 `nama` VARCHAR(100) NULL,
 `password` VARCHAR(100) NULL
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB;

Now you have a new database, tables and columns in MariaDB database. To insert new data into our database just create this sql query

INSERT INTO `java_project`.`users` (`id_users`, `username`, `nama`, `password`) VALUES (1, 'harison', 'harison matondang', '12345');

To show all data in Users tables

SELECT * FROM users

If you're still confused, just watch video tutorial below :

Video tutorial How to Create MariaDB Database

See you next Lessons