relational
EF pulling out reference primary keys in a 1-M relationship
In a 1-M relationship, in the many side of the relationship I can pull out the Id of the parent item without doing another query using something like the following:[详细]
2022-12-21 15:10 分类:问答mysql query normal relationship table vs concatenated realtionship table
I have a question about relationships between two tables. Let\'s say we have a table users, and links.[详细]
2022-12-21 06:15 分类:问答Insert 2 rows that are related in both directions in SQL
I have two tables kinda like this: // Person.Details Table: PersonID int [PK] | EmployeeCreatorID int [FK] | FirstName varchar | OtherInfo...[详细]
2022-12-21 00:07 分类:问答Terribly slow SQL query with COUNT and GROUP BY on two columns
I\'m archiving this web forum, which normally gets purged about once a week. So I\'m screen scraping it, and storing it into my database (PostgreSQL).[详细]
2022-12-20 23:00 分类:问答Exclude rows with Doctrine ORM DQL (NOT IN)
I\'m building a chat application with codeigniter and doctrine. Tables: - User - User_roles - User_available[详细]
2022-12-20 20:03 分类:问答Do I need an ORM for simple related queries in PHP/CI?
I started my app very simply following the documentation videos for Codeigniter. I have the following tables:[详细]
2022-12-14 09:53 分类:问答How to store word compositions in a relational database in a normalized way?
I\'m trying to find a nice way to store word compositions of the following form: exhaustcleaningsystem[详细]
2022-12-12 12:17 分类:问答mySQL - Insert into three tables
I recently asked this question. I have a relational database with three tables. The first containts id\'s[详细]
2022-12-11 11:08 分类:问答mysql - query three tables
I have a relational database with three tables. The first containts id\'s that relate to the second. The second contains id\'s that relate to the third. The third contains the results I am after.[详细]
2022-12-11 07:22 分类:问答SQL Server 'object'/'property' relational tables linking to other tables
Excuse the poor title, i can not think of the correct term. I have a database structure that represents objects, objects have types and properties.[详细]
2022-12-09 22:57 分类:问答