Learn LaTex with Martin

  1)Create a database named "Employee" CREATE database Employee; 2) Create a table named "payroll" CREATE TABLE payroll(name varchar(20),emp_id varchar(10),mobile int(10),email varchar(20),salary int(10),pf int(10),total_work_days int(10),emp_work_days int(10),extra_shifts int(12)) INSERT INTO `payroll` (`name`, `emp_id`, `mobile`, `email`, `salary`, `pf`, `total_work_days`, `emp_work_days`, `extra_shifts`) VALUES ('princy', '21ER', '45645456', 'princy@gmail.com', '20000', '10000', '30', '27', '2'), ('james', '13ER', '65766564', 'james@gmail.com', '50000', '1200', '31', '28','3'),('rosy','24ER','78878787','rosy2gmail.com','23000','1230','31','20','1'),('tina','24ER','76656545','tina@gmail.com','26000','2000...

 ADBMS Lab MYSQL Database Queries Create Database Mysql>CREATE DATABASE sjcds; Show Database mysql> SHOW DATABASES; Use Database mysql> USE emplyeedb; Drop Database DROP DATABASE [IF EXISTS] database_name; Create Table mysql> CREATE TABLE employee_table( id int NOT NULL AUTO_INCREMENT, name varchar(50) NOT NULL, degree varchar(35) NOT NULL, age int NOT NULL, PRIMARY KEY (id) ); Show Tables mysql> SHOW TABLES; Alter table ALTER TABLE cus_tbl ADD mobile int(10) NOT NULL; Drop Table mysql> DROP TABLE orders; Truncate Table TRUNCATE TABLE table_name; Rename Table RENAME TABLE stu_table TO student_table; Insert Table CREATE TABLE People(     id int NOT NULL AUTO_INCREMENT,     name varchar(45) NOT NULL,     occupation varchar(35) NOT NULL,     age int,     PRIMARY KEY (id) ); INSERT INTO People VALUES (102, 'Joseph', 'Developer', 30), (103, 'Mike', 'Leader', 28), (104, 'Step...

 22