4 - DDL commands used in MySQL Workbench

 

I have done following things on MySQL workbench using DDL commands--

1- Create a table name employee with emp_id , first_name , last_name , salary.

2-Add a column contact.

3- Rename the column contact to job_code.

4-Deleting the table

 


Create a table name employee with emp_id , first_name , last_name , salary.



Table Generated looks like


Logical structure of table


Add a column contact.


Seeing the new table


Renaming column contact to job_code


Seeing the table


Deleting the table




Comments

Post a Comment

Popular posts from this blog

5 - DML commands used in MySQL WorkBench

Image
DML(Data Manipulation Language)  CREATING A TABLE create table employees( emp_id int not null , first_name varchar ( 20 ) not null , last_name varchar ( 10 ), salary int , primary key (emp_id) ); INSERTING DATA IN TABLE insert into employees(emp_id,first_name,last_name,salary) values ( 1 , 'Zeeshan' , 'Khan' , 50000 ); insert into employees(emp_id,first_name,last_name,salary) values ( 2 , 'Ross' , 'Geller' , 60000 ); insert into employees(emp_id,first_name,last_name,salary) values ( 3 , 'Rachel' , 'Green' , 8000 ); insert into employees(emp_id,first_name,last_name,salary) values ( 4 , 'Joey' , 'Tribbiani' , 99000 ); select * from employees; UPDATING OR CHANGING DATA update employees set last_name= 'Geller' where emp_id= 3 ; select * from employees; DELETING DATA  delete from employees where emp_id= 4 ; select * from employees; OUTPUT GENERATED
Read more

INDEX OF Zeek MySQL

Spring Blog Index Page Basic Concepts of SQL (1-3) OPEN/CLOSE No Title Labels 1 Data, DataBase, DataModel Types & Infrastructure Infrastructure for DATA MODEL Types Of Data Models What is data and database? 2 Concepts of DBMS,RDBMS ,SQL and DBMS vs RDBMS DBMS vs RDBMS RDBMS and its features and SQL features What is DBMS its benefits 3 SQL Starting(Introduction, Data-Types,Constraints and Command-Groups) SQL Data Types SQL Constraints SQL |
Read more