SQL Query

This is a Part Librarian Feature.

Copy and Paste one the examples below to the Parts SQL Query form.  

Edit the query statement as needed then select Run SQL Query.

Leave me a comment if you have a favorite query and I'll add it to this growing list.

Thank you for your support

Randy

SELECT *

FROM parts

WHERE parts.[Lib Report] <> ''

ORDER BY parts.[Lib Report];

SELECT *

FROM parts

WHERE parts.Part_Type="Resistor" OR parts.Part_Type="Capacitor" OR parts.Part_Type="Inductor";

SELECT *

FROM parts

WHERE parts.[Lib Report] Like '*'

ORDER BY parts.[Lib Report];

SELECT * 

FROM parts

WHERE ID >= 30015

ORDER BY parts.ID;

SELECT *

FROM parts

WHERE ID BETWEEN 30015 AND 30022;

SELECT *

FROM parts

WHERE parts.[Updated By] LIKE 'rclemmons' AND parts.ID BETWEEN 30015 AND 30022

ORDER BY parts.ID;

SELECT *

FROM parts

WHERE parts.[Updated By] LIKE 'rclemmons' AND parts.[Updated_Date] LIKE '*2020-10-19*'

ORDER BY parts.[ID], parts.[Updated By], parts.[Updated_Date];

SELECT *

FROM parts

WHERE Updated_Date >= '2020-10-16' AND Updated_Date <= '2021-11-16'

ORDER By parts.[Updated_Date];

SELECT *

FROM parts

WHERE parts.[Created By] = 'rclemmons' AND parts.Value = '1K'

ORDER BY parts.ID;

MS Access Examples using Brackets and Quotes: (Librarian Only)

UPDATE Parts SET Parts.[Supplier 1] = "";

UPDATE parts SET Parts.[Supplier 1] = 'DigiKey';

UPDATE parts SET parts.[Supplier 1] = 'DigiKey' WHERE parts.[Supplier 1] is NULL;

UPDATE parts SET parts.[Supplier 1] = 'DigiKey' WHERE parts.[Supplier 1] = 'Digi-Key';

DELETE FROM parts WHERE ID = 30512;

INSERT INTO parts (ID) VALUES (30512);

Select * FROM parts WHERE Sorted_Value IS NULL;

UPDATE parts SET Sorted_Value = 0

'Delete All Records in the Parts Table ! ! ! Warning ! ! !

DELETE FROM parts;

DELETE FROM parts WHERE ID <= 30015;

DELETE FROM parts WHERE ID > 30817;

MySQL Syntax with `accent characters and Single Quotes` : (Librarian Only)

'Delete All Records in the Parts Table ! ! ! Warning ! ! !

TRUNCATE parts.parts

UPDATE parts SET `Symbol Ref` = `Library Ref` WHERE `Symbol Ref` <> `Library Ref`;

UPDATE parts SET `Supplier 1` = ''

UPDATE parts SET `Supplier 1` = '' WHERE `Supplier 1` = 'DigiKey';

UPDATE parts SET `Supplier 1` = 'DigiKey' WHERE `Supplier 1` = '';

UPDATE parts SET `Supplier 1` = NULL

UPDATE parts SET `Supplier 1` = NULL WHERE `Supplier 1` = 'DigiKey';

UPDATE parts SET `Supplier 1` = 'DigiKey' WHERE `Supplier 1` IS NULL;

UPDATE parts SET `Supplier 1` = 'DigiKey' WHERE `Supplier 1` = 'Digi-Key';

'Adjust LIMIT equal to Row Count

UPDATE parts SET Sorted_Value = 0 WHERE Sorted_Value IS Null LIMIT 10000;

That's It !