BaUbhTih

1--
2-- SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
3-- 
4
5--
6-- SHOW VARIABLES LIKE 'collation%';
7--
8
9
10CREATE DATABASE  IF NOT EXISTS `hb_student_tracker`;
11USE `hb_student_tracker`;
12
13--
14-- Table structure for table `student`
15--
16
17DROP TABLE IF EXISTS `student`;
18
19CREATE TABLE `student` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `first_name` varchar(45) DEFAULT NULL,
22  `last_name` varchar(45) DEFAULT NULL,
23  `email` varchar(45) DEFAULT NULL,
24  PRIMARY KEY (`id`)
25) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;