Table command

First, let's look at database creation, deletion, and selection statements.

Database creation statement

CREATAE DATABASE database name;

Drop database statement

DROP DATABASE database name;

Database selection statement

use database name;

Now let's look at the table command
As mentioned earlier, a table is divided into rows and columns as shown in the table.
For example, let's say that the information of students
Fill in the fields with name, major, student number, address, mobile number, etc.
The record will be filled with Hong Gil-dong Electronics 0883433 010-111-111.
To create a table, create a database before creating the table, select the database and create it with CREATE TABLE.
As mentioned earlier, you should also set the type such as int.
If you set the type to char when you set the type to char (10)
If you enter 5 bytes of char in the char value, the remaining 5 bytes are blanked out. If you enter a character that is longer than 10 bytes, it will be truncated from 10 bytes.
varchar is a variable-width string. Both char and varchar can be up to 255 characters long.
If you set varchar (10) and enter 5 characters, characters are padded from the left and no spaces are created. It is different from char.
It can use memory efficiently. It has the advantage of being slow, but it is expected that it will not make any difference.
Use varchar more than char.

The length of the string data type.

Numeric

When using numeric data, use int or integer for integers and double for real numbers. For integers with large numbers, use unsignet int or bigint.

Don't memorize this and just pass it like this for mental health or time savings.
If you're studying programming for the first time, I'm sure you'll memorize everything perfectly.
When I study programming for the first time, it takes me a few days to memorize each one of them.
Absolute light.