MySQL - Views

Views can be created in MySQL databases to categorize parts.

Example using MySQL Workbench to create a view (category) for inductors.

1) Create the View in the MySQL database.

Select the parts database as shown below

Select +SQL in the ribbon bar below. 

It's below File on the menu.

In the SQL Query Tab enter and execute each query separately..

CREATE VIEW `Resistors` AS select * FROM

`parts`

WHERE

(`parts`.`Part_Type` = 'Resistor')

CREATE VIEW `Capacitors` AS select * FROM

`parts`

WHERE

(`parts`.`Part_Type` = 'Capacitor')

CREATE VIEW `Inductors` AS select * FROM

`parts`

WHERE

(`parts`.`Part_Type` = 'Inductor')

2) Edit the DBLib in Altium. 

Enable the Views and set the Single Key Lookup for each View.

click on image to view

Install the DBLib Library in Altium

click on image to view

Start placing parts . . .

That's it !

Clean Parts

Clean Parts can be used to: 

Find Duplicate Part Numbers

Find Duplicate Descriptions

Find Duplicate Material Control Numbers (MCNs) 

Update Sorted Values.

Archive Unused Files.

That's it !

Octopart

The Parts Frontend includes an Octopart search link.

click on image to view

Note: Octopart is a wholly owned subsidiary of Altium Limited Inc.

That's it !