Table of Contents
How to create a Table in MySQL
1: What is a database Table?
Answer: A Database table is a collection of rows and columns that contains relational data.
| Id | DOB | |
| 1 | walikhan@gmail.com | 10.10.1990 |
| 2 | wali@gmail.com | 11.11.1999 |
| 3 | kakar@gmail.com | 10.1.1960 |
2: Open the MySQL Workbench.
3: Select the Schemas.
4: Use the walikhankakar Database.
Command: use walikhankakar
5: Execute the command.
Shortcut key: Ctrl + Enter
6: Categories of Datatypes:
1: Sting (walikhankakar).
2: Numeric (25).
3: Data and Time (10.10.1990).
7: String Data Types:
1: CHAR (size) 0 to 255.
2: VARCHAR (size) 0 to 65535.
3: BINARY (size).
4: VARBINARY (SIZE).
5: TINYTEXT 255 characters.
6: TEXT (size) 65,535 bytes.
7: MEDIUMTEXT 16,777,215 characters.
8: LONGTEXT 4,294,967,295 characters.
9: TINYBLOB 255 bytes.
10: BLOB (size) 65,535 bytes.
11: MEDIUMBLOB 16,777,295 bytes.
12: LONGBLOB 4,294,967, 295 bytes.
13: ENUM (va1i, va2, va13, …) list up to 65535 values.
14: SET (va1i, va12, va13, …) list up to 64 values.
8: Number Data Types:
1: BIT (size) 1 to 64.
2: TINYINT (size) -128 to 127.
3: INT (size) -2147483648 to 2147483647.
4: INTEGER (size).
5: SMALLINT (size) -32768 to 32767.
6: MEDIUMINT (size) -8388608 to 8388607.
7: BIGINT (size) -9223372036854775808 to 9223372036854775807.
8: BOOL.
9: BOOLEAN 0/1.
10: FLOAT (p).
11: DOUBLE (size, d) 255.568.
12: DECIMAL (size, d) Size = 60, d = 30.
13: DEC (size, d)
9: Date Data Types:
1: DATE ‘1000-10-10’ to ‘9999-12-31’
2: DATETIME (fsp) YYY-MM-DD hh:mm:ss
3: TIMESTAMP (fsp).
4: TIME (fsp) hh:mm:ss
5: YEAR four-digit format: 1901
10: Create a Table for users.
Code: CREATE TABLE users
(
id int unsigned,
name varchar(100),
email varchar(150),
password varchar(100),
contact varchar(15),
address text,
dob date,
gender enum(“M”,”F”,”O”),
status boolean
)
11: Execute the command.
Shortcut key: Ctrl + Enter
