CONCEPTS ABOUT HOW TO CREATE A TABLE NAME "dept" USING MYSQL QUERY IN MYSQL DATABASE AND HOW TO USE INSERT INTO STATEMENT AND VALUES

Table Name - dept

1. uid - int(A_I)

2. deptname - varchar(200) - HR CEO DEVELOPER DESIGNER TELECALLER SWEEPER BACKSTAFF

3. dept_address - varchar(200) - Any

4. dept_no - int(200) - 101 102 103 104 105 106 107

5. Headname - varchar(200) - Any

Hi All, Now I am going to show you how to create a table `dept` in phpMyAdmin Database using MYSQL Query.

QUERY TO CREATE A TABLE NAME `dept` => 

CREATE TABLE `dept` (deptname varchar(200), dept_address varchar(200), dept_no int(200), Headname varchar(200))

SQL QUERY OF uid (AUTO INCREMENT PRIMARY KEY) =>

ALTER TABLE `dept` ADD COLUMN `uid` int AUTO_INCREMENT PRIMARY KEY FIRST

SQL QUERY OF HOW TO USE INSERT INTO STATEMENT AND VALUES IN A TABLE WITHIN A DATABASE =>

INSERT INTO `dept` (`deptname`,`dept_address`, 'dept_no`, `Headname`) VALUES ('HR', 'Madhyamgram', 101, 'Bhaskar'), ('CEO', 'Madhyamgram', 102, 'Abhishek'), ('DEVELOPER', 'Madhyamgram', 103, 'Anirban'), ('DESIGNER', 'Saltlake', 104, 'Amlan'), ('TELECALLER', 'Madhyamgram', 105, 'Ankit'), ('SWEEPER', 'Barasat', 106, 'Ranjit'), ('BACKSTAFF', 'Barasat', 107, 'Prosenjit')