Skip to content

3rd Creating Table into Database

Asep Septiadi edited this page Oct 24, 2021 · 1 revision

Hi, Coders!

After creating the database in your system DBMS MySQL, you can manage data inside it, Make sure you have access to the database we mean

First Creating the Tables into Database

Below is an explanation of how to create a table in a database in question, Of course, make sure the database created has been accessed / already in USE, Make sure to understand the use of this Query in the previous material

Creating Tables

And here is a Query snippet to create a table

CREATE TABLE tbl_student (
id_student INT(11) PRIMARY KEY,
student_name VARCHAR(50),
address TEXT,
email TEXT,
phone TEXT
);

And here are the results of the execution of the query above

Creating Tables

Clone this wiki locally