MySQL Forums :: Database Design & Data Modelling


Advanced Search

Announcements Last Post
MySQL Enterprise Monitor 3.0.27 has been released 08/22/2016 12:00PM
MySQL Connector/NET 7.0.4 m3 development has been released 08/22/2016 08:36AM
MySQL Utilities 1.6.4 GA has been released 08/05/2016 10:44AM
MySQL Enterprise Backup 4.0.3 has been released 08/05/2016 09:28AM
MySQL Notifier 1.1.7 has been released 08/01/2016 04:37PM
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
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
Incorrect charset while inserting and showing records   Agustin Cardeilhac 07/21/2015 12:59PM
Re: Incorrect charset while inserting and showing records   Peter Brawley 07/21/2015 01:19PM
enforcing uniqueness across tables   paul denny 07/12/2015 01:31PM
Re: enforcing uniqueness across tables   Peter Brawley 07/12/2015 04:31PM
Re: enforcing uniqueness across tables   Rick James 07/12/2015 09:53PM
Re: enforcing uniqueness across tables   paul denny 07/13/2015 10:39AM
Re: enforcing uniqueness across tables   Peter Brawley 07/13/2015 11:56AM
Re: enforcing uniqueness across tables   paul denny 07/13/2015 12:41PM
Re: enforcing uniqueness across tables   Peter Brawley 07/18/2015 09:04AM
Re: enforcing uniqueness across tables   paul denny 07/20/2015 01:00PM
Implementing relationship with the EER   jean-marc fournier 07/18/2015 04:55AM
Re: Implementing relationship with the EER   Peter Brawley 07/18/2015 09:10AM
Re: Implementing relationship with the EER   jean-marc fournier 07/19/2015 03:37AM
Re: Implementing relationship with the EER   jean-marc fournier 07/19/2015 08:58AM
Re: Implementing relationship with the EER   Peter Brawley 07/19/2015 09:45AM
Re: Implementing relationship with the EER   jean-marc fournier 07/19/2015 10:12AM
Hierarchical DATA Model to improve performance   jongse park 07/09/2015 12:19AM
Re: Hierarchical DATA Model to improve performance   Peter Brawley 07/09/2015 09:41AM
Re: Hierarchical DATA Model to improve performance   jongse park 07/09/2015 07:14PM
Re: Hierarchical DATA Model to improve performance   Peter Brawley 07/09/2015 11:03PM
storing start/end times   Dimitris Papageorgiou 04/01/2015 12:35AM
Re: storing start/end times   Peter Brawley 04/01/2015 07:11AM
Re: storing start/end times   Dimitris Papageorgiou 04/01/2015 12:23PM
Re: storing start/end times   Peter Brawley 04/01/2015 01:26PM
Re: storing start/end times   Dimitris Papageorgiou 04/01/2015 11:21PM
Re: storing start/end times   Peter Brawley 04/02/2015 10:48AM
Re: storing start/end times   Dimitris Papageorgiou 04/02/2015 11:32AM
Re: storing start/end times   Peter Brawley 04/07/2015 04:25PM
Re: storing start/end times   Dimitris Papageorgiou 04/08/2015 07:59AM
Re: storing start/end times   Peter Brawley 04/08/2015 11:04AM
Re: storing start/end times   Dimitris Papageorgiou 04/08/2015 01:04PM
Re: storing start/end times   Peter Brawley 04/08/2015 10:11PM
Re: storing start/end times   Dimitris Papageorgiou 04/09/2015 06:50AM
Re: storing start/end times   Peter Brawley 04/09/2015 11:10AM
Re: storing start/end times   Dimitris Papageorgiou 04/12/2015 02:13AM
Re: storing start/end times   Peter Brawley 04/12/2015 10:33AM
Re: storing start/end times   Dimitris Papageorgiou 04/15/2015 08:39AM
Re: storing start/end times   Peter Brawley 04/15/2015 11:30AM
Re: storing start/end times   Dimitris Papageorgiou 04/16/2015 05:38AM
Re: storing start/end times   Peter Brawley 04/16/2015 08:38AM
Re: storing start/end times   Dimitris Papageorgiou 04/16/2015 09:42AM
Re: storing start/end times   Peter Brawley 04/28/2015 01:49PM
Re: storing start/end times   Dimitris Papageorgiou 04/28/2015 10:40PM
Re: storing start/end times   Peter Brawley 04/30/2015 11:34AM
Re: storing start/end times   Dimitris Papageorgiou 05/04/2015 10:12AM
Re: storing start/end times   Peter Brawley 05/11/2015 10:56AM
Re: storing start/end times   Dimitris Papageorgiou 05/14/2015 12:01PM
Re: storing start/end times   Peter Brawley 05/14/2015 03:32PM
Re: storing start/end times   Dimitris Papageorgiou 05/18/2015 09:13AM
Re: storing start/end times   Peter Brawley 05/18/2015 10:48AM
Re: storing start/end times   Dimitris Papageorgiou 05/21/2015 12:06PM
Re: storing start/end times   Dimitris Papageorgiou 04/02/2015 04:14AM
Re: storing start/end times   Dimitris Papageorgiou 04/07/2015 10:02AM
Re: storing start/end times   Dimitris Papageorgiou 04/17/2015 06:49AM
Re: storing start/end times   Dimitris Papageorgiou 04/20/2015 08:12AM
Re: storing start/end times   Dimitris Papageorgiou 06/24/2015 08:05AM
Database 'mysql' is not included in the list of reachable databases while using the 'mysql -u mysql' command.   gerard sauvage 06/16/2015 08:33AM
restoring databse on wampserver   Ayushmaan Bahukhandi 06/03/2015 05:15AM
Re: restoring databse on wampserver   Peter Brawley 06/03/2015 10:33AM
Re: restoring databse on wampserver   Ayushmaan Bahukhandi 06/04/2015 05:20AM
Re: restoring databse on wampserver   Peter Brawley 06/04/2015 08:44AM
Re: restoring databse on wampserver   Ayushmaan Bahukhandi 06/05/2015 12:39AM
Re: restoring databse on wampserver   Peter Brawley 06/05/2015 12:50PM
creating a database for tracking shipments - design help needed   Chris Bassett 06/04/2015 12:35PM
Multiple Foreign Keys in the Same Table   Jim Beck 05/27/2015 03:36PM
Re: Multiple Foreign Keys in the Same Table   Peter Brawley 06/03/2015 10:32AM
This topic has been moved.:  trigger in multiple loop   Mehmet TEPE 05/11/2015 11:01AM
efficiency issue   Dimitris Papageorgiou 04/30/2015 10:16AM
Re: efficiency issue   Peter Brawley 04/30/2015 11:37AM
Re: efficiency issue   Dimitris Papageorgiou 04/30/2015 11:51AM
Database Design 3rd normal form question   David Villarreal 04/22/2015 07:19PM
Re: Database Design 3rd normal form question   Rick James 04/24/2015 05:23PM
Collection Datatype in MYsql   Shailesh Jain 04/05/2015 10:37PM
Re: Collection Datatype in MYsql   Rick James 04/07/2015 02:48PM
Re: Collection Datatype in MYsql   Peter Brawley 04/07/2015 04:17PM
database design suggestion   Christian Nuvoli 04/02/2015 09:49AM
Re: database design suggestion   Peter Brawley 04/02/2015 10:39AM
BEFORE INSERT trigger > how to rollback the insertion   Jakub Małecki 04/01/2015 12:04PM
Re: BEFORE INSERT trigger > how to rollback the insertion   Peter Brawley 04/01/2015 01:36PM
Re: BEFORE INSERT trigger > how to rollback the insertion   Jakub Małecki 04/02/2015 08:36AM
Big table (too big?) how to handle?   chris arndt 03/23/2015 12:36PM
Re: Big table (too big?) how to handle?   Peter Brawley 03/23/2015 01:14PM
Re: Big table (too big?) how to handle?   Rick James 03/23/2015 04:05PM
storing the schedules   Dimitris Papageorgiou 03/23/2015 02:06AM
problem with trigger update   mitch reward 03/20/2015 05:13AM
Re: problem with trigger update   Peter Brawley 03/20/2015 11:11AM
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.