<dd id="yld2g"><track id="yld2g"></track></dd>

    1. <th id="yld2g"></th>

      Questions tagged [database]

      A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information. Use this tag if you have questions about designing a database. If it is about a particular database management system, (e.g., MySQL), please use that tag instead.

      Filter by
      Sorted by
      Tagged with
      0
      votes
      0answers
      9 views

      Laravel DB raw query

      I have this Controller called GetChangeInfo public function GetChangeInfo(Request $request){ $customers = Customer::doesntHave('bookings') ->doesntHave('product_baskets') ...
      0
      votes
      0answers
      6 views

      How to set a default order using the primary key for all the rows in a psql database?

      Is there a way to set a default order for all the rows in a table so that I can always retrieve the queryset in the same order in postgres?
      0
      votes
      0answers
      17 views

      Fastest way of performing bulk updates with array of objects in Node-Postgres?

      I'm working with the pg Postgres driver in Node.js, and was wondering what the fastest way of doing bulk updates would be. I've tried the following approach: // items is an array with 5 objects ...
      -3
      votes
      0answers
      16 views

      increase the number of rooms by 1 [closed]

      Friends, I have a dormitory automation project, I want it to increase the number of active people by 1 when enrolling in the rooms section, and reduce it by 1 when the person is deleted from the room, ...
      0
      votes
      0answers
      17 views

      SQL query to get customers who have purchased same product in two different quarters - Date Ranges

      I have a table Customer_Order_Data with these columns: customer_id order_id product_id quantity order_date I want to find the customers who have purchased the same product (product_id) in two ...
      0
      votes
      0answers
      17 views

      How to echo more than one row

      i have a database that allows a user id to appear as many times as the user wants eg id = 1902 the items beloging to this id is fish, bread, milk. same user has with same id on another row id = 1902 ...
      -2
      votes
      2answers
      22 views

      Select from multiple tables with group and join

      i have 4 tabels drinks, opskrifter, ingredients and stock the tables consist of drinks drink_id name beskriv glas image alcohol opskrifter drink_id ingredient_id quantity ingredients ...
      0
      votes
      1answer
      16 views

      How to make a query to get all groups of a user, showing the users that each group has (postgresql)

      This is an issue that I thought easy at first, but haven't been able to solve it. I got a table users(id, username, email) and another table groups(id, name). I got a third table that stores the many-...
      0
      votes
      0answers
      11 views

      Why does my XAMPP MySQL server crash again and again?

      Whenever I install XAMPP on my PC, it works fine for a few days or weeks. But after that, it suddenly stops working and not able to start the MySQL server. I search the issue on Google and do ...
      0
      votes
      0answers
      16 views

      send reference to API and redirect

      I need your help to guide me a bit. My goal is to scan products, then retrieve the scanned barcode to manage it with my API using this function: export async function getProductByRef(reference) { ...
      0
      votes
      0answers
      36 views

      Is It bad practice to have unique column with null value?

      Hello im designing a database for users.This is my model.The field EIK is unique and there will be a main user(with non null value EIK) which can add more users(null value EIK).Is it bad practice to ...
      0
      votes
      4answers
      30 views

      How to write a query to find a record which is not processed

      I am trying to write a query from a table A which has 2 columns : ID , STATUS The Status can be PROCESSING, NOTPROCESSED, FAILED, SUCCESS When a record is successfully processed, a new record is ...
      -2
      votes
      0answers
      525 views

      Block duplicates in SQL queries [closed]

      Introduction I am looking for a solution how to block duplicate SQL queries. Problem Currently, many users try to log in to the web server with the same name and email.
      0
      votes
      1answer
      10 views

      Adding new item to the start of MongoDB database with Express

      I have a mongoDB database storing a list of items: [{"_id":"0", a: "b"}, {"_id":"1", a: "c"}] To add a new item to the database via a POST ...
      -2
      votes
      0answers
      30 views

      Give the numbers to all month which are as string in my database, and next row to be autofill when user select any month [closed]

      I want to make this "month_no" field autofill, when the user sends or inserts data in the previous field which for_month as the month in string format I want month_no to be filed ...

      15 30 50 per page
      1
      2 3 4 5
      11634
      欧美日韩国产在线一区二区_午夜短视频在线观看_亚洲国产欧美日本视频_亚洲精品高清视频在线观看