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;
Connecting, Sharing and Discovering