Wednesday, July 24, 2013

MySQL Copy one column in a table to another column in another table

I had two tables. One had a status field that I wanted in another table.

Below is the diagram showing the two tables:

To get it to copy the data, I just used the command below:

 update tablea  
     inner join  
   tableb ON tablea.Task_id = tableb .Task_id  
 set   
   tablea.status= tableb .status;  

Monday, November 12, 2012

Rounded Corners in Pulsonix PCB CAD Program

Tried to do nice rounded corners but found it hard to find in the documentation.

The way to do it is, click on the corner, then right click and select fillet.

Choose your radius and away you go.


Finished corner: