Creating Data Tables in MySQL: A Step-by-Step Guide

---

□ A Step-by-Step Guide to Importing Excel Data into MySQL

---

If you followed my previous post, you can easily create a Data Table when importing external data. In this post, I will introduce how to create a Data Table manually.

First, let’s create a database named ‘test_data.’

<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">CREATE DATABASE</mark> test_data

Within this database, I’ll create a Data Table. I aim to create a Data Table like the one shown below.

ID	Reps	Variable	Yield
1	1	Control	116.08
2	2	Control	132.85
3	3	Control	115.98
4	1	Treatment	131.37
5	2	Treatment	108.89
6	3	Treatment	100.35

---

Next, let’s create the structure of Data Table.

<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">CREATE TABLE</mark> test_data.crop_yield (
    ID <mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">INT AUTO_INCREMENT PRIMARY KEY</mark>,
    Reps <mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">INT</mark>,
    Variable <mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">VARCHAR</mark>(15),
    Yield <mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">DECIMAL</mark>(5, 2)
);

<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">SELECT</mark> * <mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">FROM</mark> test_data.crop_yield;

---

Then, I’ll create data.

<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">INSERT INTO</mark> test_data.crop_yield (Reps, Variable, Yield) <mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">VALUES</mark>
    (1, 'Control', 116.08),
    (2, 'Control', 132.85),
    (3, 'Control', 115.98);

<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">INSERT INTO</mark> test_data.crop_yield (Reps, Variable, Yield) <mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">VALUES</mark>
    (1, 'Treatment', 131.37),
    (2, 'Treatment', 108.89),
    (3, 'Treatment', 100.35);
    
<mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">SELECT</mark> * <mark style="background-color:rgba(0, 0, 0, 0)" class="has-inline-color has-vivid-cyan-blue-color">FROM</mark> test_data.crop_yield;

---

---