5 Important mySQL Development scripts

During database review most useful object I used information_ schema and show tables. Now I feel ease to work on mysql, either from command line or most popular tool workbench.  Since 2014 mysql added into my skill set and till now 3-4 projects.  Last year I have posted  5-important-shortcut-and-tips-to-work on workbench and today I am sharing  5 more commands what I am using for development and review on mysql database projects.

1.       How to insert or populate data in one table from another table?

2.       How to update one table from another table?

3.       How to create and use temporary table?

4.       How to Check Table Property from command line?

5.       How to check all indexes from one table?

How to insert or populate data in one table  from another table?

insert into user2  SELECT * FROM setting.user;

How to update one table from another table?

UPDATE temp p, word pp SET pp.name= p.name, pp.describe = p.describe WHERE pp.id = p.id;

How to create and use temporary table ?

CREATE TEMPORARY  TABLE `user2` (

….

..

)

insert into user2 SELECT * FROM user;

select * from user2;

How to Check Table Property from command line ?

SHOW CREATE TABLE user;
or 
Describe user ;

How to Check all indexes from one table ?

                Show index from user;