<div class="image-550">
<img src="https://cdn.kahimyang.com/resources-25/go-mysql.avif" alt="MySQL/MariaDB Using Golang" loading="lazy" />
</div>
<h3>
Prerequisites
</h3>
<p>
Before diving in, ensure you have:
</p>
<ol style="margin-left: -15px">
<li>
Go installed (version 1.21 or later recommended).
</li>
<li>
MySQL or MariaDB running locally or on a server.
</li>
<li>
A basic database and table set up (we’ll create one below).
</li>
<li>
The MySQL Go driver installed. Run this command to get it:
</li>
</ol>

<pre style="font-size: 90%;">
<code class="language-bash normalize-whitespace line-numbers" >
go get -u github.com/go-sql-driver/mysql
</code>
</pre>
<p>
To ensure that the MySQL driver is added as a dependency to your project's <b>go.mod</b> file, keeping it tied to your specific project, run <b>go get -u github.com/go-sql-driver/mysql</b> inside your project folder (i.e., where the go.mod file is located).
</p>

<h3>
Setting Up the Database
</h3>
<p>
For this example, let's create a simple <b>users</b> table to store user information. Connect to your MySQL/MariaDB instance (e.g., via the <b>mysql</b> command-line tool or a GUI like phpMyAdmin) and run the following SQL:
</p>

<pre style="font-size: 90%;">
<code class="language-sql normalize-whitespace line-numbers" >
CREATE DATABASE IF NOT EXISTS mydb;
USE mydb;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE
);
</code>
</pre>
<p>
This creates a database <b>mydb</b> with a <b>users</b> table containing <b>id</b>, <b>name</b>, and <b>email</b> columns.
</p>


Performing CRUD Operations in MySQL/MariaDB Using Golang