CREATE TABLE Statement (SQL) - Creating Database Tables

In SQL, the CREATE TABLE statement is used to create new tables in our database. When doing so, we need to be specify the table name, field names, and field datatypes. This video covers CREATE TABLE, DROP TABLE, and TRUNCATE TABLE.

[lovinalansana]

Thank you so much. You explain it so well.

[JimmyKhammanh]

Hello Mr, Baldwin.

I'm new to SQL and I am trying to create a sample table . I have MYSQL and I'm trying to learn. Can you explain to me what am I doing wrong.

Thank you.


CREATE TABLE foods(
food_id INT,
food_type VARCHAR (255),
food_region VARCHAR (255),
food_weight DECIMAL (10, 2);
PRIMARY KEY (tool_id)
);