In Sysmac Studio, create a structure with the same format as the database table. The name should exactly match (Case sensitive) with the names in the table. Use the correct data types. The chart below can be used to match the data types between Sysmac Studio and MySQL. Note: MySQL INT’s = Sysmac DINTs. Also, strings have a null character. Add 1 extra value for the string MySQL varchar(10) = Sysmac String[11]. Unlike Microsoft SQL Server, you have to include the primary key (ID) in the structure. Here is a complete list how the MySQL data types are used in Sysmac Studio.