Create Table in MySQL

Since we've made our database, how about we make a few tables.

Making Tables by means of the GUI

One method for making a table is through the MySQL Workbench GUI. This is a simple choice for the individuals who incline toward graphical UIs.

Regardless of whether you begin by utilizing the GUI, I suggest that you become acquainted with making tables programmatically utilizing the CREATE TABLE explanation.

The CREATE TABLE Statement

The CREATE TABLE proclamation does precisely as the name proposes — it makes a table.

Notwithstanding, you have to give data about the table that you need MySQL to make. For instance, the table name, the section names and their information types, default esteems, limitations, and so on.

Here's the model we utilized in the past page:

{`Make TABLE Fruit (FruitName VARCHAR(20), DateEntered DATETIME);`}

This makes a table considered Fruit that contains two sections: FruitName and DateEntered.

The FruitName section utilizes an information kind of VARCHAR(20), which means it acknowledges information that is a VARCHAR (variable-length string) up to 20 characters in length.

The DateEntered segment utilizes an information kind of DATETIME which implies that the section acknowledges DATETIME group (a date and time) in the accompanying configuration YYYY-MM-DD HH:MM:SS.

You can determine that a segment ought to dependably contain a worth (that it ought not be {"invalid"}). To do this, incorporate NOT NULL in that section's particulars (model underneath).

On the off chance that you endeavor to embed information that isn't in the configuration determined for that section, you will get a blunder.

Make Multiple Tables

To make numerous tables you just include a CREATE TABLE articulation for each table you have to make.

{`
Make TABLE table_1 (...);
 Make TABLE table_2 (...);
 `}

Example

We recently made an unfilled database called {"FruitShop"}. In any case, we didn't make any tables at the time. We should refresh the content with the goal that it makes a database and two tables. We'll add some more stuff to the code.

DROP DATABASE IF EXISTS FruitShop;
Make DATABASE FruitShop;
USE FruitShop;
Make TABLE Units (
UnitId TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
UnitName VARCHAR(10) NOT NULL,
DateEntered DATETIME NOT NULL,
DateUpdated TIMESTAMP DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP,
Essential KEY (UnitId)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
Make TABLE Fruit (
FruitId SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
FruitName VARCHAR(45) NOT NULL,
Stock SMALLINT UNSIGNED NOT NULL,
UnitId TINYINT UNSIGNED NOT NULL,
DateEntered DATETIME NOT NULL,
DateUpdated TIMESTAMP DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP,
Essential KEY (FruitId),
Imperative fkFruitUnits FOREIGN KEY (UnitId)
REFERENCES Units (UnitId)
ON DELETE RESTRICT ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

Run the above content and after that invigorate the left segment of MySQL Workbench. You should see your recently made FruitShop database recorded under the SCHEMAS tab.

Grow the Tables hub and you'll see the tables you just made:

MySQL Create Table 1

You can likewise grow each table to see its segments and whatever other items that you made for that table.

Show Table Information Programmatically

You can likewise show table data programmatically. That is, by entering a SQL direction to show the data you need.

In the accompanying model, we set the default database to be FruitShop by utilizing USE FruitShop. We at that point approach MySQL to show all tables for the default database (by utilizing SHOW TABLES):

{`
USE FruitShop;
 SHOW TABLES;
 `}

You can likewise discover the structure of a given table by utilizing the accompanying order (basically supplant the table name with the table you need the structure of):

Portray Fruit;

Here's the aftereffect of that order on our database:

MYSQL Tutorials

• Create MySQL Database
• Create Table in MySQL
• Insert data to MySQL
• Mysql Queries
• Update data in MYSQL
• Delete data in MySQL
• Default Database
• Primary Key
• Foreign Keys
• Views
• Export MySQL Database
• Import data into Mysql
• Create Website with MySQL

MYSQL Sample Assignments

• COIT20247 Database Design and Development
• Relational schema and MySQL database
• Mysql Project
• ITICT107A Introduction to Databases
• MySql Assignment Question

MYSQL Sample Solutions

• Solution - COIT20247 Database Design
• Solution - Relational schema and MySQL
• Solution - Mysql Project

Testimonials

Very affordable projects!! And that to submit before deadlines. Thanks for helping me in my database project and raising my grades. I have been able to secure good marks in my internal assessment only because of you. Read More