How does select query works – Mysql
I need to return value in preference order, if the value starts with a it should be returned first, if it does not exist we return the value which starts with b. SELECT value FROM table one WHERE value LIKE…
In Postgres, is overall indexing time for a column dependent on row count or on table disk space usage? – Postgresql
I'm working with a few large row count tables with a commonly named column (table_id). I now intend to add an index to this column in each table. One or two of these tables use up 10x more space than…
How to get the overall count in a multiple selection system with ranking – Mysql
I am designing a database for a web project in which I am trying to collect users' emotional feelings toward art collections. A hybrid dual list on the website allows users to select three options from 12 options and then…
How to count matching Sell-Orders for all Buy-Orders with dynamic attributes? – Mysql
I want to retrieve all buy orders with a count of matching buy orders in a single query. A match would be a sell order that satisfies all attributes (greater or equal) and is cheaper than the buy order. Is…
Postgres DATE_TRUNC not behaving as expected – incorrect data showing – Postgresql
I have the following records that were created_at: 2022-11-13 14:24:02.651809 2022-11-13 15:00:43.878400 2022-11-13 16:33:18.710288 2022-11-13 18:22:59.220246 2022-11-13 18:50:59.719803 2022-11-15 20:33:19.099264 2022-11-16 15:42:51.285751 2022-11-16 15:46:28.196001 2022-11-16 16:06:31.873187 2022-11-16 16:47:32.071435 2022-11-16 19:05:38.288788 When I run: SELECT DATE_TRUNC('day', CAST(forms.created_at AS DATE) AT TIME…
Laravel 8 database query – How do I build this collection of related data? – PHP
I am trying to figure out how to form my database query to build up a collection of projects, each of which has a set of personnel with their assigned working periods and the daily shift hours that they submit.…
table i created is not showing in SSMS even after refreshing – Mysql
i saved a table in my SSMS database but its not showing even after i refresh it. any idea what should be done??
How to loop through an array in SQL where clause? – Mysql
I have a MySQL table which has the following columns and records: | Name | Total | GivenBy | | ---- | -------- | ------------ | | Z | 200 |['A','B','C'] | | X | 240 |['A','D','C'] | I would…
Nested SQL call – Postgresql
EDIT: As requested, our table schema is, posts: postid (primary key), post_text comments: commentid (primary key) , postid (foreign key referencing posts.postid), comment_text replies replyid (primary key) commentid (foreign key referencing comments.commentid) reply_text I have the tables posts, comments, and…
Mongodb – Can't find/update an object in an array
My collection looks like this: (Don't ask me why it's an array inside of a collection) const postsSchema = mongoose.Schema({ posts: {type: Array}, }) I want to find a document in it and I tried this: Posts.aggregate([ { $match:{ 'posts':…