MySQL Forums :: Database Design & Data Modelling


Advanced Search

Announcements Last Post
MySQL for Visual Studio 2.0.5 m4 release has been released 04/25/2017 04:25AM
MySQL Connector/Python 2.1.6 GA has been released 04/18/2017 08:49AM
MySQL Router 2.1.3 GA has been released 04/12/2017 12:17PM
MySQL Shell 1.0.9 GA has been released 04/12/2017 12:16PM
MySQL Cluster 7.5.6 has been released 04/11/2017 02:22AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 19
Subject Written By Posted
Sticky:  MySQL Workbench for Database Design & Modeling (1 Posts)   Edwin DeSouza 03/30/2008 12:16AM
Time Series Schema   Ayman Imbabi 04/21/2017 02:06PM
Re: Time Series Schema   Peter Brawley 04/21/2017 07:37PM
dynamic schema modeling and performance   RJ Ewing 04/12/2017 07:47AM
natural key duplicates   etl metaprogramming 04/04/2017 08:21AM
Re: natural key duplicates   Peter Brawley 04/04/2017 09:57AM
How to create a View that hides the tables behind   Christian Esborg 03/22/2017 04:04AM
Re: How to create a View that hides the tables behind   Christian Esborg 03/23/2017 03:44AM
Re: How to create a View that hides the tables behind   Peter Brawley 03/23/2017 11:32AM
Re: How to create a View that hides the tables behind   Christian Esborg 03/27/2017 03:48AM
Re: How to create a View that hides the tables behind   Peter Brawley 03/27/2017 10:33AM
Re: How to create a View that hides the tables behind   Christian Esborg 03/28/2017 07:26AM
Re: How to create a View that hides the tables behind   Christian Esborg 03/27/2017 03:41AM
Purchasing, selling and Stocking of products.   Ora Ora 02/24/2017 12:51PM
Re: Purchasing, selling and Stocking of products.   Peter Brawley 02/24/2017 05:46PM
Re: Purchasing, selling and Stocking of products.   Ora Ora 02/25/2017 11:00AM
Re: Purchasing, selling and Stocking of products.   Peter Brawley 02/25/2017 01:59PM
Re: Purchasing, selling and Stocking of products.   Ora Ora 03/02/2017 05:31PM
Re: Purchasing, selling and Stocking of products.   Peter Brawley 03/02/2017 05:58PM
Re: Purchasing, selling and Stocking of products.   Ora Ora 03/03/2017 01:16PM
Re: Purchasing, selling and Stocking of products.   Peter Brawley 03/03/2017 02:31PM
Re: Purchasing, selling and Stocking of products.   Ora Ora 03/03/2017 03:01PM
Re: Purchasing, selling and Stocking of products.   Peter Brawley 03/03/2017 03:54PM
Re: Purchasing, selling and Stocking of products.   Ora Ora 03/04/2017 12:00PM
Re: Purchasing, selling and Stocking of products.   Ora Ora 03/04/2017 04:26PM
Re: Purchasing, selling and Stocking of products.   Peter Brawley 03/04/2017 06:48PM
Re: Purchasing, selling and Stocking of products.   Ora Ora 03/05/2017 02:26AM
Re: Purchasing, selling and Stocking of products.   Peter Brawley 03/05/2017 11:34AM
Re: Purchasing, selling and Stocking of products.   Ora Ora 03/06/2017 09:40AM
Re: Purchasing, selling and Stocking of products.   Peter Brawley 03/06/2017 11:21AM
Question about recurring text in database field   Macamba . 03/01/2017 07:24AM
Re: Question about recurring text in database field   Peter Brawley 03/01/2017 11:16AM
Alert me Purchasing, selling and Stocking of products.   Ora Ora 02/21/2017 03:06AM
SQL simple CMS design   Danny Maitland 02/17/2017 10:11AM
Too many tables; MySQL can only use 61 tables in a join   Devrishi Shandilya 02/14/2017 12:53AM
Re: Too many tables; MySQL can only use 61 tables in a join   Peter Brawley 02/14/2017 03:42AM
Multiple foreign keys to a same column in a primary table   Vishwath L 01/13/2017 07:13AM
Re: Multiple foreign keys to a same column in a primary table   Vishwath L 01/13/2017 08:20AM
Efficient index design for alternating NULL values   Martin Luy 01/02/2017 07:15AM
Re: Efficient index design for alternating NULL values   Martin Luy 01/02/2017 07:24AM
Foreign Key Redundancy   Kevin Kowitski 12/12/2016 10:05PM
Re: Foreign Key Redundancy   Peter Brawley 12/12/2016 11:25PM
Middle table - One or Many Relationship   Redshot Alpha 11/29/2016 08:06PM
This topic has been moved.:  UPDATE TABLE based on a SELECT query   Ahmad Sakhi 11/28/2016 05:02PM
usage of LIKE, compare 2 fields.   Ahmad Sakhi 11/13/2016 07:52PM
Re: usage of LIKE, compare 2 fields.   Peter Brawley 11/13/2016 08:56PM
Storing GPS data   Borko Lepojevic 10/16/2016 12:58PM
Re: Storing GPS data   Rick James 10/19/2016 11:34PM
Best Practices for Many Millions of Rows   Darren Brooks 10/15/2016 12:30AM
Re: Best Practices for Many Millions of Rows   Rick James 10/16/2016 04:22PM
ASON - Anthony's Simple Object Notation   Anthony Stump 09/11/2016 08:30AM
2 Unique FKs in single Table   Manuel Maurer 08/03/2016 10:10AM
Re: 2 Unique FKs in single Table   Rick James 08/04/2016 11:04PM
Re: 2 Unique FKs in single Table   Manuel Maurer 08/05/2016 04:06AM
Re: 2 Unique FKs in single Table   Rick James 08/06/2016 05:05PM
Re: 2 Unique FKs in single Table   Manuel Maurer 08/08/2016 02:54AM
Re: 2 Unique FKs in single Table   Rick James 08/14/2016 06:07PM
Re: 2 Unique FKs in single Table   Manuel Maurer 08/15/2016 03:54AM
How to count nodes in a binary tree stored in MySql in it's left and right and dynamically respond on new addition of node   Omkar Khalipe 07/02/2016 07:59AM
Re: How to count nodes in a binary tree stored in MySql in it's left and right and dynamically respond on new addition of node   Rick James 07/09/2016 10:37PM
Re: How to count nodes in a binary tree stored in MySql in it's left and right and dynamically respond on new addition of node   Omkar Khalipe 07/20/2016 04:59AM
Re: How to count nodes in a binary tree stored in MySql in it's left and right and dynamically respond on new addition of node   Peter Brawley 07/22/2016 07:55AM
Implementing Hybrid tenant database Architecture with mysqli   Sam Ranuva 07/22/2016 03:11AM
Design HRM software   Hai Luong 06/28/2016 06:04AM
Re: Design HRM software   Peter Brawley 06/28/2016 05:12PM
Re: Design HRM software   Hai Luong 06/28/2016 07:19PM
Re: Design HRM software   Rick James 07/09/2016 11:07PM
What should be my PK?   Ahmad Sakhi 05/18/2016 07:39AM
Re: What should be my PK?   Peter Brawley 05/18/2016 09:38AM
Re: What should be my PK?   Ahmad Sakhi 05/18/2016 09:42AM
Re: What should be my PK?   Peter Brawley 05/18/2016 09:46AM
Re: What should be my PK?   Ahmad Sakhi 05/18/2016 09:50AM
Re: What should be my PK?   Peter Brawley 05/18/2016 08:01PM
Re: What should be my PK?   Rick James 05/23/2016 04:13PM
Re: What should be my PK?   Ahmad Sakhi 06/04/2016 08:53PM
Re: What should be my PK?   Peter Brawley 06/05/2016 08:18AM
Re: What should be my PK?   Ahmad Sakhi 06/05/2016 11:40AM
Re: What should be my PK?   Peter Brawley 06/06/2016 04:34PM
Re: What should be my PK?   Rick James 06/07/2016 03:52PM
Re: What should be my PK?   Ahmad Sakhi 06/08/2016 08:10AM
Re: What should be my PK?   Rick James 06/08/2016 09:03PM
Re: What should be my PK?   Ahmad Sakhi 06/09/2016 07:55AM
Re: What should be my PK?   Rick James 06/13/2016 01:51AM
Re: What should be my PK?   Ahmad Sakhi 06/16/2016 09:38AM
Re: What should be my PK?   Rick James 06/20/2016 12:45AM
Multiple Foreign keys from 1 child to 1 parent discussion   Philip Curtis 06/06/2016 12:43PM
Re: Multiple Foreign keys from 1 child to 1 parent discussion   Peter Brawley 06/06/2016 04:53PM
Re: Multiple Foreign keys from 1 child to 1 parent discussion   Philip Curtis 06/08/2016 01:15PM
Re: Multiple Foreign keys from 1 child to 1 parent discussion   Peter Brawley 06/08/2016 06:56PM
Move MySQL data to different location   Ahmad Sakhi 05/27/2016 08:09AM
Re: Move MySQL data to different location   Peter Brawley 06/05/2016 08:22AM
Efficient way to LOAD large amount of DATA.   Ahmad Sakhi 05/18/2016 07:12PM
Re: Efficient way to LOAD large amount of DATA.   Peter Brawley 05/18/2016 08:04PM
Re: Efficient way to LOAD large amount of DATA.   Ahmad Sakhi 05/19/2016 12:47PM
Re: Efficient way to LOAD large amount of DATA.   Peter Brawley 05/23/2016 10:34AM
Re: Efficient way to LOAD large amount of DATA.   Rick James 05/23/2016 03:58PM
INDEX before OR after data LOAD   Ahmad Sakhi 05/13/2016 07:00AM
Re: INDEX before OR after data LOAD   Peter Brawley 05/13/2016 08:32AM
Re: INDEX before OR after data LOAD   Ahmad Sakhi 05/13/2016 08:51AM
Re: INDEX before OR after data LOAD   Peter Brawley 05/13/2016 09:28AM
Re: INDEX before OR after data LOAD   Ahmad Sakhi 05/13/2016 01:26PM
Re: INDEX before OR after data LOAD   Rick James 05/23/2016 03:35PM
Partitioning   Ahmad Sakhi 04/19/2016 12:29PM
Re: Partitioning   Rick James 04/20/2016 11:34PM
Re: Partitioning   Ahmad Sakhi 04/21/2016 07:47AM
Re: Partitioning   Rick James 04/22/2016 06:41PM
Re: Partitioning   Ahmad Sakhi 04/22/2016 06:59PM
Re: Partitioning   Rick James 04/23/2016 05:11PM
Re: Partitioning   Ahmad Sakhi 04/25/2016 09:27AM
Re: Partitioning   Ahmad Sakhi 04/30/2016 05:08PM
Re: Partitioning   Rick James 05/04/2016 11:41PM
Re: Partitioning   Ahmad Sakhi 05/09/2016 09:18AM
Re: Partitioning   Rick James 05/10/2016 10:15AM
Re: Partitioning   Ahmad Sakhi 05/11/2016 08:11AM
Re: Partitioning   Ahmad Sakhi 05/17/2016 07:49AM
Re: Partitioning   Rick James 05/23/2016 03:21PM
Convert InnoDB to MyiSAM   Ahmad Sakhi 05/19/2016 12:55PM
Re: Convert InnoDB to MyiSAM   Rick James 05/23/2016 09:10AM
ROW locking.   Ahmad Sakhi 04/27/2016 01:08PM
Re: ROW locking.   Peter Brawley 04/27/2016 01:27PM
Re: ROW locking.   Ahmad Sakhi 04/27/2016 01:37PM
Re: ROW locking.   Peter Brawley 04/30/2016 07:31PM
Are lots of tables a bad idea?   Dan Wade 04/19/2016 08:06AM
Re: Are lots of tables a bad idea?   Peter Brawley 04/19/2016 08:29AM
Query Performance Decrease   Mike Wilson 03/15/2016 04:14PM
Re: Query Performance Decrease   Rick James 03/16/2016 04:48PM
Re: Query Performance Decrease   Mike Wilson 03/18/2016 01:15PM
Re: Query Performance Decrease   Rick James 03/19/2016 11:03PM
Re: Query Performance Decrease   Peter Brawley 03/17/2016 10:04AM
Re: Query Performance Decrease   Mike Wilson 03/18/2016 01:13PM
Which config for large concurrent additions   Inbox Roel 03/14/2016 03:10PM
Re: Which config for large concurrent additions   Rick James 03/15/2016 11:42PM
Re: Which config for large concurrent additions   Inbox Roel 03/16/2016 01:11PM
Re: Which config for large concurrent additions   Rick James 03/16/2016 06:17PM
Re: Which config for large concurrent additions   Rick James 03/16/2016 06:19PM
Re: Which config for large concurrent additions   Inbox Roel 03/17/2016 01:56AM
Composite vs Single Foreign Keys   Mike Ferris 03/11/2016 09:46AM
Re: Composite vs Single Foreign Keys   Peter Brawley 03/11/2016 10:56AM
Subqueries in views   John King 01/07/2016 03:41AM
Re: Subqueries in views   Peter Brawley 01/07/2016 11:22AM
Table with Text values   Gilad Granit 12/13/2015 09:28AM
Re: Table with Text values   Peter Brawley 12/13/2015 10:44AM
Re: Table with Text values   Gilad Granit 12/14/2015 01:05AM
Re: Table with Text values   Peter Brawley 12/14/2015 08:02AM
Re: Table with Text values   Rick James 12/16/2015 10:25PM
Re: Table with Text values   Rick James 12/16/2015 10:27PM
Re: Table with Text values   Gilad Granit 12/17/2015 03:53AM
Re: Table with Text values   Rick James 12/17/2015 01:00PM
Re: Table with Text values   Gilad Granit 12/17/2015 03:52PM
Re: Table with Text values   Rick James 12/18/2015 05:34PM
Creating Index for DateTime   KARTHIKEYAN T 12/09/2015 02:25AM
Re: Creating Index for DateTime   Peter Brawley 12/09/2015 12:12PM
Re: Creating Index for DateTime   Rick James 12/10/2015 11:04PM
How to structure table(s) for change history   Alexander Joseph 11/18/2015 04:45PM
Re: How to structure table(s) for change history   Peter Brawley 12/09/2015 12:13PM
Database table redesign for minimize data and increse performance   Devrishi Shandilya 11/17/2015 12:20AM
Re: Database table redesign for minimize data and increse performance   Rick James 11/26/2015 09:48PM
adding another criteria(the schedule)   Dimitris Papageorgiou 11/24/2015 01:53AM
Re: adding another criterion (the schedule)   Peter Brawley 11/24/2015 10:22AM
appointments availability   Dimitris Papageorgiou 11/02/2015 07:40AM
Re: appointments availability   Peter Brawley 11/02/2015 01:52PM
Re: appointments availability   Dimitris Papageorgiou 11/03/2015 02:46AM
Re: appointments availability   Peter Brawley 11/03/2015 10:59AM
Re: appointments availability   Dimitris Papageorgiou 11/03/2015 01:04PM
Re: appointments availability   Peter Brawley 11/03/2015 01:14PM
Re: appointments availability   Dimitris Papageorgiou 11/03/2015 01:50PM
Re: appointments availability   Peter Brawley 11/11/2015 11:33AM
Re: appointments availability   Dimitris Papageorgiou 11/12/2015 01:23AM
Re: appointments availability   Peter Brawley 11/12/2015 03:50PM
Re: appointments availability   Dimitris Papageorgiou 11/13/2015 07:04AM
Re: appointments availability   Dimitris Papageorgiou 11/13/2015 10:18AM
Re: appointments availability   Peter Brawley 11/13/2015 12:21PM
Re: appointments availability   Dimitris Papageorgiou 11/13/2015 12:25PM
Re: appointments availability   Dimitris Papageorgiou 11/16/2015 02:37AM
Re: appointments availability   Peter Brawley 11/16/2015 12:38PM
Re: appointments availability   Dimitris Papageorgiou 11/16/2015 12:47PM
Re: appointments availability   Peter Brawley 11/17/2015 12:15PM
Re: appointments availability   Dimitris Papageorgiou 11/18/2015 07:00AM
Re: appointments availability   Peter Brawley 11/18/2015 04:00PM
Re: appointments availability   Dimitris Papageorgiou 11/19/2015 12:12PM
Re: appointments availability   Dimitris Papageorgiou 11/20/2015 02:09PM
one value from one of three different tables   Bart Wallace 11/11/2015 01:44AM
Re: one value from one of three different tables   Peter Brawley 11/11/2015 11:58AM
DATABASE UTF 8, memory fields.   STEFANO Chan 10/23/2015 02:00AM
Re: DATABASE UTF 8, memory fields.   STEFANO Chan 10/23/2015 02:42AM
Re: DATABASE UTF 8, memory fields.   STEFANO Chan 10/23/2015 04:05AM
Re: DATABASE UTF 8, memory fields.   Rick James 10/24/2015 08:18PM
A Table Manipulation question. I'm stuck   Paul Zorsky 10/14/2015 10:24PM
Re: A Table Manipulation question. I'm stuck   Peter Brawley 10/15/2015 11:14AM
Re: A Table Manipulation question. I'm stuck   Paul Zorsky 10/15/2015 05:23PM
Re: A Table Manipulation question. I'm stuck   Peter Brawley 10/15/2015 10:10PM
Suggestions for storing URLS to files   Chris Bassett 09/17/2015 10:55PM
Re: Suggestions for storing URLS to files   Rick James 09/21/2015 05:33AM
Design for a massive table (partitioning or sharding)   Bram Van Daele 08/23/2015 07:52AM
Re: Design for a massive table (partitioning or sharding)   Rick James 08/25/2015 12:18PM
Creating a separate to manage SET options   Enyinna Ibekwe 08/14/2015 11:10AM
Re: Creating a separate to manage SET options   Peter Brawley 08/15/2015 09:22AM
Re: Creating a separate to manage SET options   Rick James 08/15/2015 05:07PM
Is Using Multiple Composite Primary key a Good Design Practice?   Abhishek Alney 08/07/2015 04:48AM
Re: Is Using Multiple Composite Primary key a Good Design Practice?   Rick James 08/07/2015 10:52AM
FOREIGN KEY ERROR   Shrinivasa rao 07/30/2015 11:08PM
Re: FOREIGN KEY ERROR   Rick James 08/01/2015 11:19PM
Re: FOREIGN KEY ERROR   Shrinivasa rao 08/02/2015 11:40PM
Re: FOREIGN KEY ERROR   Rick James 08/05/2015 06:18PM
How to implement this constraint   Paul Reiser 07/19/2015 02:18AM
Re: How to implement this constraint   Rick James 07/26/2015 08:48AM
Pages:  1 2 3 4 5 ...Last Next
Current Page: 1 of 19

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.