Kgz3a74X

1
2
3#set the environment
4
5SET SQL_MODE= "STRICT_ALL_TABLES";
6
7
8-- drop database if exist - BEWARE
9
10DROP DATABASE IF EXISTS db_students;
11
12
13-- create database
14
15CREATE DATABASE db_students;
16
17
18-- use the database
19
20USE db_students;
21
22
23
24# drop table if exist
25
26#DROP TABLE IF EXISTS tbl_students;
27
28-- Create table for database
29
30CREATE TABLE tbl_students (
31
32
33student_id CHAR(10) PRIMARY KEY,
34
35student_name varchar(50) NOT NULL,
36
37student_age TINYINT UNSIGNED,
38
39student_email VARCHAR(70) NOT NULL,
40
41student_fees DECIMAL(7,2),
42
43student_jobdesired VARCHAR(100),
44
45student_favsite varchar(100)
46
47
48
49);
50
51# insert data into the table
52INSERT INTO tbl_students(student_id,student_name,student_age,student_email,student_fees,student_jobdesired,student_favsite) VALUES('200388937','Ishan',19,'Ishanpatel671@gmail.com',6700.50,'PHP DEVELOPER, Database Administrator','www.google.com, www.javatpoint.com');
53
54#insert partial fields
55
56INSERT INTO tbl_students(student_id,student_name,student_email) VALUES('ALPHAC','Umang', 'umangpatel2121@gmail.com');
57
58
59#describe table structres
60
61DESCRIBE tbl_students;
62
63#show all table details
64
65SELECT *FROM tbl_students;