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.

MariaDB Create Database Tables Culumns Manage Databases
Rename your database and click on OK. 
MariaDB Create Database Tables Culumns Manage Databases
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
MariaDB Create Database Tables Culumns Manage Databases
Design your table look like this picture
MariaDB Create Database Tables Culumns Manage Databases
To add Primary Key to our column like "id_users" column, just right click on colum name and create Index and add Primary
MariaDB Create Database Tables Culumns Manage Databases
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

COMMENTS

Next Recomended


Feel free to code it up and send us a pull request.

Hi everyone, let's me know how much this lesson can help your work. Please Subscribe and Follow Our Social Media 'kodeajaib[dot]com' to get Latest tutorials and will be send to your email everyday for free!, Just hit a comment if you have confused. Nice to meet you and Happy coding :) all ^^



Follow by E-Mail


Name

ADO.NET,3,Ajax,6,Android,9,AngularJS,4,ASP.NET,4,Blogger Tutorials,7,Bootstrap,7,C++,1,Codeigniter,2,Cplusplus,6,Crystal Report,6,CSharp,25,Ebook Java,2,FlyExam,1,FSharp,3,Game Development,2,Java,35,JDBC,2,Laravel,84,Lumen,2,MariaDB,2,Ms Access,3,MySQL,31,ODBC,6,OleDB,1,PHP,14,PHP Framework,5,PHP MYSQLI,9,PHP OOP,5,Python,8,Python 3,4,SQL Server,4,SQLite,4,Uncategorized,5,Vb 6,2,Vb.Net,89,Video,48,Vue Js,4,WPF,2,Yii,3,
ltr
item
KODE AJAIB: MariaDB Create Database Tables Columns Manage Databases Using HeidiSQL
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.
https://3.bp.blogspot.com/-dnFs3UDmey0/V7wolSftQtI/AAAAAAAACSc/zP8LOzvJmLc7TUYlzJ0ZFNyZC2of4qqsACLcB/s320/create-mariadb-database-using-heidisql-1.png
https://3.bp.blogspot.com/-dnFs3UDmey0/V7wolSftQtI/AAAAAAAACSc/zP8LOzvJmLc7TUYlzJ0ZFNyZC2of4qqsACLcB/s72-c/create-mariadb-database-using-heidisql-1.png
KODE AJAIB
https://www.kodeajaib.com/2016/08/create-database-tables-culumns-mariadb.html
https://www.kodeajaib.com/
https://www.kodeajaib.com/
https://www.kodeajaib.com/2016/08/create-database-tables-culumns-mariadb.html
true
3214704946184383982
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy