Primary Key vs Unique Key What's the difference between primary keys and unique keys? Learn how to define a unique key, how to use the key for relationships and more. Generating Alter Scripts for MySQL Learn how to compare MySQL schema and generate alter scripts for changes detected by Luna Modeler - a database design tool. MySQL database design Luna Modeler - a data modeling tool for MySQL database design. Learn how to draw ER diagrams and generate SQL scripts easily. Primary and foreign keys in MySQL projects How to define primary keys, foreign keys and primary foreign keys in Luna Modeler, a tool for database design for MySQL and other platforms Generating SQL script for MySQL How to generate SQL scripts for MySQL database design in Luna Modeler — a data modeling and ER diagram tool for MySQL and other databases. Visualization of existing MySQL databases Connect to MySQL and reverse engineer existing database structures. Visualize databases and create ER diagrams. Advanced Copy and Paste in Luna Modeler See how to copy and paste one or more tables or individual columns in your ERD. Find out how to work with dependencies in Luna Modeler. Updating MySQL projects Read how to create a new database connection and update your existing MySQL ER Diagram created in Luna Modeler - a database design tool. Primary Key vs Foreign Key What's the difference between primary keys and foreign keys? Learn how to define a primary key, a foreign key, and how to visualize JSON.
