Skip to content

An example MariaDB database for storing product GTINs and generating the GS1 check digit and GTIN-14 master case code.

Notifications You must be signed in to change notification settings

dayreiner/gs1_gtin_mariadb

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

Generating GS1 Check Digits and GTIN-14 Case Codes in MariaDB

An example MariaDB database for storing product GTINs and generating the GS1 check digit and GTIN-14 master case code.

After creating the gtin database, you can insert a gtin to test that the check digit and case code are correctly added:

INSERT INTO `gtin` (`GTIN`) VALUES ('04210000526');

After inserting the GTIN-11 value, select it from the table to see the check digit and GTIN-14 master case code.

SELECT * FROM `gtin` WHERE `GTIN` = '04210000526';
+-------------+-------------+------------------+
| GTIN        | Check_Digit | Master_Case_Code |
+-------------+-------------+------------------+
| 04210000526 | 4           | 10042100005261   |
+-------------+-------------+------------------+

About

An example MariaDB database for storing product GTINs and generating the GS1 check digit and GTIN-14 master case code.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published